Hello, I just successfully ran your code against my database. Is it possible you lost the database connection?
Ray -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Deighan Sent: Tuesday, January 24, 2006 10:00 AM To: [email protected] Subject: SQL Server "Invalid Cursor State" Using the DBI with Microsoft SQL Server, I'm trying to get data back from a stored procedure call and getting an "Invalid Cursor State" error at the execute() call below (it never gets to the fetchrow_array call). Has anyone else run into this? Can anyone help? my $sth = $dbh->prepare("exec sp_helpdb"); my $rv = $sth->execute(); my($dbname,$size,$owner) = $sth->fetchrow_array(); while ($dbname) { ..... ($dbname,$size,$owner) = $sth->fetchrow_array(); } _______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs _______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
