Page 1 of 1

Exception on Close of Stored Procedure

Posted: Wed 02 Oct 2013 13:21
by GNiessen
I have three stored procedures that are called, one after the other. For each I set the parameters and the call ExecProc, read fields returned, then close. The first two work fine. But on the third I get:
Close Failed: Access violation at address 0059D853 in module 'SvcClient.exe'. Read of address 00000142

I get the records I was expecting, but I am not seeing why the exception is occurring.

Re: Exception on Close of Stored Procedure

Posted: Thu 03 Oct 2013 10:51
by AndreyZ
There is not enough information about the problem. Please specify the following:
- the script to create your stored procedures;
- the exact version of SDAC. You can learn it from the About sheet of TMSConnection Editor;
- the exact version of your IDE;
- the exact version of SQL Server server and client. You can learn it from the Info sheet of TMSConnection Editor.