| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO recordset problem with stored procedure
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ADO recordset problem with stored procedure
Thank you for this tip. I'm sure I will end up using this information, probably sooner rather than later.
Sincerely, -- RMC,CPA wrote in message ups.com... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing an array or recordset to a stored procedure | Excel Programming | |||
| Passing an array or recordset to a stored procedure | Excel Programming | |||
| Passing an array or recordset to a stored procedure | Excel Programming | |||
| execute stored procedure | Excel Programming | |||
| Run a stored procedure in Excel 2K | Excel Programming | |||
Linear Mode
