Windows Forum

Ask something
Discussion Locked

How to remove SQL 2000 driver?

0 helpful
3 replies

by esrfalco

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We had loaded an app that used the SQL 2000 ODBC driver. Now we unloaded that app, and have a new one that needs the older SQL driver to function reliably. When we install SQL 7, it does NOT overwrite the SQL 2000 driver that still remains from the previous app.

So, how do I remove the SQL 2000 ODBC driver, and overwrite it with the SQL 7 (3.70) driver? Thanks.

3 replies

by jiglover

Let's start by saying I am not an expert in this but I have had to deal with ODBC and SQL driver issues.

First, it might be that you need to reconfigure your System DSN settings for your program. The SQL 7 driver may still be there but it's trying to connect to the SQL 2000 database.

In anycase, these settings are found in control panel - ODBC Data Sources (32 bit). Go to the System DSN tab. See if the old 2000 odbc is listed here. If so, you can remove it. This is also the place where you can add the SQL 7 ODBC if it is not in the list. (If it is in the list you can reconfigure the settings, as well.)

If you're missing the 7 odbc from the list you might be able to download it from MSFT. You're looking for the Microsoft Data Access Components (MDAC), but I'm not much help as to which MDAC has the 3.7 ODBC driver.

I also can't tell you how to configure an existing 3.7 ODBC that might be looking for the uninstalled 2000 database.

Hope this helps and for what it's worth - I wouldn't start changing stuff around without a good back up or a nice weekend to put things back together if something goes wrong.

This discussion is closed to new replies.