A
angell
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?
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?