在Ubuntu上通过Python使用Access数据库(.mdb) [英] Using an Access database (.mdb) with Python on Ubuntu

问题描述

我正在尝试使用pyodbc在Ubuntu上访问.mdb.到目前为止，我已经基于此链接取得了进展

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

查询在MS Access中崩溃

我已经安装了pyodbc，unixodbc和unixodbc-dev

I have installed pyodbc, unixodbc, and 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()

当我运行它时，我收到以下错误消息:

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

谢谢！

推荐答案

据我所知，该驱动程序"Microsoft Access Driver(* .mdb)"仅在Microsoft主机上可用，因为您使用的是ubuntu，因此不会.工作.

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.

这篇关于在Ubuntu上通过Python使用Access数据库(.mdb)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！