access violation in driver when used in a soap server

[Guest]

Hello,

I develop a soap server (as an Apache module), and I have a problem when I try to use ms-sql.

The SQL statements performed in the fist SOAP call works fine,
but the program crash trying to execute a SQL statement in the
second SOAP call with the same connection.

I receive an access violation inside the dbx driver dll.

Each SQL has been tried separatly and works fine.
The same application running with Oracle works perfect.

Is there a specific problem using ms-sql from an apache module (dll)
(something with the threads, for example ?)

Thanks in advance for a response
Philippe Soupart
Ordiges S.A.

[Ikar]

If you would like to use DbxSda in Windows service, console application or just at separate thread you need to call CoInitialize for each thread. Also remember to call CoUnInitialize on thread termination.