无法使用pyodbc连接到Access DB [英] Cannot connect to Access DB using pyodbc
问题描述
几天来我一直在反对这个问题.我正在尝试使用pyodbc连接到Microsoft Access DB,但似乎无法正确获得连接字符串.这就是我正在使用的:
I've been beating my head against this for a few days now. I'm trying to use pyodbc to connect to a Microsoft Access DB, and I can't seem to get the connection string right or something. This is what I'm using:
cnxn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Path\to\file.accdb')
我不断收到错误消息:
Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnectW)')
即使我运行dataSources()
时,我也会看到:
Even though when I run dataSources()
I see:
{'MS Access Database': 'Microsoft Access Driver (*.mdb, *.accdb)', 'dBASE Files': 'Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)', 'Excel Files': 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)'}
这里有我严重失踪的东西吗?
Is there something I'm severely missing here?
推荐答案
这是一个64位的问题.我使用32位python和pyodbc解决了这个问题.
This is a 64-bitness problem. I solved it by using 32-bits python and pyodbc.
这篇关于无法使用pyodbc连接到Access DB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!