[DB-SIG] Newbie DSN-less ODBC help

M.-A. Lemburg mal@lemburg.com
Wed, 08 Aug 2001 09:46:01 +0200

Scott Griffitts wrote:
> Hello.
> I am able to connect to an Access db using:
> import dbi, odbc
> DSN = 'sysdsn1'
> s = odbc.odbc(DSN)
> but I would like to make a DSN-less connection.  Could someone please explain how to that for a db located at
> I:\\test1\test2.mdb

Check the mxODBC docs for a section on file DSNs. You basically
use the name FILEDSN instead of DSN to connect to a file.

Marc-Andre Lemburg
CEO eGenix.com Software GmbH
Consulting & Company:                           http://www.egenix.com/
Python Software:                        http://www.lemburg.com/python/