Problem
When we try to create a DSN in windows 7 with 64 bit, the drivers for the microsoft access is not visible.
Only sql server drivers are displayed.
Solution
To solve this issue you must launch the ODBC driver dialog window using below exe file.
When you open the ODBC manager from above exe file, all 32-bit drivers are displayed including ms-acess (.mdb and .accdb ) and you can create a dsn for access database.
What do you think on this topic? Please express your opinion through comment below
When we try to create a DSN in windows 7 with 64 bit, the drivers for the microsoft access is not visible.
Only sql server drivers are displayed.
Solution
To solve this issue you must launch the ODBC driver dialog window using below exe file.
c:\windows\sysWOW64\odbcad32.exe
When you open the ODBC manager from above exe file, all 32-bit drivers are displayed including ms-acess (.mdb and .accdb ) and you can create a dsn for access database.
What do you think on this topic? Please express your opinion through comment below
