Re: Net8 Connect Strings

Many times a connect string will look like username/password_at_databasealias.domain where the database alias and domain are what you used in your tnsnames.ora file. kevin/kevinpassword_at_kevindb.world

Van

<rock_cogar_at_my-deja.com> wrote in message news:8lmsra$kf4$1_at_nnrp1.deja.com...
> Kevin,
>
> The fact that you can connect using ODBC suggests that ODBC is setup to
> correctly use the Oracle native drivers to talk to the database.
>
> You did not mention exactly what Oracle client tools (version, has
> SQLPLUS,...) you installed on your desktop and what OS you are running
> on. Do you have the system password for the database ?
>
> Tell us more and we can help you out.
> Rock.
>
> In article <397EDE4C.1A4EC256_at_certifyonline.com>,
> Kevin MacLeod <kmacleod_at_certifyonline.com> wrote:
> > Hi,
> >
> > I recently tried to define an Oracle 8 database for Cognos Impromptu.
 If
> > you use native Oracle drivers, Impromptu requires the connect string.
 I
> > am definitely a novice when it comes to Oracle, but I took an entry
 out
> > of the tnsnames.ora file and tried to enter it into the text box
> > supplied for the connect string. It didn't work...I got it working
 using
> > ODBC, but I'd like to know if tnsnames.ora was the right place to look
> > for this information. How would I construct a connect string for an
> > Oracle database? What are the various pieces of information needed to
> > construct one? Is there any sort of saving using native drivers over
> > ODBC?
> >
> > Thanks in advance!
> > --
> > Kevin MacLeod
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 27 2000 - 00:00:00 CDT