Connect to the same session from two process

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Tony49
Posts: 21
Joined: Mon 26 Jan 2009 17:10

Connect to the same session from two process

Post by Tony49 » Wed 21 Jul 2010 13:46

Hi,

Is it possible to work with the same session form two différente application.

My first application open a session with userName=USER1 password=PASS1 and servername=DATABASE1

My second application must connect to the database with the same connectstring as the first application but i don't want to creation a new session. So, is it possible to link the session of the second application to the first application?

Thank for your help.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Fri 23 Jul 2010 11:14

Hello

Yes, you can use the same connection for several applications. You can make DLL that will contain general TOraSession. And each your application will load this DLL and assign this connection:

Code: Select all

  OraSession.AssignConnect(ExternalSession);

Post Reply