If you have the Oracle client softwar installed, you should be able to add
an entry to TNSNames.ora using EasyConfig (or some similar name) that is
part of the Oracle folder under your Start Menu. Your local DBA should be
able to give you the necessary details.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "McLennan,Neil [PYR]" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 15:16
Subject: RE: Problem connecting Oracle database
> Check your ensure that MyOraDb exists in your tnsnames.ora file or
> alternatively if using Oracle Names that it is in the Names database.
Then
> check the syntax of the tnsnames.ora to make sure everything is OK and
that
> the host name and port number for this database are correct. The ensure
> that there is a listener running on your database server.
> -----Original Message-----
> From: VIDYASAGAR R NALLU [mailto:[EMAIL PROTECTED]]
> Sent: May 11, 2001 3:16 PM
> To: [EMAIL PROTECTED]
> Subject: Problem connecting Oracle database
>
>
> Hi all,
>
> I wrote a program to connect to Oracle database with the following
> statement:
>
> my $dbh = DBI->connect("DBI:Oracle:MyOraDb","scott","tiger") or die
> "Error: $DBI::errstr";
>
> but i'm ended up with the following error message:
>
> DBI->connect(MyOraDb) failed: ORA-12154: TNS: could not resolve service
> name (DBD: login failed) at dbidemo.pl line 10
> Error: ORA-12154: TNS: could not resolve service name (DBD: login failed)
>
> provided DBI & DBD were installed using ppm tool.
>
> Any help would be appreciated.
>
> Thanks
> Rajasree
>
