参见英文答案 >
Working with an Access database in Python on non-Windows platform (Linux or Mac)4个
我正在尝试使用pyodbc访问Ubuntu上的.mdb.到目前为止,我的进展基于此链接
我安装了pyodbc,unixodbc和unixodbc-dev
我的代码看起来像这样:
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()
当我运行它时,我收到此错误消息:
Traceback (most recent call last):
File "mdbscraper.py",line 8,in
conn = pyodbc.connect('DRIVER=%s;DBQ=%s;PWD=%s' % (DRV,PWD))
pyodbc.Error: ('IM002','[IM002] [unixODBC][Driver Manager]Data source name not found,and no default driver specified (0) (sqlDriverConnect)')
有没有人有任何想法?任何帮助将非常感谢
谢谢!