|
5鱼币
最近我想用python写个小程序:
访问本地access数据库文件.accdb,通过关键字搜索其中内容,并将结果显示在交互界面上。
在一开始我就遇到了问题:
下载的工具pypyodbc,只支持.mdb的文件,没法访问.accdb文件。
请问,哪位鱼油能教教我,该用哪个工具去实现我的想法?
正确和错误代码如下:
Python 2.7.12 (v2.7.12:d33e0cf91556, Jun 27 2016, 15:19:22) [MSC v.1500 32 bit (Intel)] on win32
Type "copyright", "credits" or "license()" for more information.
>>> import pypyodbc
>>> conn=pypyodbc.connect(u'Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\salesdb.mdb')
>>> cur=conn.cursor()
>>> conn.close()
>>> conn1=pypyodbc.connect(u'Driver={Microsoft Access Driver (*.mdb,*.accdb)};DBQ=d:\list.accdb')
Traceback (most recent call last):
File "<pyshell#4>", line 1, in <module>
conn1=pypyodbc.connect(u'Driver={Microsoft Access Driver (*.mdb,*.accdb)};DBQ=d:\list.accdb')
File "build\bdist.win32\egg\pypyodbc.py", line 2277, in __init__
self.connect(connectString, autocommit, ansi, timeout, unicode_results, readonly)
File "build\bdist.win32\egg\pypyodbc.py", line 2325, in connect
check_success(self, ret)
File "build\bdist.win32\egg\pypyodbc.py", line 944, in check_success
ctrl_err(SQL_HANDLE_DBC, ODBC_obj.dbc_h, ret, ODBC_obj.ansi)
File "build\bdist.win32\egg\pypyodbc.py", line 922, in ctrl_err
raise Error(state,err_text)
Error: (u'IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified')
|
|