Try like this (other hash spec.)
$dbh = DBI->connect( 'dbi:Oracle:'.$sid, $user, $pw,
{ AutoCommit => 1, RaiseError => 0, PrintError => 1 } );
-----------------------------------
Frans Postma, (050-58) 81 852
ATOS Origin, Unix Support
"If at first you don't succeed, skydiving isn't for you"
> -----Oorspronkelijk bericht-----
> Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Verzonden: donderdag 27 februari 2003 14:47
> Aan: [EMAIL PROTECTED]
> Onderwerp: DBD-Oracle issue with AutoCommit
>
>
> Good morning.
>
> I'm having an issue with attempting to specify the AutoCommit
> option on a
> Connect to any Oracle database. Here is an example of my Connect
> statement:
>
> <begin>
> $dbh = DBI->connect('dbi:Oracle:dbName', 'uid', 'pwd',
> (AutoCommit => 0))
> or die "ERROR\nCouldn't connect to ORACLE database: " . DBI->errstr;
> <end>
>
> When I try to run the script, I get the following error:
>
> <begin>
> Connecting to ORACLE...install_driver(AutoCommit) failed:
> Can't locate
> DBD/AutoCommit.pm in @INC (@INC contains: D:/Perl/lib
> D:/Perl/site/lib .)
> at (eval 1) line 3.
> Perhaps the DBD::AutoCommit perl module hasn't been fully
> installed, or
> perhaps the capitalisation of 'AutoCommit' isn't right.
> Available drivers: CSV, DB2, ExampleP, Excel, File, ODBC,
> Oracle, Proxy.
> <end>
>
> I am using ActiveState Perl v5.6.1.
>
> Here is a listing of the DBD modules I have installed, with their
> respective versions:
> <begin>
> DBD-CSV [0.2002] DBI driver for CSV files
> DBD-DB2 [0.75 ] Perl driver for IBM DB2 Universal Database
> DBD-Excel [0.05 ] A class for DBI drivers that act on Excel File.
> DBD-ODBC [0.28 ] ODBC driver for the DBI module.
> DBD-Oracle [1.12 ] Oracle database driver for the DBI module
> DBD-Oracle8 [1.06 ] Oracle 8 database driver for the DBI module
> DBI [1.32 ] Database independent interface for Perl
> <end>
>
> I never got an error while installing the DBI and DBD
> modules, so I'm at a
> loss as to why the AutoCommit.pm file is missing. Have you
> experienced
> this issue before, and would you know what the solution might
> be? Do I
> need to go to CPAN to get the DBI module, instead of
> installing it using
> the Perl Package Manager provided by ActiveState?
>
> Any help you could provide would be greatly appreciated.
>
> Regards,
> Jim
> Email: [EMAIL PROTECTED]
>
