NT ORACLE PERL DBD DBI->connect format 
Author Message
 NT ORACLE PERL DBD DBI->connect format

Hi,

I installed Perl 5.6.0 and DBI on my NT 4.0 Sevice pack 5
With DBD::ODBC it works fine with ORACLE 8i 8.1.5 databse
Then I installed DBD::Oracle and I have problem trying to connect
database

I tried two formats:

my $dbh = DBI->connect('DBI:Oracle:host=$dbserver ,sid=$dbname', $user,
$pass, 'Oracle');
and
$dbh = DBI->connect
('dbi:Oracle:G21DEV', 'USERNAME', 'PASSWORD', 'Oracle')

I have error message:
Database connection not made: ORA-00000: normal, successful completion
(DBD: log
in failed, check ORACLE_HOME/bin is on your PATH) at test5.pl line 36.

On my NT ORACLE_HOME\bin is on PATH

For my $dbh = DBI->connect('DBI:Oracle:host=$dbserver ,sid=$dbname',
$user, $pass, 'Oracle');
I am not sure what means  $dbname in for 8.1.5.
Is it connect string ? Or SERVICE_NAME ? Or database name ?
In $dbserver I used the name of my computer in LAN

For $dbh = DBI->connect
('dbi:Oracle:G21DEV', 'USERNAME', 'PASSWORD', 'Oracle')
I am not sure what is G21DEV for 8.1.5.
Is it connect string ? Or SERVICE_NAME ? Or database name ?

Id appreciate any help

Yakov

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 NT ORACLE PERL DBD DBI->connect format

Quote:
> Hi,

> I installed Perl 5.6.0 and DBI on my NT 4.0 Sevice pack 5
> With DBD::ODBC it works fine with ORACLE 8i 8.1.5 databse
> Then I installed DBD::Oracle and I have problem trying to connect
> database

> I tried two formats:

> my $dbh = DBI->connect('DBI:Oracle:host=$dbserver ,sid=$dbname', $user,
> $pass, 'Oracle');
> and
> $dbh = DBI->connect
> ('dbi:Oracle:G21DEV', 'USERNAME', 'PASSWORD', 'Oracle')

> I have error message:
> Database connection not made: ORA-00000: normal, successful completion
> (DBD: log
> in failed, check ORACLE_HOME/bin is on your PATH) at test5.pl line 36.

> On my NT ORACLE_HOME\bin is on PATH

I have a feeling that Oracle 8i is not the same as the mainstream Oracle
database in some respects - you will almost certainly want to ask in
comp.databases.oracle to find out more.

/J\
--
Lisa, stop that racket! I'm trying to fix your mother's camera. Easy,
easy....I think I'll need a bigger drill.
--
fortune oscar homer



Wed, 18 Jun 1902 08:00:00 GMT  
 NT ORACLE PERL DBD DBI->connect format

Quote:


> > Hi,

> > I installed Perl 5.6.0 and DBI on my NT 4.0 Sevice pack 5
> > With DBD::ODBC it works fine with ORACLE 8i 8.1.5 databse
> > Then I installed DBD::Oracle and I have problem trying to connect
> > database

> > I tried two formats:

> > my $dbh = DBI->connect('DBI:Oracle:host=$dbserver ,sid=$dbname', $user,
> > $pass, 'Oracle');
> > and
> > $dbh = DBI->connect
> > ('dbi:Oracle:G21DEV', 'USERNAME', 'PASSWORD', 'Oracle')

> > I have error message:
> > Database connection not made: ORA-00000: normal, successful completion
> > (DBD: log
> > in failed, check ORACLE_HOME/bin is on your PATH) at test5.pl line 36.

> > On my NT ORACLE_HOME\bin is on PATH

> I have a feeling that Oracle 8i is not the same as the mainstream Oracle
> database in some respects - you will almost certainly want to ask in
> comp.databases.oracle to find out more.

> /J\
> --
> Lisa, stop that racket! I'm trying to fix your mother's camera. Easy,
> easy....I think I'll need a bigger drill.
> --
> fortune oscar homer

According to perldoc DBI, both your ways are incorrect.  The 3rd
argument (optional) should be a hash ref:

  $dbh = DBI->connect("dbi:Oracle:SID", $uid, $pass, {RasieError => 1,
PrintError => 0, AuotCommit => 0}) || die $DBI::errstr;
--

Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. NT ORACLE PERL DBD DBI->connect format

2. DBI / DBD Oracle connect question

3. DBI/DBD/Oracle connect won't work (ORA-12154)

4. DBI->connect Oracle - ODBC - TNS Service Name

5. DBD-Oracle Connect (NT)

6. Perl needtobie wants info on DBI DBD Oracle Netscape Enterprise NT

7. DBD-Oracle: Problems connecting to Oracle

8. WinNT->DBI->DBD::ODBC->Jet->INSERT == SQL-S1000

9. DBI/DBD::Oracle and NT

10. Binaries for DBI & DBD::Oracle or NT

11. Oracle on NT <-> DBI on Linux

12. Oracle DBD/DBI on HP-UX: can't load Oracle.sl

 

 
Powered by phpBB® Forum Software