King Computer Solutions

Windows 2008 server missing MDB Access ODBC drivers to create system DSN

In migrating a website which used an access MDB ODBC driver to link to a database from a Windows 2003 server to a Windows 2008 64-bit operating system, I found when I went to create the ODBC driver for the database,

ODBC Driver from Control Panel -> Administrative Tools -> Data Source (ODBC), I could only find the following two drivers listed:

  • SQL Native Client
  • SQL Server

SQL Server data source only showing on Windows 2008 server

This is because the 64-bit version of ODBC Data Source Administrator only lists 64-bit version of drivers.

To view 32-bit version of ODBC Driver, you can use the C:\Windows\SysWOW64\odbcad32.exe instead.

Other things to note:

Use the 32 bit ODBC Data Source Administrator to create a System DNS with the appropriate name, password and file,

Make sure the permissions on the database folder and file include Modify permissions for the IUSR and LOCAL SERVICE accounts.