My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 203: Microsoft Access Connection string on diferrent python architectures.
1 person starred this issue and may be notified of changes. Back to list
Status:  NoFix
Owner:  ----
Closed:  Sep 2011


 
Reported by pmav99@gmail.com, Aug 23, 2011
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
This is the correct behavior, I believe.  ODBC drivers are DLLs, so 32-bit and 64-bit would need to be different, but they might be registered in the same place.

I don't believe there is a way to get the list of drivers.  On Windows, it's in the registry.  Unix, Linux, and OS/X using configuration files.  It would be nice to have an API for that.

Status: NoFix

Powered by Google Project Hosting