Solved

I/O error when connecting to a database.

Posted on 2004-10-12
5
2,929 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Suggested Solutions

Title # Comments Views Activity
SQL Sybase - Convert Rows to Columns 10 538
SQL Query 2 348
See the Access level(Read, Write, etc.) in Sybase databases 5 676
SQL Query Help! 11 130
While it may be true that the internet is a place of possibilities, it is also a hostile environment lurking with many dangers. By clicking on the wrong link, trusting the wrong person or using a weak password, you are virtually inviting hackers to …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 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