I am having problems when connecting to my SQL server 2008 and think it might be a problem related to MDAC. Is there a download to re-install these?
+2
A:
Remember, MDAC is client software that should not be installed on the server.
Your problem is more likely a protocol or firewall error. Can you give more info please?
gbn
2008-11-23 15:19:46
Microsoft: Overview:Microsoft Data Access Components (MDAC) 2.8 SP1 contains core Data Access components such as the Microsoft SQL Server™ OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.8 SP1 release installs the same Data Access components as Microsoft Windows XP SP2.XP SP2 is really outdated isn' it? The Question goes about SQL Server 2008 but i don't know which version of OS - i guess win2008.What is the correct MDAC Version for this kind of OS (64-bit)?
Ice
2009-11-16 22:24:39
+1
A:
I agree with gbn; check that you are allowing remote connections on the SQL server, it is disabled by default in some versions; use the Configuration Manager on the server to verify TCP/IP is enabled.
SqlACID
2008-11-23 15:40:51
A:
Use the MDAC checker first, it will tell you if there's a problem with your MDAC:
Booji Boy
2008-12-02 03:57:02
Are you sure: Article ID: 307255 - Last Review: March 27, 2007 - Revision: 12.2Is there anything newer, for some recent os-versions like win2008?
Ice
2009-11-16 22:27:22
unless windows 2008/2008 R2 come with something newer than MDAC 2.8 SP1 then I'd expect it to work. It's not entirly clear from the FAQ http://msdn.microsoft.com/en-us/library/ms692877(VS.85).aspx
Booji Boy
2009-11-18 15:05:20