Oracle connection issue / question

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
Nebulus
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 04.02.2021, 14:03

Oracle connection issue / question

Post by Nebulus »

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 :-)
Post Reply