I Can not connect to Oracle 10g XE from ASP perscript web page on IIS 6 running on server 2003. I have set up the database and the ODBC connections. The ODBC connection is workinh and I can connect to it via the ODBC test. I have the same ASP application running on a VISTA workstation and it connects fine.
Here is the connection string that works fine on the VISTA PC put I can not get it to work on the server 2003 system.
$Conn = $Server->CreateObject("ADODB.Connection");
$Conn->Open("DSN=SCDATA;UID=tcm;PWD=tcm");
SCDATA is the ODBC data source name.
Thanks for any help.