Thanks for this issue, but it's not work. Before to view my error log :
######### 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 ########## I have a message box with this message : Perl.exe - extension point not found The extension point of Perl_Glockhoock_ptr process is not found in the perl58.dll dynamic link library. Thanks for you help. -----Message d'origine----- De : John Scoles [mailto:[EMAIL PROTECTED] Envoyé : vendredi 22 septembre 2006 18:03 À : Christophe ANTOINE Objet : Re: DBI->connect Oracle on Windows, doesn't Work Most likey cause is the version of Activesource DBD::Oracle is not compatiable with the version of the Oracle client you are trying to use. This is more Oracle's fault than Activesource or DBD::Oracle. They changes the clients all around so now you have to compile for each client. Not sure what the Activesource client is compiled against. You could try and set ORACLE_HOME='C:\instantclient_10_2' and LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib to your enviornment variables cheers John Scoles ----- Original Message ----- From: "Christophe ANTOINE" <[EMAIL PROTECTED]> To: "John Scoles" <[EMAIL PROTECTED]> Sent: Friday, September 22, 2006 11:44 AM Subject: RE: DBI->connect Oracle on Windows, doesn't Work My DBD::Oracle is : DBI->connect( 'DBI:Oracle:host=foo;sid=bar' , 'foo', 'bar') Yes it get from Activesource. -----Message d'origine----- De : John Scoles [mailto:[EMAIL PROTECTED] Envoyé : vendredi 22 septembre 2006 17:28 À : Christophe ANTOINE Objet : Re: DBI->connect Oracle on Windows, doesn't Work How did you build you DBD::Oracle? Did you get it from Activesource? ----- 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.