asp_databases thread: ASP perlscript connection problem..
Hi All,
I am having the following problem while trying to
connect to an Oracle database. I an not sure if it is
my connect ion string. The error is as follows:
Id:
PerlScript Error error '80004005'
(in cleanup) Undefined subroutine &main::RS called
?
The test code I am working with is as follows:
$id = Request("id");
$Conn = $Server->CreateObject("ADODB.Recordset");
$Conn->Open("UID=username;PWD=pword;driver=SQ032_73;dataSource=TNS_Name;");
$RS = $Conn->Execute("SELECT id, lname, fname, role,
work_phone, home_phone, pager, email, location,
comments, developer, tester, active FROM
dr_people_view where id ='" & id & "' ");
%>
<%
$RS->close();
$Conn->close();
%>
Can anyone help me pinpoint the problem???
Thanks,
Bond.