RE: DBI->connect Oracle on Windows, doesn't Work
- From: cantoine@xxxxxxxxxx (Christophe ANTOINE)
- Date: Fri, 22 Sep 2006 17:05:43 +0200
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:scoles@xxxxxxxxxxx]
Envoyé : vendredi 22 septembre 2006 17:02
À : Christophe ANTOINE; dbi-users@xxxxxxxx
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" <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.
- Prev by Date: Re: DBI->connect Oracle on Windows, doesn't Work
- 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
|
