Page 1 of 1
CreateAndFillParamAccs already called (D:\Projects\Delphi\Sdac\Source\OLEDBAccess.pas, line 3411)
Posted: Tue 07 Nov 2006 09:32
by oodesigns
Hi
I am caching the stored procedures params by keeping a tmsstoreproc for each stored proc called.
I this case the proc component would of been called mutliple times. This is working 99% of the time.
Any way to make sure this is not raised.
Mike
Posted: Wed 08 Nov 2006 08:35
by Jackson
We couldn't reproduce the problem.
Please send us (sdac*crlab*com) a complete small test project to reproduce the problem; it is desirable to use Northwind or Master schema objects, otherwise include definition of your own database objects; don't use third party components.
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor
Posted: Wed 08 Nov 2006 09:28
by oodesigns
Hi
Can you pleeease tell me when this would be raised. As I cannot send you anything as it is incorporated into the server.
Mike
Posted: Thu 09 Nov 2006 10:38
by Jackson
Most possible reason of such behaviour is that one instance of TMSStoredProc component is used simultaneously in different threads.
Unfortunately we will not be able to help you if we do not have an example that demonstrates the problem.
Other users have never informed us about similar problems.