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@python.org http://mail.python.org/mailman/listinfo/tutor
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
