Need help, major ODBC issues

Experts,

Over the last week I suffered a hdd crash.  Post restore, I now cannot use any of my previous database connections.

I'm unable to use previous ODBC connections due to a brand new error: The setup routines for the sybase system 10 odbc driver could not be loaded due to system error code 126

I've tried to locate an odbc installer for Windows XP Pro SP3 to no avail, also unable to locate a compatible MDAC installer.  I'm desperate, can anyone please provide some guidance?

Thanks,

M
Marv1nAsked:
Who is Participating?
 
OP_ZaharinCommented:
- have you look into the following method to delete the existing copy of sybase odbc files (i would recommend a rename or move to other folder first):
sysybnt.dll/sysyb95.dll/sysybw3.dll;
sybasnt.dll/sybas95.dll/sybasw3.dll;
syutlnt.dll/syutl95.dll/syutlw3.dll and syodbc.lic.

- reboot the machine then reinstall ODBC/MDAC.

- from the following link: http://www.dbforums.com/sybase/1217503-sybase-error-126-a.html

OP
0
 
lcohanDatabase AnalystCommented:
<<Over the last week I suffered a hdd crash.  Post restore, I now cannot use any of my previous database connections.>>

Where was the crash? Hopefully on the client and all you need is to find the driver(s) required to connect to the database server (which one is it??) then to used ODBC data sources and configure each ODBC you had before the crash.
0
 
Marv1nAuthor Commented:
Crash was on the client.

The key drivers not working are for Sybase.  I have been unable to locate replacement installations, can you advise as to how to re-install these?


Many thanks,

M
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
lcohanDatabase AnalystCommented:
I believe Sybase does not provide the driver indeed but you can still get some as per link below:

http://www.salmontraining.com/SybaseZone/articles/sybase_odbc_drivers_for_adaptive_server_enterprise.html

I personaly used SYBASE ODBC DRIVER from DATADIRECT - below:
http://www.datadirect.com/products/odbc/sybase/
0
 
Marv1nAuthor Commented:
Tried both, no success.  Any other ideas?


Thanks!
0
 
OP_ZaharinCommented:
- after the crash, did you re-apply service pack 3?

- the following link provide a step to repair mdac for XP on SP2 and SP3:
http://www.macropool.com/en/download/mdac_xp_sp2.html
0
 
lcohanDatabase AnalystCommented:
So after you installed one ODBC client driver you went to the ODBC DSN configuration and did you hit "Test Connection" button when you configured the data source?
0
 
Marv1nAuthor Commented:
@OP Zaharin -  yes, I re-installed SP3, and am now trying to use the guide you provided. I'll advise shortly if it worked.

@ lcohan - yes, I did that exactly, but get the above referenced error when even trying to configure or add a source using any of the Sybase drivers.
0
 
Marv1nAuthor Commented:
@OP Zaharin - no luck.  I'll download their MDAC repair tool and try that.

Any other ideas guys?


Thanks.
0
 
Marv1nAuthor Commented:
The MDAC tool didn't help either, still getting "The setup routines for the sybase system 10 odbc driver could not be loaded due to system error code 126"
0
 
lcohanDatabase AnalystCommented:
"@ lcohan - yes, I did that exactly, but get the above referenced error when even trying to configure or add a source using any of the Sybase drivers."

In that case the drivers did not installed properly. Can you at least see them listed under ODBC drivers tab?
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.