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
- 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;
