Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (7)
As of 2018-02-19 17:02 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (266 votes). Check out past polls.