"Current provider does not support returning multi

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

"Current provider does not support returning multi

Author

Topic

kingkong
Starting Member

16 Posts

Posted - 2004-09-09 : 12:37:21

NextRecordset Method

When i use NextRecordset Method of Recordset class it throws me an error

"Current provider does not support returning multiple recordsets from a single execution"

The query is returning three recordsets from Stored Procedure.
It works fine till two recordsets......but whenever i call this method for third one....it throws me this error

do u have any idea??

n/a
deleted

35 Posts

Posted - 2004-09-09 : 12:43:29

what is your provider (and what version number)?
Not all providers will support multiple recordsets, but some will still work as long as you do not try to jump to the second one.

Paul

kingkong
Starting Member

16 Posts

Posted - 2004-09-09 : 13:49:39

I am trying the following provider, but none of them are working for me ..... ?

[OLE DB Provider for ODBC Databases]
oConn.Open "Provider=MSDASQL;" & _
"Driver={SQL Server};" & _
"Server=myServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

[OLE DB Provider for SQL Server]
oConn.Open "Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"

[ODBC Driver for SQL Server]
oConn.Open "Driver={SQL Server};" & _
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-09 : 22:39:05

what language and data object are you using?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources