ADO recordset problem with stored procedure

I

IXLNSQL

Object closed error!

I just figured out (again!) why I get this error while trying open/use
an ADO recordset from a stored procedure (acCmdStoredProc), while using
commandText worked just fine.

"SET NOCOUNT ON"

Apparently the "(xxxx row(s) affected)" msg output by SQL Server jacks
up the recordset object.

adding "SET NOCOUNT ON" at the top of your stored procedure will fix
this issue.
 
R

R. Choate

Thank you for this tip. I'm sure I will end up using this information, probably sooner rather than later.

Sincerely,
--
RMC,CPA


Object closed error!

I just figured out (again!) why I get this error while trying open/use
an ADO recordset from a stored procedure (acCmdStoredProc), while using
commandText worked just fine.

"SET NOCOUNT ON"

Apparently the "(xxxx row(s) affected)" msg output by SQL Server jacks
up the recordset object.

adding "SET NOCOUNT ON" at the top of your stored procedure will fix
this issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Call stored procedure with paremeter output in c# 7
>> ADO Updateable recordset 3
Recordset or Object is closed HELP PLEASE! 10
Stored procedure recordset not opening 9
Passing dates to Sql Server 2005 stored procedure 1
sql stored procedure results in a recordset questions 2
ADO: how to execute SQL Server stored procedure and get return val 1

Top