All the other answers you've received are good ones but I'd think twice before attempting to use multiple active statements (even though you now can with MS SQL Server). See the following article Multiple Active Statements (MAS) and DBD::ODBC