Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Connect to oracle server

by Rahul Gupta (Sexton)
on Aug 29, 2013 at 06:44 UTC ( #1051364=perlquestion: print w/ replies, xml ) Need Help??
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";

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.
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
Re: Connect to oracle server (broken install)
by Anonymous Monk on Aug 29, 2013 at 06:50 UTC
    How did you install DBD::Oracle?
      I used this command to install the module:
      ppm install DBD::Oracle
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,

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1051364]
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2014-09-17 03:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (57 votes), past polls