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
Multiple oracle clients
-
- Devart Team
- Posts: 925
- Joined: Thu 17 Nov 2005 10:53
Multiple Oracle Clients
That was said back in 2007. Has this changed since then or does dbExpress still not support Multiple Oracle Clients.Challenger wrote:dbExpress doesn't allow passing parameters to the driver before connect. So there is no way to change home name.
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.
-
- Posts: 56
- Joined: Fri 02 Aug 2013 07:51
Re: Multiple oracle clients
I'm also interested.
How can I specify witch oracle home to use?
Thanks.
Daniele
How can I specify witch oracle home to use?
Thanks.
Daniele
Re: Multiple oracle clients
To specify the used Oracle Client, you can use the "HomeName" property :
Code: Select all
SQLConnection.Params.Values['HomeName'] := 'your Oracle HomeName';