Can't connect to remote oracle db

[phil at 1918.com (Phil Buckley)]

Still no dice Kevin,

That returns "DBI->connect failed: ORA-12154: TNS:could not resolve service name (DBD: login failed)"

Any other ideas???

Phi

*********** REPLY SEPARATOR  ***********

On 3/22/00 at 12:45 PM Kevin D. Clark wrote:

>Phil Buckley writes:
>
>> Does anyone have any experience using perl/DBI to connect to a remote Oracle db?
>> 
>> I'm getting much to frustrated with what I suspected would be a simple routine.
>> 
>> All I really need is the ...
>> 
>> $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd,  
>> { RaiseError =>1, AutoCommit => 1}) || die "Unable to connect: $DBI::errstr";
>> 
>> Where do I put in the host in the scenario <aargh> too late, I'll look for answers in the morning.
>
>Try this:
>
>$dbh = DBI->connect("dbi:Oracle:host=$host", $user, $passwd,
>                    { RaiseError =>1, AutoCommit => 1})
>           || die "Unable to connect: $DBI::errstr";
>
>Hope this helps,
>
>--kevin
>-- 
>Kevin D. Clark          |                           |  Will hack Perl for
>kclark at NOSPAM.ctron.com | kdcNOSPAM at .alumni.unh.edu | fine food, good beer, 
>Cabletron Systems, Inc. | PGP Key Available         |      or fun.
>Durham, N.H. (USA)      |                           |



-
Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at blu.org (Subject line is ignored).