Clever Geek Handbook

How do I reinstall MDAC on SQL Server 2008?

I am having problems connecting to my SQL Server 2008 and think it might be an MDAC related issue. Is there a download to reinstall them?

+1


source to share


5 answers


MDAC 2.8 SP1

Remember MDAC is client software and should not be installed on the server.



Your problem is more likely related to a protocol or firewall error. Can you provide more information?

+2


source


I agree with gbn; make sure you allow remote connections on the SQL server, it is disabled by default in some versions; use Configuration Manager on the server to make sure TCP / IP is enabled.



+1


source


MDAC is an ODBC driver for client access. But you need it for ASP and ASP.Net database connections.

MDAC 2.8 SP1 is not installed on Windows 2008 Server because it was designed for an older version of Windows.

You might be able to enable access, I think in IIS 6.0 32 bit drivers and programs are disabled by default. See this Microsoft Forum entry for more information: http://forums.iis.net/p/1146917/1882658.aspx#1882658

You need to check your application pool settings for IIS and see if allowed 32-bit applications is set to true, if set to false change it to true and restart IIS. The MDAC and ODBC drivers are 32 bit, and you need to enable 32 bit access to applications in the application pools as 64 bit versions of Windows 20008 Server RC1 / RC2 is set to false by default.

See if this solves your problem.

I even tried to install MS-Office but still don't have access to the database. Until I enabled 32-bit access in the application pool.

+1


source


First use the MDAC checker, it will tell you if there is a problem with your MDAC:

http://support.microsoft.com/kb/307255

0


source


I ran into this recently, they renamed MDAC to WDAC in Server 2008, which is really throwing your search strings out. To fix WDAC you need to run a scan of the system file "sfc / scannow"

0


source






More articles:


All Articles