PDA

View Full Version : help on connecting Oracle database on Network....


TaiZhi
07-25-02, 04:09
hi all,
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:

use DBI:
$dbh = DBI->connect("DBI:Oracle:host=colldata;sid=Device",user,password)
or die "Can't connect to Oracle database: $DBI::errstr\n";

but it just cant work .......any1 can help me on that????

thanks all.

akusone
07-25-02, 15:08
Did you install an Oracle driver on the other server ? If not than install the Oracle Client on it and than run the script.