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

http://www.perlmonks.org?node_id=680481

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

Replies are listed 'Best First'.
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.	[reply]
Re^3: How do you connect to a remote Oracle DB using DBI by stiller (Friar) on Apr 15, 2008 at 12:03 UTC
I should have mentioned I keep messing with these... Have you also tried `'dbi:Oracle:ihr-live.WORLD'`?	[reply] [d/l]
Re^4: How do you connect to a remote Oracle DB using DBI by Ronnie (Scribe) on Apr 15, 2008 at 12:10 UTC
I hadn't but I have now and the error is the same.	[reply]
Re^5: How do you connect to a remote Oracle DB using DBI by stiller (Friar) on Apr 15, 2008 at 12:16 UTC

In Section Seekers of Perl Wisdom