[Tutor] Intro for interfacing with Microsoft Access?
Kent Johnson
kent37 at tds.net
Sat Jan 15 13:28:12 CET 2005
You have to set up your Access database as an ODBC data source. I can't give you all the details but
on my Win2k system if I go to Start / Control Panels / Administrative Tools / Data Sources (ODBC)
that is the place to set it up.
IIRC you give the data source a name. Then in the ODBC driver (the win32all odbc package) you create
a connection giving it the data source name and probably a user name and password. When it's all set
up you can use SQL to talk to the database.
You might have to fiddle a bit to get all the pieces set up :-)
It looks like the win32all package uses the Python DB-API so you can read about that (find the
database SIG at python.org) for some help in how to use it.
I did this long ago from Java so I'm pretty sketchy on the details, maybe someone else is more
current on it than me.
Kent
Terry Carroll wrote:
> On Fri, 14 Jan 2005, Kent Johnson wrote:
>
>
>>A couple of minutes of googling for 'python odbc' finds the ODBC driver
>>that comes with win32all. It seems to have a fairly simple interface.
>>The download from this page has an example:
>>http://py.vaults.ca/apyllo2.py/D906422565
>
>
> Thanks, Kent. I'm not familiar with OBDC, but I'll look into it.
>
>
> _______________________________________________
> Tutor maillist - Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
More information about the Tutor
mailing list