I Can not connect to Oracle 10g XE from ASP perlscript web page on IIS 6

[evonczoernig]

I Can not connect to Oracle 10g XE from ASP perlscript 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.


I am not using DBD I use ADODB.Connection.
This works on other servers. NT, VISTA, server 2000. Not sure if it is a permission issue in IIS or what. Thanks for any help


use Win32::ASP;

$Conn = $Server->CreateObject("ADODB.Connection");
$Conn->Open("DSN=SCDATA;UID=tcm;PWD=tcm");

$sql = "select distinct initials, lastname || ', ' || firstname lastname from nurses order by lastname";
$Rs = $Conn->Execute($sql);

while (! $Rs->EOF) {
$empl = $Rs->Fields('initials')->value;
$nme = $Rs->Fields('lastname')->value;
print "<option value=$empl>$nme</option>";
$Rs->MoveNext;
} # while

$Rs->Close;

[kenobewan]

There might differences req in the connection string from the one in your test. You may be right about permissions, but if your app is accessible at all then it won't be IIS.

[evonczoernig]

I figured it out. I installed the Oracle XE client even though I should not need to as I have the database loaded on the same server as the WEB. Set up the ODBC using XEClient driver and included the server name in the tsn service name ie. servername/XE.