Oracle connection issue / question
Posted: 04.02.2021, 14:51
Hi,
I wanted to test the Zeos Component with Lazarus as well as with Delphi on our Oracle Database, but not sure how this is supposed to work, I get an error
Compiled and installed the components, no error.
I dropped a ZConnection on the form and entered these properties:
Database : prod1
HostName : db.orsrv.intra (also tried with IP address)
Port : 1521
Password : xxx
User : xxx
Protocol : oracle
When I click to enable 'Connected' it takes about 15 seconds wait and it says : SQL Error : OCI_ERROR: ORA-12154: TNS ^:could not resolve the connect identifier specified
The TNS string I use in the ODBC config, and that works fine from other programs is : db.orsrv.intra:1521/prod1
is it the wrong way to do or did I forget something ? Is Zeos accessing Oracle natively or through a library / dll ?
Thanks in advance for any good hint :-)
I wanted to test the Zeos Component with Lazarus as well as with Delphi on our Oracle Database, but not sure how this is supposed to work, I get an error
Compiled and installed the components, no error.
I dropped a ZConnection on the form and entered these properties:
Database : prod1
HostName : db.orsrv.intra (also tried with IP address)
Port : 1521
Password : xxx
User : xxx
Protocol : oracle
When I click to enable 'Connected' it takes about 15 seconds wait and it says : SQL Error : OCI_ERROR: ORA-12154: TNS ^:could not resolve the connect identifier specified
The TNS string I use in the ODBC config, and that works fine from other programs is : db.orsrv.intra:1521/prod1
is it the wrong way to do or did I forget something ? Is Zeos accessing Oracle natively or through a library / dll ?
Thanks in advance for any good hint :-)