Anyone with experience usging ADO for Oracle?
From: angell (centuryinnovative_at_gmail.com)
Date: 03/29/05
- Next message: PerlFAQ Server: "FAQ 5.26 How do I print to more than one file at once?"
- Previous message: joesplink: "Re: Stings - textareas in Perl..."
- Next in thread: robic0_at_yahoo.com: "Re: Anyone with experience usging ADO for Oracle?"
- Reply: robic0_at_yahoo.com: "Re: Anyone with experience usging ADO for Oracle?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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?
- Next message: PerlFAQ Server: "FAQ 5.26 How do I print to more than one file at once?"
- Previous message: joesplink: "Re: Stings - textareas in Perl..."
- Next in thread: robic0_at_yahoo.com: "Re: Anyone with experience usging ADO for Oracle?"
- Reply: robic0_at_yahoo.com: "Re: Anyone with experience usging ADO for Oracle?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]