Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Remote Oracle database access from windows

by jhourcle (Prior)
on Jul 24, 2009 at 15:18 UTC ( #783015=note: print w/replies, xml ) Need Help??


in reply to Remote Oracle database access from windows

I've never done it from Windows, but in various unix machines, I've done:

  1. (perl was already installed)
  2. Install Oracle client
  3. Configure Oracle client (tnsnames.ora; set TWO_TASK, ORACLE_HOME, etc.)
  4. Verify I can connect via sqlplus
  5. Install DBI
  6. Install DBD::Oracle

If you're using ODBC, I'm not even sure that you need to have the Oracle Client installed -- and I've never used Instant Client, so can't give advice on that one.

See the 'Connecting to Oracle' section of the DBD::Oracle docs for more information -- I assume it'd be the same for Windows.

  • Comment on Re: Remote Oracle database access from windows

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://783015]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2019-05-26 12:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you enjoy 3D movies?



    Results (153 votes). Check out past polls.

    Notices?
    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!