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)
 Dynamix SQL does not get returned to VB COM as dictionary

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-13 : 09:26:54
Bhushan writes "I have a dynamic SQL SP which when run through the query analizer returns a "good" recordset. but when I call the same SP from a VB COM and try to get it into a Disconnected Recordset...DOES NOT WORK ...gives me the generic VB error
Object variable or With block variable not set"

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-13 : 09:28:39
Can u post the SP Code here ?

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-07-13 : 10:44:03
Then the problem is within your VB code, not SQL Server.

Help us help YOU!
Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

*need more coffee*
SELECT * FROM Users WHERE CLUE > 0
(0 row(s) affected)
Go to Top of Page
   

- Advertisement -