Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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

by ig (Vicar)
on Sep 17, 2013 at 03:43 UTC ( [id://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.

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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1054380]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2024-03-19 11:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found