Can I make a DSN-less connection using pyodbc and mdbtools?

Question

I've tried the following:

>>> import pyodbc

>>> cnxn = pyodbc.connect(Driver="MDB", database="SohabeD51.mdb")
pyodbc.Error: ('08001', '[08001] [unixODBC]Could not find DSN in
                connect string (1) (SQLDriverConnectW)')

Connecting to a database using a DSN entry works fine, but I'd like to supply a database in the code.

Can you share how you were able to connect using the DSN entry? What was your connection string for pyodbc? — Karthic Raghupathi, Dec 08 '13 at 03:19

score 2 · Answer 1 · answered Nov 20 '09 at 09:33

2

No. Mdbtools 0.5 don't support this.

answered Nov 20 '09 at 09:33

Georg Schölly

124,188
49
220
267

score 2 · Accepted Answer · answered Apr 29 '14 at 19:25

2

I know this is an old question, but actually (0.7.1) MDBTools DOES support DSN-less connections. The syntax for the connection string is something like

DRIVER=Microsoft Access Driver (*.mdb);DBQ=/path/to/your/file.mdb;UID=;PWD=;

You can download it from Github and compile it to ensure you are up to date:

https://github.com/brianb/mdbtools

answered Apr 29 '14 at 19:25

Pere

1,068
12
20

Not tested, as this is an old question. – Georg Schölly Apr 30 '14 at 07:39

score 0 · Answer 3 · answered Sep 29 '09 at 16:54

0

Here's what you need: http://code.google.com/p/pyodbc/wiki/ConnectionStrings

answered Sep 29 '09 at 16:54

Can I make a DSN-less connection using pyodbc and mdbtools?

3 Answers3