[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.Connection");
$Conn->Open("DSN=SCDATA;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.Connection. 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

Expand|Select|Wrap|Line Numbers

1. use Win32::ASP;
2.  
3. $Conn = $Server->CreateObject("ADODB.Connection");
4. $Conn->Open("DSN=SCDATA;UID=tcm;PWD=tcm");
5.  
6. $sql = "select distinct initials, lastname || ', ' || firstname lastname from nurses order by lastname"; 
7. $Rs = $Conn->Execute($sql);
8.  
9. while (! $Rs->EOF) {
10.     $empl = $Rs->Fields('initials')->value;
11.     $nme = $Rs->Fields('lastname')->value;
12.     print "<option value=$empl>$nme</option>";
13.     $Rs->MoveNext;
14. } # while
15.  
16. $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