Devart Forums

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

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

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

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.

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

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