in reply to DBI sth can't run simultaneously for SQLServer 2008

From DBI:

Portable applications should not assume that a new statement can be prepared and/or executed while still fetching results from a previous statement.

I don't know about SQL Server 2008, but based on your result, it seems it is one of those that does not support this. I never do this myself.

You might be able to use multiple database handles.

You could read all the table details into an array then iterate over the array, so that you have only one active statement at a time.

  • Comment on Re: DBI sth can't run simultaneously for SQLServer 2008

Replies are listed 'Best First'.
Re^2: DBI sth can't run simultaneously for SQLServer 2008
by Thai Heng (Beadle) on Sep 17, 2013 at 06:35 UTC
    I have sovled this problem according to your reply. Thank you very much.