Connect to oracle server

Rahul Gupta has asked for the wisdom of the Perl Monks concerning the following question:

Hi ,

I am trying to connect to oracle server from windows 7 64 bit machine:

use DBI;
use DBD::Oracle;
my $host = "192.xxx.x.xx";
my $sid = "mydb";
my $connection = DBI->connect("dbi:Oracle:host=$host;sid=$sid;",'oracl
+e','test12345')
 or die "Connection Error: $!\n";
[download]

getting following error:

"The procedure entry point OCIPing could not be located
in the dynamic link library OCI.dll"
<br>
Can't load 'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Or
+acle: load_file:The specified procedure could not be found at C:/Perl
+/lib/DynaLoader.pm line 201.
[download]

More Details.

i am using active state perl 5, version 12,on windows 7, 64 bit and
oracle 11g 32 bit is on linux box.

Thanks in advance

Comment on Connect to oracle server Select or Download Code

Replies are listed 'Best First'.
Re: Connect to oracle server (broken install) by Anonymous Monk on Aug 29, 2013 at 06:50 UTC
How did you install DBD::Oracle?	[reply]
Re^2: Connect to oracle server (broken install) by Rahul Gupta (Sexton) on Aug 29, 2013 at 07:14 UTC
I used this command to install the module: `ppm install DBD::Oracle`	[reply] [d/l]
Re^3: Connect to oracle server (broken install) by Anonymous Monk on Aug 29, 2013 at 07:33 UTC
What repository, ActiveState? If that is the case, report the problem to their support -- I guess http://community.activestate.com/forums/ppm although through http://community.activestate.com/search/?keys=oracle I have found Unable to run perl on windows 7 64-bit machine (DBD::Oracle error) \| ActiveState Community Site and while the error messages don't exactly match, they're in the same flow so the solution might be the same , which is -- make sure you have both 32bit and 64bit oracle client installed which according to the published log is LD_RUN_PATH=C:/instantclient_11_2/lib:C:/instantclient_11_2/rdbms/lib or you need to adjust your %PATH% to include instacli..... or whatever Good luck	[reply]
Re: Connect to oracle server by jakeease (Friar) on Aug 29, 2013 at 07:25 UTC
I think with ActiveState, you want to install it as `ppm install C:\DBD-Oracle.ppd` You may also need to set some environmental variables. I don't have ActiveState, so I can't go much further. EDIT: Oh, I see you answered Anonymous Monk before I posted,	[reply] [d/l]