Client crashes after connection-loos

[Andi]

Hi,

my application crashes after the connection to the oracle-server was lost. It can also reproduced by renaming the tnsnames.ora during load. The application tries to reconnect the session. After some time the application crashes. An Accessviolation (on address 00000) is handled in SysUtils.ExceptHandler. Maybe a bug in oci.dll??

Application:
- MultiThreaded
- Each Thread has a own TOracleSession
- TOracleSession.ThreadSafe=True
- has a TServerSocket with connected Clients that requests data from the database.

Enviroment:
- Delphi 5
- Windows XP SP2
- DOA 4.0.7.1
- Oracle 9i Server
- Oracle 10.1.0.5 Instant Client

Thanks!

Andi

 

[Marco Kalter]

What is the exact Oracle Server version?

 

[Daniel Stoch]

Try to use Oracle 10.2.0.1.0 Instant Client. We had a similar problem (Access violation at address 00000000. Read of address 00000000) and a new version of instant client solves it.

--
Best regards,
Daniel

 

[Andi]

Hi,

thanks for you replies. I've found the reason - no DOA problem. I had some problems with my WindowsSockets.

Thanks!

Andi