Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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

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?
      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 rifling through the Monastery: (8)
As of 2016-09-28 12:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:







    Results (527 votes). Check out past polls.