[solved] Zeos 7.0.0-dev cannot connect to Oracle 8i

[TomiB]

Hello everybody,

this is my first post so sorry for mistakes in advance. I need your help regarding connection to oracle 8i using zeos 7.0.0. I try to connect in design time, but still occur error : ORA-12154. PC client is Win XP Pro SP3 with unzipped instantclient 10.2. I tried to connect via following TNSNAMES.ORA:

Code: Select all

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

I have set TNS_ADMIN to instantclient files (include tnsnames.ora).
TZConnection properties are following:

Database : ORCL
HostName:
Password : 123456
UserName : XXX
Port : 0
Protocol : Oracle

Others are set to default.
Using the TOAD connection have no problem.
Thanks much for any idea.

[EgonHugeist]

TomiB,

AFAIK does our plain implementation work for Oracle9+. But i know about users which had success with Oracle8 too.

I personally use Oracle11 for the development. My first advice would be: Please use our SVN or download Zeos7.0.1-Beta to be on the same bandwidth.

Question: which connection library is used for Oracle8? OCI.dll? On the other hand download the Beta and use TZConnection.LibraryLocation := 'your.dll instead. That forced Zeos to load another library.

Your connection parameters looking ok for me. Did you try to set the port and ip too?

[TomiB]

Thanks EgonHugeist for advice. Change of program versions to Zeos7.0.1-Beta has solved my problem. After setting LibraryLocation property, connection with ORACLE 8i working well.