In trying to upgrade some scripts to a new server I am running into some
problems with DBI
The original server (which runs perfectly) is
NT4 SP6a
DBI = 1.201
DBD-ODBC = .28
Perl = 5.61.1 build 633
SQL driver 2000.80.528.00
New server is
Win 2000 Sever SP3
DBI = 1.32
DBD-ODBC = 1.03
Perl - 5.6.1 build 635
SQL driver 3.70.09.61
Gets the error
DBD:ODBC::db selectrow_array failed: [Microsoft][ODBC SQL Server Driver]
Invalid cursor state
when it hits the line
($ppkinprogress) = $dbh->selectrow_array("use reverse_logistics SELECT
record FROM tbl_DIRP_FLAG where region = '$region' and getdate() between
start_date and end_date");
Any ideas would be appreciated
Thanks
Phil
