Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: How do you connect to a remote Oracle DB using DBI

by stiller (Friar)
on Apr 15, 2008 at 11:39 UTC ( #680481=note: print w/ replies, xml ) Need Help??


in reply to How do you connect to a remote Oracle DB using DBI

Try:
'dbi:Oracle:IHRLIVE', $uname, $password, ...
or
'dbi:Oracle:IHRLIVE.WORLD', $uname, $password, ...

to match with SID=IHRLIVE in TNSNAMES

hth


Comment on Re: How do you connect to a remote Oracle DB using DBI
Select or Download Code
Re^2: How do you connect to a remote Oracle DB using DBI
by Ronnie (Scribe) on Apr 15, 2008 at 12:01 UTC
    Thanks but I tried that and got the same result.
      I should have mentioned I keep messing with these...

      Have you also tried 'dbi:Oracle:ihr-live.WORLD'?

        I hadn't but I have now and the error is the same.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (11)
As of 2015-07-06 22:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (84 votes), past polls