Adding ODBC drivers in Windows Server 2008 – 64bit

Going to the Administrative Tools and open the ODBC Data Source Administrator window and add a new DSN for the .mdb and lo and behold I see the following nearly empty window:

This of course is no good! Where are all the other data drivers? Apparently all the regular ones we are used to seeing in 32bit Windows no longer exist as 64bit drivers.  The trick is to execute %windir%\SysWOW64\odbcad32.exe.

 

 

 

This will give you the ability to add the rest of the 32bit Data Sources such as Microsoft Access (.mdb).

 

 

 

 

 

You may also like