CreateAndFillParamAccs already called (D:\Projects\Delphi\Sdac\Source\OLEDBAccess.pas, line 3411)

oodesigns · Post by **oodesigns** » Tue 07 Nov 2006 09:32

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

Jackson · Post by **Jackson** » Wed 08 Nov 2006 08:35

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

oodesigns · Post by **oodesigns** » Wed 08 Nov 2006 09:28

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

Jackson · Post by **Jackson** » Thu 09 Nov 2006 10:38

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.