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

[evonczoernig]

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.Connectio n");
$Conn->Open("DSN=SCDA TA;UID=tcm;PWD= tcm");

SCDATA is the ODBC data source name.

Thanks for any help.

[eWish]

This does not look like perl code to me. Would you please post a bit more of the code where it involves perl. Are you using the DBD::ODBC driver? This connection string does not look correct if you are.

--Kevin

[evonczoernig]

I am not using DBD I use ADODB.Connectio n. Here is some more of the PERL code. This works on other servers. NT, VISTA, server 2000. Not sure if it is a permission issue in IIS or what. Thanks again 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;

[eWish]

I am not familiar with an IIS server, therefore, not sure how the permissions work for them. I would suggest that you ask if it could be a permission issue in the IIS forum. As far as the perl code it looks correct.

--Kevin