?
Solved

I/O error when connecting to a database.

Posted on 2004-10-12
5
Medium Priority
?
3,004 Views
Last Modified: 2008-01-09
I'm using version 8.0 to connect to a 5.0 database.  I bring up Sybase Central, make sure the service is running, then go to Tools > Connect.  In Identification, I put in the user and password.  In Database, I search for the service name (just to be on the safe side), and I put in the name of the .db file.  Everything else I leave to defaults.  I then get this error:

Could not connect to the database.
ASA Error -82: Unable to start specified database: I/O error
JZ00L: Login failed. Examine the SQL warnings chained to this exception for the
reason(s).
  Error code=0
  SQL state=JZ00L
ASA Error -82: Unable to start specified database: I/O error
  Error code=840
  SQL state=01W09

Sybase's list of error message explanations shows nothing useful.

01W09 = "More information is required to complete the request. This is used internally in the database interface library to process a unified login. It should not be returned to an application."
-82 = "The database server was started but was unable to find the specified database. No specific reason is known."

Ideally, I'd like to connect to the database.  If all I can do is extract the information, that's fine as well.
0
Comment
Question by:XtinaShaolin
3 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 12294455
Can you provide more details on how the server is started?

This error suggests we can't connect to the database because we haven't specified it correctly and/or have not started it correctly.

ASA distinguishes between the server and the database, so it is possible the former has been started but not the latter. We could confirm this by looking at the ASA server errorlog boot sequence.
0
 

Author Comment

by:XtinaShaolin
ID: 12539849
Bwa, oops!  My mistake.

The problem was resolved due to the database being restored from backup.  Do I give out the points, or just let them go?
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12642271
PAQed with points refunded (150)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
If anyone asked you to network diagram of the internet, it was drawn in the form of a fluffy cloud which further became known as cloud computing. Popularly cloud computing is defined as workloads that run over the internet in a commercial provider’s…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question