Re: PO7 Connect String

The normal way you usually make a connection with Oracle is

Protocol:host:OracleSID
so T:127.0.0.1:ORCL

The T is for TCP/IP.

I'm not sure this will work on the one you are trying but it is worth trying.

Have fun
Jacco

In article <43tdid$1ig_001_at_host.daytonoh>, cyberman_at_erinet.com (Cy Berman) wrote:

> I'm tring to create an ODBC data source for a PO7 db in win95.
> I've installed the PO7 Beta and Oracle 7 ODBC driver.
> What do I put in the edit box labeled SQL Net Connect string?
>
> Also, when I run SQL Plus, I just enter scott/tiger WITHOUT a
> host string. Is there a default one?
>
> I also have a tool called Sql Studio. It has an edit box
> labeled Host. I have the same problem that I don't know
> what to enter. When connecting to a remote db, I use an
> entry that's in the tnsnames.ora file. Here's what my
> default tnsnames file looks like after installing PO7 Beta.
>
>
> oracle.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = NTCommun.world)
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>
>
> I'll have the same problem when I try to connect to the db via Visual Basic.
> What is the database name?
>
>
> Thanks,
>
>
> Cy
  Received on Fri Sep 29 1995 - 00:00:00 CET