SQLOLEDB table variable stored procedure

Last Post 08 Nov 2007 10:53 AM by sradoff. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sradoff
New Member
New Member

--
08 Nov 2007 10:53 AM
I have VB6 code that calls a sproc using an ADO Command object. The sproc contains a table variable which is selected to return records. The sproc works perfectly from SQL Server 2000 query analyzer. Will not return records when executed with SQLOLEDB. Works perfectly with ODBC. Sproc contains the set nocount on. ADO Command object used to return output values via signature parameters.

Steve


Acceptable Use Policy
---