On 24/01/2011 18:46, Tim Roberts wrote: > Gary L Smith wrote: >> >> >> 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. >> > Do you have Access installed on this machine? That's always been one of > the downsides of Access -- you have to have the Access run-time > installed to use an Access database. > > Note that ODBC does not really have anything to do with Access. ODBC is > just a generic database layer. If you don't have the Access runtime, > then even mxODBC won't get you into the data. From the message, it > sounds like you are getting into ODBC just fine, but there is no ODBC > Access driver installed. > > Have you tried ADODB and direct DAO access? Both of them can be used > with Access, although again without the runtime, I think you're in trouble.
Originally set to Tim instead of the list, sorry for that. I'm not so sure about this. The Jet drivers (32 bit only) which can be used from ODBC have been supplied with every MS OS (even 64 bit ones). I've used this driver and ODBC to access .mdb files without Office or Access ever having been near machines. To see the drivers on your machine run up odbcad32.exe and check the drivers tab. To see 32 bit drivers on a 64 bit machine run Windows\SysWOW64\odbcad32.exe There is no 64 bit Jet driver, but from Office 2007 on, MS produced the ACE drivers (which are also available as a separate redistributable) which do appear in a 64 bit guise. Unfortunately I haven't been impressed with the drivers stability when multithreading. -- Regards, Graham Bloice _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
