[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

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
0
Marv1n
Asked:
Marv1n
  • 5
  • 4
  • 2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
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:
"@ 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now