Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

update error

the previous update command does not execute

i get this error
Error: SQLSTATE[HY000]: General error: 0 [Microsoft][SQL Native Client]Connection is busy with results for another command (SQLExecute[0] at ext\pdo_odbc\odbc_stmt.c:133)


is there a way to set a command to stop the other command
0
rgb192
Asked:
rgb192
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what is the service pack of the installed version?
0
 
rgb192Author Commented:
sp3
0
 
HugoHiaslCommented:
You cannot have lets say a datareader open when you try to update the database with another command object using the same connection.

If there is another command object open or the result set, that still will be fetching data, you cannot use the same connection for another command.


0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
rgb192Author Commented:
maybe there is locking

i want to stop previous command so i can run new command
0
 
rgb192Author Commented:
or maybe I can pause and wait
0
 
ateeq0malikCommented:
windows 7 is the latest windows so it doesnt have  any service pack with it..
0
 
rgb192Author Commented:
????
0
 
rgb192Author Commented:
I closed the connection.
thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now