使用adodbapi连接MS SQL SERVER2000数据库出错？

leafsky520 2004-07-15 08:22:45

我下载了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也没错啊。

...全文