在我的C ++程序中,我习惯了连接过程,提示输入密码丢失或者让您选择自己的连接。 当我使用pyodbc.connect()时,会生成异常。
Traceback (most recent call last): File "<pyshell#41>", line 1, in <module> c=pyodbc.connect('') Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnectW)')连接字符串的pyodbc文档声明pyodbc调用C函数SQLDriverConnect 。 提示行为由DriverCompletion参数控制,我看不到从Python设置该参数的方法。
In my C++ programs, I'm used to the connection process prompting for a missing password or letting you select your own connection. Whe I use pyodbc.connect(), an exception is generated instead.
Traceback (most recent call last): File "<pyshell#41>", line 1, in <module> c=pyodbc.connect('') Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnectW)')The pyodbc documentation for Connection Strings states that pyodbc calls the C function SQLDriverConnect. The prompting behavior is controlled by the DriverCompletion parameter, and I can't see a way to set that parameter from Python.
最满意答案
我不确定你是否可以,我只是检查了源代码,看起来它总是发送SQL_DRIVER_NOPROMPT。
请参见connection.cpp中的第88行
I'm not sure if you can, I just checked the source for this and it seems like it always sends SQL_DRIVER_NOPROMPT.
See line 88 in connection.cpp
更多推荐
发布评论