Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

I/O error when connecting to a database.

Posted on 2004-10-12
5
Medium Priority
?
2,981 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Let's take a look into the basics of ransomware—how it spreads, how it can hurt us, and why a disaster recovery plan is important.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
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

618 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