Re: Error msg

Roy (Roy@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> I have corrected my stored procedures with what you said. But I still get
> same error. Below is my stored procedure code:

I'm afraid that I'm running out of ideas. Well, one last straw: could
there be triggers on the table producing result sets?

But in my experience, it's always a good idea to get all result sets,
one or another. In the naked OLE DB API, I prefer to use IMulipleResults
and the iterate over IMultipleResults->GetResult until it retuns
DB_S_NORESULT. In an interface like ADO you would iterate over
..NextRecordset or just simply adExecuteNoRecords to discard everything.

Exactly how you do this in the consumer templates, I don't know, but
you might able to make that out.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Help with SQL 2005 and Sourcesafe 6
    ... That doesn't seem to be the case with stored procedures. ... compile that latest version to be table to use it. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: nested stored procedures and returning lots of rows
    ... I initially thought of using nested stored procedures and returning ... proc then the called stored procs can't see it ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Error msg
    ... > The stored procedures looks like this: ... > // update record table here ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Create user.....
    ... But if the applicaiton relies on stored procedures, ... all the user needs is EXEC permission on the procedures. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Select *
    ... work, but yeild incorrect results. ... If you are using stored procedures, you can use sysdepends to track ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)