reinstalling SQL ODBC Drivers on Windows XP

Apparently one of my users lost their ODBC drivers for SQL Server.
When I try to run the program that uses those drivers obviously I get
all kind of errors.
I tried going into the ODBC administrator and when I try to edit or
delete the DSN I get a message about the drivers being missing and I
need to reinstall them.
I tried running MDAC 2.7 and everything ran, but I still get the error.
MDAC 2.8 will not run on that machine - it gives a message saying that
Windows XP already has all of the files associated with MDAC 2.8.
Any ideas on how to reinstall the drivers in a case like this?
Thanks."Matt Bateman" <mattcb@.gmail.com> wrote in message
news:1155132832.189431.183410@.n13g2000cwa.googlegroups.com...
> Apparently one of my users lost their ODBC drivers for SQL Server.
> When I try to run the program that uses those drivers obviously I get
> all kind of errors.
> I tried going into the ODBC administrator and when I try to edit or
> delete the DSN I get a message about the drivers being missing and I
> need to reinstall them.
> I tried running MDAC 2.7 and everything ran, but I still get the error.
> MDAC 2.8 will not run on that machine - it gives a message saying that
> Windows XP already has all of the files associated with MDAC 2.8.
> Any ideas on how to reinstall the drivers in a case like this?
>
Not really, but you can install the SQL Native Client, which contains a
brand-new, MDAC-independant ODBC driver for SQL Server.
Microsoft SQL Server Native Client
http://msdn.microsoft.com/data/ref/sqlnative/
David

reinstalling SQL ODBC Drivers on Windows XP

Apparently one of my users lost their ODBC drivers for SQL Server.
When I try to run the program that uses those drivers obviously I get
all kind of errors.
I tried going into the ODBC administrator and when I try to edit or
delete the DSN I get a message about the drivers being missing and I
need to reinstall them.
I tried running MDAC 2.7 and everything ran, but I still get the error.
MDAC 2.8 will not run on that machine - it gives a message saying that
Windows XP already has all of the files associated with MDAC 2.8.
Any ideas on how to reinstall the drivers in a case like this?
Thanks."Matt Bateman" <mattcb@.gmail.com> wrote in message
news:1155132832.189431.183410@.n13g2000cwa.googlegroups.com...
> Apparently one of my users lost their ODBC drivers for SQL Server.
> When I try to run the program that uses those drivers obviously I get
> all kind of errors.
> I tried going into the ODBC administrator and when I try to edit or
> delete the DSN I get a message about the drivers being missing and I
> need to reinstall them.
> I tried running MDAC 2.7 and everything ran, but I still get the error.
> MDAC 2.8 will not run on that machine - it gives a message saying that
> Windows XP already has all of the files associated with MDAC 2.8.
> Any ideas on how to reinstall the drivers in a case like this?
>
Not really, but you can install the SQL Native Client, which contains a
brand-new, MDAC-independant ODBC driver for SQL Server.
Microsoft SQL Server Native Client
http://msdn.microsoft.com/data/ref/sqlnative/
Davidsql