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.

Relevant Pages

  • Re: Static Content Management -- Baking Pages rather than Frying them
    ... >+ supply a 'template' HTML file ... >+ a file to pad out the template ... >tools on a Windows platform. ... I've tested the script on Windows, ...
    (comp.lang.perl.misc)
  • Re: SimpleXMLRPCServer performance issue in MSWin
    ... The ServerTest.py is the server ... The ClientTest.py is the client script that can access ... server script run slower in Windows platform. ... SimpleXMLRPCServer): ...
    (comp.lang.python)
  • append newline to files with incomplete last line
    ... I need to write a script to process files FTPed over from various ... My problem now is that files created on the Windows platform always ... have this "Incomplete last line" error when opened with vi after doing ... it also appends a new line to the UNIX-created ...
    (comp.unix.shell)
  • Re: browser output
    ... daniel kaplan wrote: ... > longer get output to my browser (windows platform) after ... One workround I've sometimes found effective is not to call the script ...
    (comp.lang.perl.misc)