I/O error when connecting to a database.

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.
XtinaShaolinAsked:
Who is Participating?
 
moduloConnect With a Mentor Commented:
PAQed with points refunded (150)

modulo
Community Support Moderator
0
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
XtinaShaolinAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.