Re: Desperatly connecting to Oracle 7.2

Alen -

You failed to mention whether you are using SQLLinks or ODBC. Can you connect to the database using Oracle-native tools (i.e. SQLPlus)? Have you tried ping-ing the database server? If Oracle tools work then SQLNet is working and problem is with ODBC/BDE.

Perhaps you could send more info?

Alex Shmelev

Alen Selimbegovic wrote:
>
> I'm trying to connect Delphi 2.0 with Oracle 7.2 over native TCP/IP
> (using SQL Net 2.2.2 which is part of Designer 1.3).
> I'm getting ORA-06105 NETTCP: remote host is unknown
> error mesage (in database explorer or desktop).
> What am I doing wrong , and how to fix it?
>
> tnsnames.ora:
>
> pom.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 173.73.20.250)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = 173.73.20.250)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = tst)
> )
> )
>
> BDE configuration:
>
> vendor init: ora72.dll (its directory is in the PATH)
> server name: pom or pom.world or t: 173.73.20.250:tst
> --
> jkemfelj_at_public.srce.hr
> Alen Selimbegovic AMEX Zagreb
  Received on Wed Jul 23 1997 - 00:00:00 CDT