using perl DBI and DBD::Oracle

[abruzzi]

Hello,

I've a machine on windows, and i want to connect on a database oracle on a server unix;
For using perl DBI and connecting to the server,
I must install a Oracle client on my windows pc ?

Thanks for your answers

 

[abruzzi]

i've install the oracle client but when i run my script i've this error

DBI connect('IRON1','user',...) failed: ORA-12154: TNS:could not resolve t
he connect identifier specified (DBD ERROR: OCIServerAttach) at C:\Documents and
Settings\billy\scripts\connect.pl line 14
Database connection not made: ORA-12154: TNS:could not resolve the connect ident
ifier specified (DBD ERROR: OCIServerAttach) at C:\Documents and
Settings\billy\scripts\connect.pl line 14.

on line 14 i've this

my $dbh = DBI->connect("dbi:Oracle:$dbname", $user, $passwd) or
die "Database connection not made: $DBI::errstr";

 

[MikeLacey]

Hello abruzi,

Can you contact the database using tnsping?

Can you get to the data with other tools (sqlplus perhaps) that use the client install?

Mike

Hardware is that part of a computer which, when you remove electrical power, doesn't go away.

Want great answers to your Tek-Tips questions? Have a look at faq219-2884