Unanswered: help on connecting Oracle database on Network....
i am working on a project where i need to connect to a server which run on Oracle.i have write a script on that local server to query some data and it work fine.but when i move this cgi script to another server and want to connect back to the server on Oracle,it just query nothing........i have write this code to connect:
$dbh = DBI->connect("DBI:Oracle:host=colldata;sid=Device",use r,password)
or die "Can't connect to Oracle database: $DBI::errstr\n";
but it just cant work .......any1 can help me on that????