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

Home -> Community -> Usenet -> c.d.o.server -> Re: Connect Strings in Oracle 8

Re: Connect Strings in Oracle 8

From: Keith Gilbert <peggyandkeith_at_worldnet.att.net>
Date: 2 Jan 1999 02:39:00 GMT
Message-ID: <76k0s4$qgl@bgtnsc03.worldnet.att.net>


Check the contents of your tnsnames.ora file. It contains the configuration information for all connection strings on your client.

Helsby1 wrote in message <19981230144900.01147.00004279_at_ng-ca1.aol.com>...
>To all concerned,
>
>I am brand spanking new at working with Oracle. Right now I am using,
Oracle
>Migration Assistant for Access to try to import an Access database into
Oracle.
>
>My problem is that at some point I am being asked for a Connect String.
None
>of the documentation that came with my 60 trial version explains the
correct
>Syntax of a Connect String.
>
>I looked at some old documentation for 7.0 and was lead to believe that a
>string should like this: Protocol:Server Name:Instance Name. ie. T:HQ:LOC
>where T is short for TCP/IP. I have tried several variations on this and
have
>had no luck (the Database is local (BEQ) so I have tried B and BEQ and have
had
>no luck. I have been able to successfully test the Service that I am
trying to
>use, so I think the problem is just trying to get the string formatted just
>right.
>
>Can anybody help me?
>
>Steve M. (helsby1_at_aol.com)
Received on Fri Jan 01 1999 - 20:39:00 CST

Original text of this message

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