Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Oracle Data Sources on Windows

by ephemeral (Initiate)
on Feb 23, 2004 at 20:41 UTC ( [id://331201]=perlquestion: print w/replies, xml ) Need Help??

ephemeral has asked for the wisdom of the Perl Monks concerning the following question:

Okay. I just uninstalled and deleted all traces and reinstalled ActivePerl & DBI & DBD::Oracle and I had no trouble getting my "use DBI;" to work. Now I've hit the next bit of ignorance. I've got Toad. Toad is accessing all of the Oracle dbs in the tnsnames.ora file just fine. When I check for Oracle data sources I get nothing. Can anyone advise me on how to inform my script whatever it needs to know in order to avail itself of the network Oracle sources? Thank you.

Replies are listed 'Best First'.
Re: DBI on Windows
by perrin (Chancellor) on Feb 23, 2004 at 20:58 UTC
    How did you install DBI? Which DBD are you using? How did you install the DBD? Do you have your database client libraries installed locally? Can you show us your code?
Re: DBI on Windows
by Grygonos (Chaplain) on Feb 23, 2004 at 21:30 UTC

    <edit>Make sure you don't have an empty DBI folder in any of your directories encompassed by @INC. There could be a blank one @ C:/Perl/lib/DBI. DBI on my windows installation defaults to C:/Perl/site/lib/DBI. Make sure you don't have DBI components anywhere else but C:/Perl/site/lib/DBI. I'm just throwing out ideas here. This is a somewhat perplexing issue assuming you have done everything correctly as you say.</edit>

    Chances are DBI wasn't installed by default.

    Assuming you're using ActiveState's perl distribution. Go to Start->Run and type ppm and Click OK. Then at the prompt type install DBI. Then depending on what DBD driver you're using install that as well. you can type search ODBC to find ODBC modules in the repositories.

    You could also download it from DBI and install it manually via Nmake1.5.


    Grygonos
Re: DBI on Windows
by rdfield (Priest) on Feb 24, 2004 at 11:01 UTC
    Are you sure you installed DBD::Oracle using ppm3? Last time I checked ActiveState weren't distributing DBD::Oracle for 5.8.x because of licensing issues. You can still install 5.6 and use ppm to install DBD::Oracle though.

    Try the following to make see what you've installed:
    (paraphased from the docs)

    use DBI; foreach my $driver( DBI->available_drivers) { print "\n$driver " . join("\n\t",DBI->data_sources($driver)); }
    Just checking: you have read the documentation for DBI, haven't you?

    rdfield

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://331201]
Approved by Old_Gray_Bear
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (5)
As of 2024-04-24 07:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found