| Issue 203: | Microsoft Access Connection string on diferrent python architectures. | |
| 1 person starred this issue and may be notified of changes. | Back to list |
Perhaps this is not a bug, but I found it a bit counterintuitive. I run windows 7 x64. The ODBC driver is
MS Access Database : Microsoft Access Driver (*.mdb, *.accdb)
What i found peculiar is that in order to connect to an Access DB, I had to use different connections strings for python x86 and python x64. Pyodbc version 2.1.9 and python 2.7.2
x86 : Microsoft Access Driver (*.mdb)
x64 : Microsoft Access Driver (*.mdb, *.accdb)
running the following script on python 2.7 results on the same output regardless of the architecture
>>> import pyodbc
>>> print pyodbc.dataSources()
{'MS Access Database': 'Microsoft Access Driver (*.mdb, *.accdb)',
'dBASE Files': 'Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)',
'Excel Files': 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, .xlsb)'}
Is this behavior normal? Is it possible to get somehow the correct driver from within pyodbc?
Sep 13, 2011
Project Member
#1
mkleehammer
Status:
NoFix
|