locked
Windows Server 8 and Microsoft Access Database with ODBC

    Question

  • 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?

    Saturday, April 03, 2010 1:42 AM

Answers

  • Hi,

    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

    For more information about Acess and VisualFOX Pro's ODBC driver, you may refer to:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;957570

    Visual FOXPRO ODBC Drivers for windows Vista


    http://social.msdn.microsoft.com/Forums/en/visualfoxprogeneral/thread/2aab1577-dec9-4d0f-9d38-511a9f1b2db0

    Hope it helps.

    Regards,
    Wilson Jia


    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by Wilson Jia Wednesday, April 07, 2010 8:59 AM
    Monday, April 05, 2010 3:04 AM