DBI->connect Oracle on Windows, doesn"t Work

------_=_NextPart_001_01C6DE53.838CF906
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,=20

=20

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.

=20

Please help me, to configure my platform or my perl module to work with =
Oracle with a Windows Platform.

=20

######### SCRIPT PERL #########

=20

#!/usr/bin/perl

=20

use strict;

use warnings;

=20

BEGIN {

print join("\n", split(';', $ENV{PATH}));

$ENV{PATH} =3D $ENV{PATH}.';C:\instantclient_10_2';

}

=20

use DBI;

=20

my %opt =3D (

dbname =3D> 'MyDb', #this is the DatabaseName in my =
tnsnames.ora, I have tested without tnsnames.ora parameters but with the =
, ... for the same result.

dbuser =3D> 'toto',

dbpass =3D> 'toto',

);

=20

my $dbh =3D DBI->connect(

'DBI:Oracle:'.$opt{dbname},

$opt{dbuser},

$opt{dbpass}

)

or die 'cannot connect to Oracle'."\n";

=20

######### ERROR LOG IN MYCONSOLE #########

=20

install_driver(Oracle) failed: Can't load =
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:=20

load_file:La proc=DAdure sp=DAcifi=DAe 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

=20

#########

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.


------_=_NextPart_001_01C6DE53.838CF906--

Re: DBI->connect Oracle on Windows, doesn"t Work

> 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.
>
>
>
I see that you've added the path to your oracle home to your PATH
environment variable, but have you added ORACLE_HOME to your
environment?


--
------------------------------------------------------------ --------------------------------------------------
The darkest places in hell are reserved for those who maintain their
neutrality in times of moral crisis.
Dante Alighieri (1265 - 1321)

They who would give up an essential liberty for temporary security,
deserve neither liberty or security.
Benjamin Franklin

Our lives begin to end the day we become silent about things that matter.
Martin Luther King

The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no warrants shall issue, but upon probable cause,
supported by oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.

Amendment IV to the Constitution of the United States
------------------------------------------------------------ --------------------------------------------------

RE: DBI->connect Oracle on Windows, doesn"t Work

>I see that you've added the path to your oracle home to your PATH
>environment variable, but have you added ORACLE_HOME to your
>environment?

Yes i have added the ORACLE_HOME on my environment where it define the =
directory of my oracle client installation.


-----Message d'origine-----
De=A0: Jeffrey Seger [mailto:jseger@gmail.com]=20
Envoyé : vendredi 22 septembre 2006 16:48
À : Christophe ANTOINE
Cc=A0: dbi-users@perl.org
Objet=A0: Re: DBI->connect Oracle on Windows, doesn't Work

> 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.
>
>
>
I see that you've added the path to your oracle home to your PATH
environment variable, but have you added ORACLE_HOME to your
environment?


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.

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"
To:
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
, ... 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.

RE: DBI->connect Oracle on Windows, doesn"t Work

------_=_NextPart_001_01C6DE58.93E5546A
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

With dbi:Oracle or DBI:Oracle, it's the same problem.
Under Linux, the correct command is : DBI:Oracle.

Regards.

-----Message d'origine-----
De=A0: John Scoles [mailto:scoles@pythian.com]=20
Envoyé : vendredi 22 septembre 2006 17:02
À : Christophe ANTOINE; dbi-users@perl.org
Objet=A0: 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 -----=20
From: "Christophe ANTOINE"
To:
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=20
Oracle client who's working in SQLplus mode.



Please help me, to configure my platform or my perl module to work with=20
Oracle with a Windows Platform.



######### SCRIPT PERL #########



#!/usr/bin/perl



use strict;

use warnings;



BEGIN {

print join("\n", split(';', $ENV{PATH}));

$ENV{PATH} =3D $ENV{PATH}.';C:\instantclient_10_2';

}



use DBI;



my %opt =3D (

dbname =3D> 'MyDb', #this is the DatabaseName in my=20
tnsnames.ora, I have tested without tnsnames.ora parameters but with the =

, ... for the same result.

dbuser =3D> 'toto',

dbpass =3D> 'toto',

);



my $dbh =3D 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=20
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:

load_file:La proc=DAdure sp=DAcifi=DAe 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=20
addressees and is confidential. If you receive this message in error, =
please=20
delete it and immediately notify the sender. Any use not in accord with =
its=20
purpose, any dissemination or disclosure, either whole or partial, is=20
prohibited except formal approval. The internet can not guarantee the=20
integrity of this message. Talend shall not therefore be liable for the=20
message if modified.



------_=_NextPart_001_01C6DE58.93E5546A--

Re: DBI->connect Oracle on Windows, doesn"t Work

--------------000502030605060003030304
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

See attached Oracle Troubleshooter Howto.

(List readers: Sorry, the list does not seem to accept HTML attachments)

Alexander

On 22.09.2006 16:55, Christophe ANTOINE wrote:
>> I see that you've added the path to your oracle home to your PATH
>> environment variable, but have you added ORACLE_HOME to your
>> environment?
>>
>
> Yes i have added the ORACLE_HOME on my environment where it define the directory of my oracle client installation.
>
>
> -----Message d'origine-----
> De : Jeffrey Seger [mailto:jseger@gmail.com]
> Envoyé : vendredi 22 septembre 2006 16:48
> À : Christophe ANTOINE
> Cc : dbi-users@perl.org
> Objet : Re: DBI->connect Oracle on Windows, doesn't Work
>
>
>> 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.
>>
>>
>>
>>
> I see that you've added the path to your oracle home to your PATH
> environment variable, but have you added ORACLE_HOME to your
> environment?
>
>
> 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.
>
>


--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/


--------------000502030605060003030304--

RE: DBI->connect Oracle on Windows, doesn"t Work

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=DAdure sp=DAcifi=DAe 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 :=20

Perl.exe - extension point not found=20

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=A0: John Scoles [mailto:scoles@pythian.com]=20
Envoyé : vendredi 22 septembre 2006 18:03
À : Christophe ANTOINE
Objet=A0: Re: DBI->connect Oracle on Windows, doesn't Work

Most likey cause is the version of Activesource DBD::Oracle is not=20
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=20
the clients all around so now you have to compile for each client. Not =
sure=20
what the Activesource client is compiled against.

You could try and set
ORACLE_HOME=3D'C:\instantclient_10_2'

and

LD_LIBRARY_PATH=3D$ORACLE_HOME:$ORACLE_HOME/lib

to your enviornment variables

cheers
John Scoles


----- Original Message -----=20
From: "Christophe ANTOINE"
To: "John Scoles"
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=3Dfoo;sid=3Dbar' , 'foo', 'bar')

Yes it get from Activesource.

-----Message d'origine-----
De : John Scoles [mailto:scoles@pythian.com]
Envoy=E9 : vendredi 22 septembre 2006 17:28
=C0 : 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 -----=20
From: "Christophe ANTOINE"
To:
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} =3D $ENV{PATH}.';C:\instantclient_10_2';

}



use DBI;



my %opt =3D (

dbname =3D> 'MyDb', #this is the DatabaseName in my
tnsnames.ora, I have tested without tnsnames.ora parameters but with the
, ... for the same result.

dbuser =3D> 'toto',

dbpass =3D> 'toto',

);



my $dbh =3D 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=DAdure sp=DAcifi=DAe 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.

RE: DBI->connect Oracle on Windows, doesn"t Work

On Mon, 25 Sep 2006 10:02:44 +0200, Christophe ANTOINE wrote:

Hi Christophe

> The extension point of Perl_Glockhoock_ptr process is not found in
> the perl58.dll dynamic link library.

Ahhh, that problem!

You can read more about it here:

http://www.xray.mpe.mpg.de/mailing-lists/perl5-porters/2006- 07/msg00470.html=


I just use ODBC instead.

--
Cheers
Ron Savage, ron@savage.net.au on 25/09/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company

RE: DBI->connect Oracle on Windows, doesn"t Work

Hello,

I would to thank you for your help about DBD-Oracle with Windows.
The issue was to install the last version of ActivePerl (v5.8.8).

I have now a problem to install the module DBD-Pg on windows for
Postgres DataBase.
This module isn't referenced in the package list.

I am reading that this issue is a precompilation with my computer and a
C++ compiler of module to install it.

I would like to know if you have another issue for this problem.

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.

RE: DBI->connect Oracle on Windows, doesn"t Work

> I have now a problem to install the module DBD-Pg on windows for
> Postgres DataBase.
> This module isn't referenced in the package list.
>

I experienced and I was told that the Activestate version of DBD::Pg is
not working on windows (I had major crash with it).

So, you should compile it by yourself from CPAN directly.

Please keep us informed if that works.

Thank you


--
Eriam Schaffter

Rue des Lilas 10
1202 Geneve

Phone +41 (22) 534 95 71

RE: DBI->connect Oracle on Windows, doesn"t Work

Christophe ANTOINE wrote:
> Hello,
>=20
> I would to thank you for your help about DBD-Oracle with Windows.
> The issue was to install the last version of ActivePerl (v5.8.8).
>=20
> I have now a problem to install the module DBD-Pg on windows for
> Postgres DataBase.
> This module isn't referenced in the package list.
>=20
> I am reading that this issue is a precompilation with my computer and
> a=20
> C++ compiler of module to install it.
>=20
> I would like to know if you have another issue for this problem.

You can also install the Postgres ODBC driver and use DBD::ODBC (or
DBD::ADO) instead of DBD::Pg. This does not require a compiler. It
will work for most simple applications, but it does not allow you to use
advanced Postgres-specific features (e.g. pg_prepare_now).

Regards,
Philip

RE: DBI->connect Oracle on Windows, doesn"t Work

------_=_NextPart_001_01C6E173.432500E8
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks Philip,

I have fund this morning a DBD-Pg.ppd that I have install with success.

Thanks for your help.
Regards.

-----Message d'origine-----
De=A0: Garrett, Philip (MAN-Corporate) =
[mailto:Philip.Garrett@manheim.com]=20
Envoyé : mardi 26 septembre 2006 15:39
À : Christophe ANTOINE; dbi-users@perl.org
Objet=A0: RE: DBI->connect Oracle on Windows, doesn't Work

Christophe ANTOINE wrote:
> Hello,
>=20
> I would to thank you for your help about DBD-Oracle with Windows.
> The issue was to install the last version of ActivePerl (v5.8.8).
>=20
> I have now a problem to install the module DBD-Pg on windows for
> Postgres DataBase.
> This module isn't referenced in the package list.
>=20
> I am reading that this issue is a precompilation with my computer and
> a=20
> C++ compiler of module to install it.
>=20
> I would like to know if you have another issue for this problem.

You can also install the Postgres ODBC driver and use DBD::ODBC (or
DBD::ADO) instead of DBD::Pg. This does not require a compiler. It
will work for most simple applications, but it does not allow you to use
advanced Postgres-specific features (e.g. pg_prepare_now).

Regards,
Philip

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.


------_=_NextPart_001_01C6E173.432500E8--