脚本语言
使用adodbapi连接MS SQL SERVER2000数据库出错？
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区我下载了pywin32-202.win32-py2.3.exe和adodbapi-2.0.1
使用adodbapi来连接数据库
在IDLE下输入：
import adodbapi
>>> con=adodbapi.connect("Driver={SQL Server};Server=localhost;Database=scb_db_12;Uid=sa;Pwd=")
>>> cur=con.cursor()
>>> cur.execute("select * from billrec;")
>>> cur.fetchall()
没什么问题，然后我输入：
cur.execute("select * from billmsg;")
可是出来一大堆错误：
Traceback (most recent call last):
File "<pyshell#6>", line 1, in -toplevel-
cur.execute("select * from billmsg;")
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 592, in execute
self.executeHelper(operation,0,parameters)
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 552, in executeHelper
self._raiseCursorError(DatabaseError,tracebackhistory)
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 407, in _raiseCursorError
eh(self.conn,self,errorclass,errorvalue)
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 38, in standardErrorHandler
raise errorclass(errorvalue)
DatabaseError:
-----------
Strategy 1: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
-----------
Strategy 2: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
-----------
Strategy 3: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
-----------
Strategy 4: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
--- ADODBAPI on command:select * from billmsg; with parameters: None
不知道为什么，查了一些资料，还是不能解决。数据库中存在billmsg表，select * from billmsg也没错啊。
使用adodbapi来连接数据库
在IDLE下输入：
import adodbapi
>>> con=adodbapi.connect("Driver={SQL Server};Server=localhost;Database=scb_db_12;Uid=sa;Pwd=")
>>> cur=con.cursor()
>>> cur.execute("select * from billrec;")
>>> cur.fetchall()
没什么问题，然后我输入：
cur.execute("select * from billmsg;")
可是出来一大堆错误：
Traceback (most recent call last):
File "<pyshell#6>", line 1, in -toplevel-
cur.execute("select * from billmsg;")
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 592, in execute
self.executeHelper(operation,0,parameters)
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 552, in executeHelper
self._raiseCursorError(DatabaseError,tracebackhistory)
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 407, in _raiseCursorError
eh(self.conn,self,errorclass,errorvalue)
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 38, in standardErrorHandler
raise errorclass(errorvalue)
DatabaseError:
-----------
Strategy 1: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
-----------
Strategy 2: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
-----------
Strategy 3: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
-----------
Strategy 4: Traceback:Traceback (most recent call last):
File "D:\Python23\Lib\site-packages\adodbapi\adodbapi.py", line 487, in executeHelper
self.cmd.ActiveConnection=self.conn.adoConn
File "D:\Python23\Lib\site-packages\win32com\client\dynamic.py", line 527, in __setattr__
self._oleobj_.Invoke(entry.dispid, 0, invoke_type, 0, value)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '\xd4\xda\xca\xc2\xce\xf1\xd6\xd0\xa3\xac\xb2\xbb\xc4\xdc\xb4\xe6\xd4\xda\xb6\xe0\xb8\xf6\xca\xb9\xd3\xc3\xb4\xcb\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xb5\xc4\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3\xc7\xeb\xb8\xfc\xb8\xc4\xd3\xce\xb1\xea\xc0\xe0\xd0\xcd\xa1\xa2\xcc\xe1\xbd\xbb\xca\xc2\xce\xf1\xa3\xac\xbb\xf2\xb9\xd8\xb1\xd5\xc6\xe4\xd6\xd0\xc4\xb3\xb8\xf6\xbc\xc7\xc2\xbc\xbc\xaf\xa1\xa3', None, 0, -2147467259), None)
--- ADODBAPI on command:select * from billmsg; with parameters: None
不知道为什么，查了一些资料，还是不能解决。数据库中存在billmsg表，select * from billmsg也没错啊。
...全文
相关推荐
国央企创新负责人如何构建多维度的科技资源评价与配置体系？.docx
国央企创新负责人如何构建多维度的科技资源评价与配置体系？
《移动通信系统》全套PPT课件2026（西安电子科技大学）
《移动通信系统》全套PPT课件2026（西安电子科技大学）
Python3 json序列化常见报错
json只能序列化字符串、数字、列表、字典、布尔、空值。无法序列化datetime、bytes、自定义类对象，直接dumps会抛出类型错误。解决方案：自定义序列化函数，通过default参数传入，手动转换特殊对象。中文乱码：默认ensure_ascii=True会转义中文，改为False直接输出原生中文。反序列化loads注意：json字符串要求双引号，Python字典单引号字符串无法解析，需要提前替换引号。 lxwuhua.cn mayawalkermx.com mccia.com.cn lzsxgqscgs.com mftug.com
产业园区运营负责人如何精准对接区域技术成果与产业需求？.docx
产业园区运营负责人如何精准对接区域技术成果与产业需求？
科技中介服务机构如何提升科技成果评估服务的专业性与效率？.docx
科技中介服务机构如何提升科技成果评估服务的专业性与效率？
