[python-win32] odbc under windows 7?

[Matteo Boscolo]

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 at 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
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20110123/943cdb0c/attachment.html>