Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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

by ig (Vicar)
on Sep 17, 2013 at 03:43 UTC ( #1054380=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1054380]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2020-10-01 17:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (16 votes). Check out past polls.

    Notices?