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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
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
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/
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Marv1nAuthor Commented:
Tried both, no success.  Any other ideas?


Thanks!
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
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?
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.
Marv1nAuthor Commented:
@OP Zaharin - no luck.  I'll download their MDAC repair tool and try that.

Any other ideas guys?


Thanks.
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"
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.