Page 1 of 1

can't initialize OCI

Posted: Thu 04 Nov 2010 12:06
by bds2006
Hi,
I work on Borland Developer Studio 2006 with ODAC 5.80.0.35
I have client oracle : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
I can launch my application with login/pwd oracle and it's work fine.

When i go in the code to the Session Editor the connection is ok and I see the oci.dll
OCI: Version 10.2.0.1.0
DLL: D:\oracle\product\10.2.0\client_1\BIN\oci.dll

But when i want to debug in my ide bds2006 there's an exception on the TOrassession with the message "can't initialize OCI. Error -1"

Can everyone help me?
thanks

Posted: Thu 04 Nov 2010 14:32
by AlexP
Hello,

As I can see you have two different oracle clients - 10.2.0.4.0 and 10.2.0.1.0, and one of them is x32, and ODAC can work with it. ODAC is an x32 application and can't work with x64 dll in any modes (run-time, design-time). Check that you have chosen the correct home property in the TOraSession window - it should be the x32 client.

Posted: Thu 04 Nov 2010 14:55
by bds2006
OK.
But I don't understand why my application is runing when I launch it without debugging.
Have you an idea?

Posted: Mon 15 Nov 2010 10:14
by AlexP
Hello,

Please set/create the TNS_ADMIN enviroment variable to the path to your tnsnames.ora file and try again