pymmsql 和pyodbc 连接数据库都失败
pymmsql 和pyodbc都安装成功,import 也没有问题,但是调用connect时报错。代码和错误信息如下:
import pymmsql
conn = pymmsql.connect(host='172.0.0.1', user='sa', password='sa', database='test',charset='utf-8')
Traceback (most recent call last):
File "E:\Java\py27\src\test\test1.py", line 8, in <module>
conn = pymmsql.connect(host='172.0.0.1', user='sa', password='sa', database='amber_test',charset='utf-8')
AttributeError: 'module' object has no attribute 'connect'
import pyodbc
cnxn = pyodbc.connect('driver={SQL Server};server=localhost;database=test;uid=sa;pwd=sa')
cursor=cnxn.cursor()
Traceback (most recent call last):
File "E:\Java\py27\src\test\pyodbc1.py", line 7, in <module>
import pyodbc
File "E:\Java\py27\src\test\pyodbc.py", line 8, in <module>
AttributeError: 'module' object has no attribute 'connect'
求大神解答,网上找了几天了还是没解决问题