我在VBA中有一个从SQL服务器读取的代码,其参数设置如下。你知道吗
Global Const my_db = "Driver={SQL Server};Server=my_server;Initial Catalog=my_catalog;UID=user;PWD=opensesame;"
但是,这样翻译成Python对我不起作用:
import _mysql
db=_mysql.connect(host="my_server",user="user",passwd="opensesame",db="my_db")
我收到的错误是
Traceback (most recent call last):
File ".\db_test.py", line 6, in <module>
db=_mysql.connect(host="my_server",user="user",passwd="opensesame",db="my_db")
File "C:\python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "C:\python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'my_server' (10061)")
我做错什么了?你知道吗
您的SQL server是MS SQL server。VBA脚本通过端口1433连接到SQL server。 Python脚本正在尝试连接到端口3306(MySQL的默认端口)上的MySQL服务器。你知道吗
试试这个:
导入pyodbc
cnxn=pyodbc.connect连接('DRIVER={SQL Server};Server=my\u Server;Initial Catalog=my\u Catalog;UID=user;PWD=opensesame'
相关问题 更多 >
编程相关推荐