> 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
You'd have to give me a trace of what happens before this line to see
what's really going on. Set tracelevel to 8 and post.
There are a LOT of changes between DBD::ODBC 0.28 and 1.03/1.04.
Also, is there a reason that the SQL Server driver seems to be older on
the machine with the newer DBD::ODBC?
Thanks,
Jeff
