Monday, February 20, 2012

Old SQL ODBC driver on 2003 Server

Anyone run into this.
I have a Windows 2003 Server which has a very old sql Server ODBC Driver
installed. If I go into Data Sources and view the SQL Server driver it is
dated back in 1997. Very old and I suspect that when someone installed 6.5
SQL Server tools, it overwrote the newer driver.
Bottom line, how do I re-install SQL Server Driver, or other ODBC drivers
for that matter on a 2003 server without reinstalling the OS?
Eric Correa
Windows Server Engineer
Try installing the latest MDAC (version 2.8, I think). You can get that from the Microsoft site.
"Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
news:7ADBEB08-8E19-4B1A-B25D-95CFEA94C915@.microsoft.com...
> Anyone run into this.
> I have a Windows 2003 Server which has a very old sql Server ODBC Driver
> installed. If I go into Data Sources and view the SQL Server driver it is
> dated back in 1997. Very old and I suspect that when someone installed 6.5
> SQL Server tools, it overwrote the newer driver.
> Bottom line, how do I re-install SQL Server Driver, or other ODBC drivers
> for that matter on a 2003 server without reinstalling the OS?
> --
> Eric Correa
> Windows Server Engineer
|||You cannot install MDAC 2.8 on a Windows 2003 Server. Not allowed.
Eric Correa
Windows Server Engineer
"Scot T Brennecke" wrote:

> Try installing the latest MDAC (version 2.8, I think). You can get that from the Microsoft site.
> "Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
> news:7ADBEB08-8E19-4B1A-B25D-95CFEA94C915@.microsoft.com...
>
>
|||You will need to run an "update install" of Windows 2003 (or you could
re-install Windows 2003 SP1).
An "update install" is you just pop in the Windows 2003 CD and say you are
going to install it. The setup will prompt you if you want to do an "update
install" say yes. This is sort of like a repair install so to speak.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Eric Correa" <EricCorrea@.discussions.microsoft.com> wrote in message
news:745D9A13-B613-41A0-A949-63D9B712597F@.microsoft.com...[vbcol=seagreen]
> You cannot install MDAC 2.8 on a Windows 2003 Server. Not allowed.
> --
> Eric Correa
> Windows Server Engineer
>
> "Scot T Brennecke" wrote:

No comments:

Post a Comment