Why can't use cursor.nextset() in adodbapi package?

nightmarch nightmarch at gmail.com
Mon Jan 24 04:18:05 EST 2005


I want use crsr.nextset() , But I got errors like following:


>>> connStr = "Provider=MSDAORA.1;Password=jmpower;User
ID=jmpower;Data Source=jmgis_agps3;Persist Security Info=True"
>>> import adodbapi
>>> conn= adodbapi.connect( connStr )
>>> crsr = conn.cursor()
>>> sql = "select * from wjtmp"
>>> crsr.execute(sql)
>>> rec = crsr.fetchone()
>>> crsr.nextset()
Traceback (most recent call last):
  File "<interactive input>", line 1, in ?
  File "C:\Python24\Lib\site-packages\adodbapi\adodbapi.py", line 711,
in nextset
    rsTuple=self.rs.NextRecordset()
  File "<COMObject Execute>", line 2, in NextRecordset
  File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py",
line 251, in _ApplyTypes_
    result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags,
retType, argTypes) + args)
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3',
(0, 'ADODB.Recordset', 'Current provider does not support returning
multiple recordsets from a single execution.',
'C:\\WINNT\\HELP\\ADO210.CHM', 0, -2146825037), None)




Why? 

thanks



More information about the Python-list mailing list