Link to home
Start Free TrialLog in
Avatar of bwalker9
bwalker9

asked on

Sybase ODBC probs

I am using Patterson Dental's Eaglesoft program that uses a sybase database.  I am frequestly getting ODBC errors that read :

sybase)(odbc driver)(adaptive server anywhere) unable to connect to database server: specified database is invalid.

I also get other errors that are similar.  
I am using XP SP2 and windows small Buisness server with ISA.  I have put the EagleSoft in as an exemption on the ISA firewall clients, turned off all power management (set it to always on) and checked the DSN, they look fine.

ANy ideas?

Avatar of Jim P.
Jim P.
Flag of United States of America image

Do you have the database installed as a service and always up?
Avatar of bwalker9
bwalker9

ASKER

The company did the install, but I assume so.  Should I check under services and "database name"?  If that is not it what else could be going on?
Check the services -- It may say something like "Adaptive Sever Anywhere -- DBName".

Also go into regedit, and dump the ODBC key for the the database.  Make sure that you take out/mask the password.
ASKER CERTIFIED SOLUTION
Avatar of csachdeva
csachdeva

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No objections.