Anyone with experience usging ADO for Oracle?

From: angell (centuryinnovative_at_gmail.com)
Date: 03/29/05


Date: 28 Mar 2005 14:54:04 -0800

Gurus,

Please help. I am new to Active Perl. I downloaded Active Perl 5.6 to
my local PC(Win2000 professional). I installed DBI-Oracle and tried to
access database through DBI in a standalone perl program, it worked
fine.

Then I tried to use ADO in my asp pages.(I installed IIS as well and
set up the system DSN "sd11".) I copied the code from the documentation
and appended them to my asp page.

<%
  $Conn = $Server->CreateObject("ADODB.Connection");

  $Conn->Open("sd11");

  $RS = $Conn->Execute("SELECT * from orders");

  $count = $RS->Fields->{Count};
  $Conn->Close();
%>

I keep getting this error message:
"Can't call method "Fields" on an undefined value ". It seems the $RS
object is not initiated. I don't have Access installed on my PC, so I
couldn't test out whether my system DSN is created. But my gut feeling
is that I'm missing sth else here.

Can someone please help me out?