Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

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 = ""; 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/ 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?

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

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (12)
As of 2016-10-27 13:13 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (362 votes). Check out past polls.