初学python,看的是网上的教程,在自己电脑上面用ptyhon连access数据发现怎么也连不通,有懂的大佬能不能指点一下啊
电脑环境是win7 64位 旗舰版SP1
python版本是3.8.0
Access数据库是2016 64位
python代码如下:
` import concurrent.futures import pandas as pd import pyodbc import accessdb import pypyodbc as odbc import matplotlib.pyplot as plt import numpy as np
DBfile = r"test.mdb" connection = pyodbc.connect(r"Driver={Microsoft Access Driver (.mdb,.accdb)};DBQ=" + DBfile + "Uid=;Pwd=;") connection_cursor = connection.cursor()
sql = "select * from sytb;"
connection_cursor.execute(sql) all_data = connection_cursor.fetchall() total_rows = len(all_data) total_cols = len(all_data[0])
df_temp = pd.io.sql.read_sql(sql,connection)
connection_cursor.close() connection.close()`
程序运行之后提示如下 :
Traceback (most recent call last): File "access.py", line 10, in connection = pyodbc.connect(r"Driver={Microsoft Access Driver (.mdb,.accdb)};DBQ=" + DBfile + "Uid=;Pwd=;") pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 (0) (SQLDriverConnect)')
ODBC数据源配置
百度搜索了很久一直无法解决问题,求大神指点一二!