hi Gray,

have you a 64 bit macine with python 32 bit installed on your pc ?
if yes may be the problem it's there ..
64 bit macine have a different loaction for odbc you need to use a different odbc administrator, try to use the one under,
C:\Windows\SysWOW64\odbcad32.exe

Regards,
Matteo


Il 23/01/2011 06:33, Gary L Smith ha scritto:

Dear Pythoners,

I need to access data in an MS Access 2003 database using Python 2.5 or 2.6 running in Windows7. Windows7 doesn't seem to have appropriate drivers for ODBC. My error messages consistently contain the phrase, "Data source name not found and no default driver specified."

While I see that others have run into the same problem, my web searches have only deepened my confusion -- questions are routinely answered with suggestions that turn out to not work in Windows7.

Suggestions such as SQL Alchemy or pyODBC don't solve the problem, because it still boils down to the missing drivers.

This is a volunteer effort, so even the Egenix product, mxODBC, at $69 is a little much.

Are there suitable open-source codes to get at Access 2003 data in Windows7? Please point me in a productive direction, or, it it's just not possible, put me out of my misery.

Cheers, Gary Smith


_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32


Nessun virus nel messaggio.
Controllato da AVG - www.avg.com <http://www.avg.com>
Versione: 10.0.1191 / Database dei virus: 1435/3396 - Data di rilascio: 22/01/2011


_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32

Reply via email to