Problem Version 6: ORA-12154: TNS:could not resolve service name

bij · Post by **bij** » Thu 29 Mar 2007 09:17

Hello,

I just installed ODAC 6 on my computer and ran into the following problem: Whenever the OraSession object tries to connect to the database the error "ORA-12154: TNS:could not resolve service name" occurs. The error occurs both inside the IDE and after compiling and starting the program (Compilations with ODAC 5 work fine). Connecting to a DB locally is working.

ODAC Version: 6.00.0.4 for Delphi 2006
OCI: Version 8.1.7.0.0 (not loaded)
DLL: D:\oracle\ora81\BIN\oci.dll
Home [OraHome81]: D:\oracle\ora81
Default Home [OraHome81]: D:\oracle\ora81
Current Home: D:\oracle\ora81

Please help!

bij

bij · Post by **bij** » Fri 30 Mar 2007 08:00

Hi,

I found something. In our TNS configuration (tnsnames.ora) we use for example:

Code: Select all

elliot.bi =
  (DESCRIPTION =
    (ADDRESS_LIST =
...

With ODAC 5 I can use elliot as my OraSession's Server property, since my default domain is bi
see sqlnet.ora:

Code: Select all

NAMES.DEFAULT_DOMAIN = bi

If I use the complete alias elliot.bi as Server property the connection works also with ODAC 6.

Still, please commend on this issue! Thanx!

bij

Plash · Post by **Plash** » Fri 30 Mar 2007 08:37

We have fixed this problem. The fix will be included in the next build of ODAC.

bij · Post by **bij** » Fri 30 Mar 2007 09:08

bij · Post by **bij** » Thu 19 Apr 2007 09:14

still not working in version 6.00.0.5

bij

Plash · Post by **Plash** » Thu 19 Apr 2007 11:11

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem.

bij · Post by **bij** » Thu 19 Apr 2007 11:14

were you able to reproduce it in version 6.00.0.4?

bij

Plash · Post by **Plash** » Fri 20 Apr 2007 07:43

We can reproduce the problem with ODAC 6.00.0.4 but not with ODAC 6.00.0.5.