configuring ODBC DSN with a python script

[Jani Yusef]

I am building an application which, unfortunately, *must* use an
access db. The users will have the relevane mdb file installed on
their system. As part of the installer. Now, the part I am stuck on is
how do I configure the ODBC dsn without having the user open up the
ODBC control panel which will in all honestly just scare and confuse
them.
Has anyone approached this problem before? What did you do?
Thanks!!

 

[Jarek Zgoda]

I am building an application which, unfortunately, *must* use an
access db. The users will have the relevane mdb file installed on
their system. As part of the installer. Now, the part I am stuck on is
how do I configure the ODBC dsn without having the user open up the
ODBC control panel which will in all honestly just scare and confuse
them.

Use ADO -- the connection structure is much more straightforward.

 

[Andy Robinson]

I am building an application which, unfortunately, *must* use an
access db. The users will have the relevane mdb file installed on
their system. As part of the installer. Now, the part I am stuck on is
how do I configure the ODBC dsn without having the user open up the
ODBC control panel which will in all honestly just scare and confuse
them.
Has anyone approached this problem before? What did you do?
Thanks!!

Most drivers let you pass this in at runtime by building a string with
a number of key/value parameters. With Access, the magic one
is Dbq which refers to the file name. This works for me....

(*.mdb)};Dbq=c:\\mydir\\myfile.mdb;Uid=Admin;Pwd=
;")

cur = conn.cursor()
cur.execute('select count(*) from Codes')
cur.fetchall() [(1144,)]

- Andy Robinson

p.s. Steve Holden tipped me of

 

[Jean-Yves Vinet]

Do some research on internet with 'ODBC connection string', It's
possible to access to a mdb database directly without using the
ODBC control panel.You have to open your database with a
connection string like that:

Driver={Microsoft Access Driver
(*.mdb)};Dbq=c:\somepath\mydb.mdb;Uid=the_user;Pwd=the_password

JYV

 

[Jean-Yves Vinet]

He is a good site about that

http://www.able-consulting.com/ADO_Conn.htm

JYV