I Have "SQL Native Client", but not "SQL Server" ODBC driver. I have SQL 2005 installed on my machine.
Tried to fix by installing SQL Server client tools.
Any ideas would be appreciated.
I'm running Windows XP Pro.
+2
A:
Found this Microsoft download. It says it provides the SQL Server ODBC driver.
Edit: Here's the SP1 download: Service Pack 1.
Ben Robbins
2008-10-02 21:37:09
I get an error... MDAC 2.8 RTM - MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows.
Greg Ogle
2008-10-02 21:54:24
So, just to give a reason, if you >= XP SP2, it already has MDAC 2.8. Thanks for the info, it lead me in the right direction.
Greg Ogle
2008-10-02 21:58:42
A:
I found an article on repairing MDAC.
Here is the short
1. In Windows Explorer, open the c:\Windows\Inf folder.
Note If you cannot see the c:\Windows\Inf folder, follow these steps:
a. On the desktop, double-click My Computer, and then on the Tools menu, click Folder Options.
b. Click the View tab.
c. Under Advanced settings, select the Show hidden files and folders check box.
d. Clear the Hide extensions for known file types check box.
e. Click OK.
2. In the C:\Windows\Inf folder, right-click the Mdac.inf file, and then click Install.
...
Greg Ogle
2008-10-02 21:56:52
A:
You can also try the OpenLink ODBC Drivers for SQL Server. These support older and newer versions of SQL Server (from 4.2 up to very latest release).
Kingsley Idehen
2010-05-06 20:36:21