Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database Start up Problem

2 posts in General Discussion Last posting was on 2010-02-16 07:32:17.0Z
Partha Posted on 2010-02-15 14:20:43.0Z
Sender: 6cf.4b795618.1804289383@sybase.com
From: Partha
Newsgroups: ianywhere.public.general
Subject: Database Start up Problem
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b79583b.707.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Feb 2010 06:20:43 -0800
X-Trace: forums-1-dub 1266243643 10.22.241.41 (15 Feb 2010 06:20:43 -0800)
X-Original-Trace: 15 Feb 2010 06:20:43 -0800, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7894
Article PK: 6926

Hi,

When I am trying to start the database through ODBC or
dbsrv9.exe or dbeng9.exe, I have got the following error :

"cannot open transaction log file -- I/O error"

I have delete the log file & try to connect the database it
does not create a new log file & not connected.

How I will connect the database?


Breck Carter [TeamSybase] Posted on 2010-02-16 07:32:17.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Database Start up Problem
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <o8ikn5t1a9pbk1o1n4vklse6ci59lng055@4ax.com>
References: <4b79583b.707.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 15 Feb 2010 23:32:17 -0800
X-Trace: forums-1-dub 1266305537 10.22.241.152 (15 Feb 2010 23:32:17 -0800)
X-Original-Trace: 15 Feb 2010 23:32:17 -0800, vip152.sybase.com
Lines: 41
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7895
Article PK: 6924

Try running dblog.exe to see if the transaction log is located where
you think it is. The location of the log file is recorded inside the
database file, and sometimes it implicitly becomes invalid when you
move the database from one location to another.

PAUSE Have you shut down the database?
"%ASANY9%\win32\dblog.exe" ddd.db
PAUSE

You can also use the dblog.exe to change the location of the log file;
e.g., to the same folder as the database:

PAUSE Have you shut down the database?
"%ASANY9%\win32\dblog.exe" -t ddd.log ddd.db
PAUSE

On 15 Feb 2010 06:20:43 -0800, Partha wrote:

>Hi,
>
>When I am trying to start the database through ODBC or
>dbsrv9.exe or dbeng9.exe, I have got the following error :
>
>"cannot open transaction log file -- I/O error"
>
>I have delete the log file & try to connect the database it
>does not create a new log file & not connected.
>
>How I will connect the database?

--
Breck Carter - Blog: http://sqlanywhere.blogspot.com/

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail