RE: DBI->connect Oracle on Windows, doesn't Work
- From: cantoine@xxxxxxxxxx (Christophe ANTOINE)
- Date: Mon, 25 Sep 2006 10:02:44 +0200
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:scoles@xxxxxxxxxxx]
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" <cantoine@xxxxxxxxxx>
To: "John Scoles" <scoles@xxxxxxxxxxx>
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:scoles@xxxxxxxxxxx]
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" <cantoine@xxxxxxxxxx>
To: <dbi-users@xxxxxxxx>
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.
.
- Follow-Ups:
- RE: DBI->connect Oracle on Windows, doesn't Work
- From: Ron Savage
- RE: DBI->connect Oracle on Windows, doesn't Work
- Prev by Date: Re: mysql_connect_timeout problem when using times less than 1 sec
- Next by Date: RE: DBI->connect Oracle on Windows, doesn't Work
- Previous by thread: RE: DBI->connect Oracle on Windows, doesn't Work
- Next by thread: RE: DBI->connect Oracle on Windows, doesn't Work
- Index(es):
Relevant Pages
|
|
