Re: Can't Connect to Oracle with SQL*Net V1

From: Michael P. Vergara <vergara_at_nosc.mil>
Date: Wed, 16 Nov 1994 15:33:16 GMT
Message-ID: <1994Nov16.153316.17035_at_nosc.mil>

In article <3aalcq$odu_at_erinews.ericsson.se>, Roger Bjarevall <ebcrbj_at_ebc.ericsson.se> wrote:
>I have another problem!
>
>We have an application that was primarily built for SQL*Net V2
>using OCI.
>Now we want the application to connect to a ORACLE7 database
>that used SQL*Net V1...
>
>Is this possible, if, how shall a proper connect string look like.
>
>(Anyway, does the version of SQL*Net matter on the client side if
> the application is using OCI?)
>
>Using orlon("userid/passoword_at_T:server:sqldba")...
>
>results in "invalid driver designator".
>
>Roger
>Ericsson Business Networks, SWEDEN
>

A 'normal' v1 connect string is userid/password_at_<transport>:<server>:<SID>. For example, I have a database here with the SID of 'NRaD'. To connect to this database with SQL*Net v1 I use :

	sqlplus vergara_at_t:fortune:NRaD
	(and enter my password when promtped).

't' stands for TCP/IP.

'fortune' is the name of the server.
'NRaD' is the SID of the database.

HTH
Mike

--
============================================================================
Mike Vergara           |   Be good...and you will be lonesome
vergara_at_nosc.mil       |                                       Jimmy Buffett
Opinions expressed are not necessarily those of anyone else but me.  So there.

Received on Wed Nov 16 1994 - 16:33:16 CET