Core40.dll exception with Threaded Application

[Nick M]

I'm currently running a multi-threaded application and am occasionally getting the following error when trying to connect:

Access violation at address 017BF8cc in module 'CORE40.dll'. Read of address 221DCCAC.

Each thread has its own session object with the ThreadSafe property set to True.

The server is running the Oracle 9 client software, but has recently been upgraded from 8.

The software is scheduled as a batch job, and sometimes is OK, and sometimes errors. The problem being that when it errors it freezes the thread preventing the application from terminating.

Any ideas would be appreciated.

Thanks in advance.
Nick

 

[Marco Kalter]

If each thread has its own session, then you can set ThreadSafe to False, since all threads will use their own database access object instances. I'm not sure if this will affect the core40.dll error though, which is an internal Oracle Client DLL. If possible, try to change the Oracle Client version to see if this affects the problem.

 

[Nick M]

I originaly tried setting the ThreadSafe to false, but this persisted in raising errors when connection to the database. The only way I could get the system to work was to set ThreadSafe to true.
The error I was getting was:
Access violation at address 614C297F in module 'oran9.dll'. Read of address 00000044