Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Desperatly connecting to Oracle 7.2

Re: Desperatly connecting to Oracle 7.2

From: Alen Selimbegovic <jkemfelj_at_public.srce.hr>
Date: 1997/07/24
Message-ID: <01bc97ff$81b7eae0$691449ad@pcaselim.amex>#1/1

Oracle (Sql plus, Designer, etc.) tools are working, and I'm using those native driver (SQL Links)
which is included in Delphi C/S version (drivers for Oracle, Sybase, SQL server, Informix...).
Here are all driver parameters:
VERSION:3.0
TYPE:SERVER
DLL:SQLD_ORA.DLL
DLL32:SQLORA32.DLL
VENDOR INIT:ORA72.DLL
DRIVER FLAGS:
TRACE MODE:0
SERVER NAME:pom
USER NAME:SYSTEM
NET PROTOCOL:TCP/IP
OPEN MODE:READ/WRITE
SCHEMA CACHE SIZE:8
LANGDRIVER:
SQLQRYMODE:
SQLPASSTHRU MODE:SHARED AUTOCOMMIT
SCHEMA CACHE TIME:-1
MAX ROWS:-1
BATCH COUNT:200
ENABLE SCHEMA CACHE:FALSE
SCHEMA CACHE DIR: and alias parameters:
TYPE:ORACLE
PATH:
other parameters are same as above.

-- 
Alen Selimbegovic AMEX Zagreb

Alex Shmelev <alexs_at_gte.net> wrote in article
<5r5g98$d0s$1_at_gte1.gte.net>...

> 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 Thu Jul 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US