Using an Access database (.mdb) with Python on Ubuntu [duplicate]

Question

I'm trying to use pyodbc to access a .mdb on Ubuntu. I've based my progress so far on this link

I have installed pyodbc, unixodbc, and unixodbc-dev

My code looks like this:

import csv
import pyodbc

MDB = 'URY.mdb'
DRV ='Microsoft Access Driver (*.mdb)'
PWD = 'pass'

conn = pyodbc.connect('DRIVER=%s;DBQ=%s;PWD=%s' % (DRV,MDB,PWD))
curs = conn.cursor()

When I run it, I receive this error message:

Traceback (most recent call last):
  File "mdbscraper.py", line 8, in <module>
    conn = pyodbc.connect('DRIVER=%s;DBQ=%s;PWD=%s' % (DRV,MDB,PWD))
pyodbc.Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found,         and no default driver specified (0) (SQLDriverConnect)')

Does anyone have any ideas? Any help would be very much appreciated

Thank you!

I'm not familiar with Linux, but on Windows, this error would mean that you did not set up an ODBC connection in Control Panel -> Administrative Tools -> ODBC Connections. And you'd pass the Data Source Name (DNS) in the connection, not the name of file (that's in the DNS). — HardCode
– HardCode, Commented May 11, 2012 at 21:06
I think because I'm using a .mdb it's all local, so I don't need a DNS. Does that sound right? I'm basing it on the example at the top of this page code.google.com/p/pyodbc/wiki/ConnectionStrings — mythander889
– mythander889, Commented May 11, 2012 at 21:10
I think you still need to install an ODBC driver for MS Access. Easysoft sells one. easysoft.com/products/data_access/odbc-access-driver/index.html Supposedly mdbtools includes one but it's described as limited. mdbtools.sourceforge.net/install/x90.htm — HansUp
– HansUp, Commented May 11, 2012 at 21:19
Thank you. I found the necessary driver on their website as a tar. Do you know where I need to put it? — mythander889
– mythander889, Commented May 11, 2012 at 21:41
I never tried it. See their getting started guide. easysoft.com/products/data_access/odbc-access-driver/… — HansUp
– HansUp, Commented May 11, 2012 at 21:50

schoash · Accepted Answer · 2014-03-18 13:37:37Z

5

From what I know this driver "Microsoft Access Driver (*.mdb)" is only available on a Microsoft host, since you are on ubuntu, it won't work.

answered Mar 18, 2014 at 13:37

schoash

1761 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fakhir hanif Over a year ago

Yes I am with this answer so far. Please share if someone has the solution.

j0k · Accepted Answer · 2012-09-04 16:06:23Z

-3

import pyodbc 
DBfile = '/data/MSAccess/Music_Library.mdb'
conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+DBfile)
cursor = conn.cursor()
SQL = 'SELECT Artist, AlbumName FROM RecordCollection ORDER BY Year;'

for row in cursor.execute(SQL): # cursors are iterable
print row.Artist, row.AlbumName

cursor.close()
conn.close()

There is The Official Example .. of use ...

edited Sep 4, 2012 at 16:06

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Sep 4, 2012 at 15:49

Mools Gang

112 bronze badges

Collectives™ on Stack Overflow

Using an Access database (.mdb) with Python on Ubuntu [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related