Multiple Thread and Delay in Connection

Arjan

Member²
Our application (a service) uses a thread with a TOracleSession to connect to a database. We are using an other thread to create a new connection.
A dataModule is created in the create of this new thread, after the create we connect to the database

In the execute of the thread we try to make a new (third) connection using a NEW TOracleSession. To connect to the database takes about 30 seconds. The second time we try to do this it takes 1 minute, the next takes 1:30 and so on.

We have traced the problem in to the attach of the server (oracle.pas). The time increases every time we try to connect.

We are using DOA (4.0.7.1) with Delphi 2005.

We are using default settings of the TOracleSession.

This problem only occurs when we make a connection in the execute of a thread.

If someone has any ideas, share them please, we are running out
 
Never mind, we have found our problem

On another PC with a different Oracle Client installation is is working just fine.

It looks like it is a combination of Win2000 and an oracle version for WinXp (or something).
 
Back
Top