Re: SQL*NET connect string ? what SQL*NET connect string

There are several different connection systems running on your box.

The ODBC is connected to Oracle via SQLNet. Hence the need for a specific driver. The SQLNet connection name is defined in a file call tnsnames.ora. Typically it is in <database home>\network\admin If you are connecting to the database with something like "user1/password_at_somename",
the 'somename' is the tnsname for your database.

Off the top of my head I do not recall the default connection name. But you could
create your own name for a connection. The tool is sqlneteasy (??). It is one of

the tools under the Oracle NT development tools. It defines the relationship between
the database SID, the connection protocols, and other parameters. Generally the database connection string is representative to the machine or task at
hand.

The tnsname is then inserted into the ODBC 32bit adminstration tool. Create a Oracle
database connection. The name of the connection is the tnsname associated with that
database.

Test this with the testODBC program.

Mike Krolewski
Philip Huskisson wrote:

> After the assistance provided me in this news group I have installed SQL*NET
> 2.3 and the latest ODBC drivers for Oracle 7.3.3 ... so far so good NOW I'm
> really out of my depth ...
> Being somewhat experienced in NT and Access DB's I'm at a loss with the rest
> of the installation procedure.
> I can move around Unix quite comfortably.
>
> I am trying to configure SQL*net I am not sure where to find the Database
> Instance ...
> In the ODBC config I need to provide an sql*net connect string ...
> everything else seems straightforward
>
> I figure in ODBC setup
> Data Source Name = arbitrary since I have written the ODBC application
> Description = Again arbitrary
> SQL*NET connect string = some magic words sprayed with chicken blood for all
> I know.
> User ID = the Unix account that Oracle uses or perhaps a Unix account that
> has rights the ORACLE server.
>
> in the oracle SQL*NET quick setup
> Database Alias = Arbitrary
> TCP/IP host = the IP address of the Unix box where oracle is living
> DataBase instance = Got me there again
>
> Again any help much appreciated I'm halfway there now
> I WILL see this damn Oracle server
> --
> [][][][][][][][][][][][][][][][][][][][][][][][][][][]
> [] Warmest Regards Philip Huskisson
> [] mailto:philip.h_at_usa.net
> []
Received on Mon Jun 22 1998 - 00:00:00 CDT