I am using ODAC version 9.6.21 on C++Builder 6.0 Professional Edition.
I am getting an error while attempting to connect to Oracle 11g database running on the same machine.
The Connect String is as follow:
I am able to connect to the same database with the same user and password using SQL*PLUS.Data Source=BDJJ;User ID=automa;Password=automa;Use Unicode=True;Login Prompt=False
SQL*Plus: Release 11.2.0.1.0 Production on Sex Jan 15 11:58:07 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Conectado a:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "AUTOMA"
SQL>
I cannot find any application error. The code I am using used to work on the previous ODAC version.C:\Users\jjeffman>tnsping dbjj
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-JAN-2
016 11:52:22
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Arquivos de parÔmetros usados:
c:\app\jjeffman\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Usado o adaptador TNSNAMES para resolver o apelido
Tentativa de contatar (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = LOCALHOST)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DBJJ)))
OK (20 ms)
I have configured the TOraSession at design time using the same connect string and it works fine, not in runtime, though.
Can you please help me?