Cannot Connect To 64bit Msaccess Database With 64bit Python 3.6.odbc Driver Error
Solution 1:
I personally have not dealt with 64-bit MS Office apps or drivers, however the Access Database Engine 2016 Redistributable contains a 64-bit version including ODBC drivers (I think).
For that matter, even the Access Database Engine 2010 Redistributable also has a 64-bit version.
You can also use ODBC Data Source Administrator to create and manage DSN (Data Source Name). There are separate administrator programs for 32-bit and 64-bit programs. On my Windows 10 machine, the shortcuts are under 'Windows Administrative Tools' and are labeled 'ODBC Data Source (32-bit)' and 'ODBC Data Source (64-bit)'.
By defining a DNS, you can specify which driver to use for opening the database. But you must also be able to refer to the DNS in your connection parameters, regrettably I am not familiar with how to do that in your python program. I at least hope this gives a hint on were to start.
Post a Comment for "Cannot Connect To 64bit Msaccess Database With 64bit Python 3.6.odbc Driver Error"