SQLOLEDB table variable stored procedure

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

08 Nov 2007 09: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.


Acceptable Use Policy