Help. I'm trying to move my web pages that use Microsoft Access Databases with ODBC from Windows Server 2000 to Windows Server 2008. The only ODBC drivers I see are for SQL Server. Can I still use Access data bases with Server 2008 ODBC?
I assume you are running a Windows Server 2008 64 BIT OS. Currently MS do not provide a 64-bit version of ODBC drivers for VisualFox Pro and Access.
Workaround: As long as the most application that you want to connect to is 32 bit, You can use the 32 bit ODBC drivers to create the DSN. To get to the 32 bit ODBC drivers, the 32 bit Data Source administrator must be used. The 32 bit Data Source administrator must be launched directly if they are using a 64 bit OS. The file should be located at the following path: c:\windows\sysWOW64\odbcad32.exe
This posting is provided "AS IS" with no warranties, and confers no rights.
Marked as answer byWilson JiaWednesday, April 07, 2010 8:59 AM
Monday, April 05, 2010 3:04 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.