SQLOLEDB table variable stored procedure

Last Post 08 Nov 2007 09:53 AM by sradoff. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sradoff
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.

Steve
You are not authorized to post a reply.

Acceptable Use Policy