Re: What is Service Name ??

From: Dante <dnotari_at_my-deja.com>
Date: 2000/07/01
Message-ID: <8jlp9o$lbh$1@nnrp1.deja.com>#1/1

Bhargava,
first ... there is nothing like Oracle 8.0i. There is Oracle 8.0.x and Oracle 8.1.x aka Oracle 8i.

Now to your question:
The servicename in ODBC references a databasealias for SQL*Net. In your case, you need to set up on the same machine where ODBC is installed SQL*Net. In this case it means thaty ou have to create an TNSNAMES.ORA entry for your database.

There are some cases where you do not need to configure SQL*Net and take advantage of the SQL*Net mechanism to find the right server:

Your database environment is using a Oracle name server
you installed on the machine an instance with the default SID (ORCL) and the listener is listening on the default port 1521. In this case you only need to specify the machinename.

Regards
Dante

In article <8jmf1r$1p$1_at_news.vsnl.net.in>, "Bhargava" <sbhargavarao_at_yahoo.com> wrote:
> Hi !
>
> I am a NEW user !! I am trying to setup ODBC to Personal Oracle
8.0i .. its
> has one of the parameters as Service Name !!
>
> What is Service Name ? . Where can I find the Service Name for my
> Installation ?
>
> Bhargava
>
> sbhargavarao_at_yahoo.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jul 01 2000 - 00:00:00 CDT