i am graham bloice and i am not the same person how is this possible
___
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
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
Gary:
I was able to track down a Windows 7 - 64 bit computer this morning.
Installed Python 3.1 (32 bit)
Installed pywin32-214 for py31 (32 bit)
Installed adodbapi 2.4 (to get the test.mdb database)
I was able to read the data correctly. No Microsoft office components were
installed.
(I also
On 1:59 PM, Gary L Smith wrote:
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
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
I think Tim's last suggestion is the way to go, and you should NOT need
ACCESS installed.
Microsoft invented ODBC.
Everybody saw it was a great idea and adopted it.
So Microsoft had to invent something even newer, which everybody else does
not support. That's called ADO. ADO defaults to ODBC
If you run out of other options, I've successfully used comtypes on top
of the ctypes module included in Python 2.5 2.6 to read write data
in Access 2003 databases.
Regards,
Andrew MacIntyre.
- These thoughts are mine alone! -
Andrew MacIntyre
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.