With dbi:Oracle or DBI:Oracle, it's the same problem. Under Linux, the correct command is : DBI:Oracle.
Regards. -----Message d'origine----- De : John Scoles [mailto:[EMAIL PROTECTED] Envoyé : vendredi 22 septembre 2006 17:02 À : Christophe ANTOINE; dbi-users@perl.org Objet : Re: DBI->connect Oracle on Windows, doesn't Work it is dbi:Oracle: not DBI:Oracle it is case sensitive. cheers John Scoles ----- Original Message ----- From: "Christophe ANTOINE" <[EMAIL PROTECTED]> To: <dbi-users@perl.org> Sent: Friday, September 22, 2006 10:29 AM Subject: DBI->connect Oracle on Windows, doesn't Work Hello, I have this script under, it doesn't work. I have installed the module DBD-Oracle on my Windows platform, I have a Oracle client who's working in SQLplus mode. Please help me, to configure my platform or my perl module to work with Oracle with a Windows Platform. ######### SCRIPT PERL ######### #!/usr/bin/perl use strict; use warnings; BEGIN { print join("\n", split(';', $ENV{PATH})); $ENV{PATH} = $ENV{PATH}.';C:\instantclient_10_2'; } use DBI; my %opt = ( dbname => 'MyDb', #this is the DatabaseName in my tnsnames.ora, I have tested without tnsnames.ora parameters but with the <host>, <port> ... for the same result. dbuser => 'toto', dbpass => 'toto', ); my $dbh = DBI->connect( 'DBI:Oracle:'.$opt{dbname}, $opt{dbuser}, $opt{dbpass} ) or die 'cannot connect to Oracle'."\n"; ######### ERROR LOG IN MYCONSOLE ######### install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:La procÚdure spÚcifiÚe est introuvable at C:/Perl/lib/DynaLoader.pm line 230. at (eval 4) line 3 Compilation failed in require at (eval 4) line 3. Perhaps a required shared library or dll isn't installed where expected at C:\oracle.pl line 14 ######### Thanks for your Help. This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. Talend shall not therefore be liable for the message if modified.
