Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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?
[stevieb]: I've finally added the ability for berrybrew to fetch the list of perls available directly from Strawberry's releases.json file. Instead of pulling from there on every single call, I've added a berrybrew fetch, so it's only updated..
[stevieb]: ...on request. There's some supporting work I need to do, as well as update the docs, but it's in the v1.12 branch if anyone wants to play with it...
[stevieb]: ...issue 62 will track what else needs to be done.

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2017-03-31 01:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (364 votes). Check out past polls.