ORA-12514 on PB 12.5.2 Build 5006

[mvdk27]

Hello,
I'm working on Windows7, 64bit with PB 12.5.2 build 5006 and Oracle 11.2.0
I can connect to the database with SQLPLUS but not with PowerBuilder?
I always get the following error message: ORA-12514: TNS: listener does not currently know of service requested in connect descriptor
My service name is called ORNFDEV. When I execute lsnrctl services ORNFDEV in DOS command I get the info of my "tnsname.ora" file and a sentence stating that the command worked.
It doesn't seem an Oracle problem but a PowerBuildwer one.
Does anyone can help me?

Please see below, the content of my tnsnames.ora file
# tnsnames.ora Network Configuration File: c:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORNFDEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ornf)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

 

[mbalent]

Which driver are you using?

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[mvdk27]

Where, How do I see it?
Thanks for your interest

Marc

 

[AshishGhildiyal]

I believe Matt means driver in Database Profiles Dialog Box
Navigate to Tools -> Database Profiles

Correct me if I am wrong..

Ashish

http://powerbuildernotes.blogspot.in/

 

[mvdk27]

Ok thanks for your interventions. I've solved the problem. It was a question of service name which was different in the tnsname.ora and the *.ini file used by powerbuilder. Howerver even after uniformising the names, the connections didn't work. I dropped and recreate the Database profile in PowerBuilder and it worked!
Thanks
Marc