Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: ASP perlscript connection problem..


Message #1 by James Bond <junior_bond@y...> on Tue, 25 Sep 2001 11:42:47 -0700 (PDT)
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.






  Return to Index