1

Topic: OLEDB does not return result at command batch performance.

All kind time of days! I use a SQL server 2008. I fulfill a command batch. - START DECLARE @VAR1...;... DECLARE @VARN...; I fulfill necessary actions;... I Deduce result. SELECT @VAR1 as VAR1..., @VARN as VARN - STOP and so: executing a command in "Microsoft SQL Server Management Studio" I receive result in the form of the table. (Well) At performance of a command batch by means of COM interfaces from under a C ++ as a result I receive an empty data set. m_CommandText. Execute (NULL, IID_IRowset, NULL, NULL, (IUnknown **) &m_IRowset); m_IRowset it is equal NULL. How to receive result from under a C ++? Thanks.

2

Re: OLEDB does not return result at command batch performance.

Hello, blonduser, you wrote: B> I Fulfil a command batch. B> at performance of a command batch by means of COM interfaces from under a C ++ as a result I receive an empty data set. B> m_CommandText. Execute (NULL, IID_IRowset, NULL, NULL, (IUnknown **) &m_IRowset); B> m_IRowset it is equal NULL. Try to request IID_IMultipleResults. Also look at the description of property DBPROP_SKIPROWCOUNTRESULTS.

3

Re: OLEDB does not return result at command batch performance.

Hello, Kovalenko Dmitry, you wrote: > Hello, blonduser, you wrote: B>> I Fulfil a command batch. B>> at performance of a command batch by means of COM interfaces from under a C ++ as a result I receive an empty data set. B>> m_CommandText. Execute (NULL, IID_IRowset, NULL, NULL, (IUnknown **) &m_IRowset); B>> m_IRowset it is equal NULL. > Try to request IID_IMultipleResults. > Also look at the description of property DBPROP_SKIPROWCOUNTRESULTS. In used stored procedure the fifth parameter was found out. Now all !