Multiple oracle clients

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
EdwinB
Posts: 2
Joined: Thu 25 Jan 2007 20:58

Multiple oracle clients

Post by EdwinB » Thu 25 Jan 2007 21:10

Hello,

I want to use dbExpress driver (dbxOda) to connect to Oracle 10g with OCI. On a client I've 2 oracle clients, Oracle 8i and Oracle 10g. When Oracle 10g is the default Home it works fine, but Oracle 8i has to be the default Home for a another (third-party) program. If 8i is the default Home I can not connect and I get a oracle error "TNSNAMES could resolve service name".

Is there a solution?

Kind regards,

Edwin Baas

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 26 Jan 2007 12:50

dbExpress doesn't allow passing parameters to the driver before connect. So there is no way to change home name.

EdwinB
Posts: 2
Joined: Thu 25 Jan 2007 20:58

Post by EdwinB » Fri 26 Jan 2007 18:53

Thanks for answering, I'll will try something else.

BenW
Posts: 9
Joined: Thu 14 May 2009 04:35

Multiple Oracle Clients

Post by BenW » Fri 27 Aug 2010 00:23

Challenger wrote:dbExpress doesn't allow passing parameters to the driver before connect. So there is no way to change home name.
That was said back in 2007. Has this changed since then or does dbExpress still not support Multiple Oracle Clients.

Assuming that we are unable to tell dbexpress which oracle home to use. What solutions are people using to handle mutilple oracle home directories? Especially issues raised by 32bit and 64bit clients.

Daniele Buttarelli
Posts: 54
Joined: Fri 02 Aug 2013 07:51

Re: Multiple oracle clients

Post by Daniele Buttarelli » Fri 16 Feb 2018 16:01

I'm also interested.
How can I specify witch oracle home to use?
Thanks.
Daniele

MaximG
Devart Team
Posts: 1138
Joined: Mon 06 Jul 2015 11:34

Re: Multiple oracle clients

Post by MaximG » Mon 19 Feb 2018 08:44

To specify the used Oracle Client, you can use the "HomeName" property :

Code: Select all

SQLConnection.Params.Values['HomeName'] := 'your Oracle HomeName';

Post Reply