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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-12 : 22:29:23
|
Paul writes "I have a pretty crazy Stored procedure that First runs an Select into a temp table and then selects records based on a passed in parameter and items from the newly created temp table. It works fine in the query analyzer; however, it bombs when I call it from A VB component through ADO. I know the syntax is correct, I just need to figure out how to get it to return the values via ADO. If I remove the Select into, the query runs fine through ADO - so I know it is the multiple selects that are causing the error.
Here is the EXACT error message:
"ADODB.Recordset error '800a0e7b'
Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source. "
Any Help will be EXCELLENT!
THANKS!
PAUL
P.S. I am using MSSQL2K" |
|
|
|
|
|
Stored Procedures with Multiple Selects and ADO