Multiple oracle clients

Multiple oracle clients

Postby 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
EdwinB
 
Posts: 2
Joined: Thu 25 Jan 2007 20:58

Postby 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.
Challenger
Devart Team
 
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Postby EdwinB » Fri 26 Jan 2007 18:53

Thanks for answering, I'll will try something else.
EdwinB
 
Posts: 2
Joined: Thu 25 Jan 2007 20:58

Multiple Oracle Clients

Postby 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.
BenW
 
Posts: 9
Joined: Thu 14 May 2009 04:35

Re: Multiple oracle clients

Postby Daniele Buttarelli » Fri 16 Feb 2018 16:01

I'm also interested.
How can I specify witch oracle home to use?
Thanks.
Daniele
Daniele Buttarelli
 
Posts: 54
Joined: Fri 02 Aug 2013 07:51

Re: Multiple oracle clients

Postby 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';
MaximG
Devart Team
 
Posts: 848
Joined: Mon 06 Jul 2015 11:34


Return to dbExpress driver for Oracle