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
LVL 1
rgb192Asked:
Who is Participating?
 
HugoHiaslConnect With a Mentor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what is the service pack of the installed version?
0
 
rgb192Author Commented:
sp3
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.