Connection busy SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ve an error "Connection is busy with result another command" with oledb and SQL Server 8.00.837 (SP3a
and Framework 1.1.4322.573, MDAC 2.8 RTM. It's not always on the same command and if i try on my serve
Oracle all are clean. I search in many forums but nothing help me for now. (apply FIX BUG #: 469661

Any ideas

I switch off my virus scan but always the same bug...

Thx
 
Hi,

Why don't you try with sql provider instead?
Are you doing multithreading?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Zorglub said:
I ve an error "Connection is busy with result another command" with oledb and SQL Server 8.00.837 (SP3a)
and Framework 1.1.4322.573, MDAC 2.8 RTM. It's not always on the same
Click to expand...
command and if i try on my server
 
I use the same source code for connecting SQL Server, Oracle and Sybase, so I use OleDbConnectio

I use it in a windows service and in a windows form..

In win form, I open connection, I start thread and just show a progress bar..
the thread use the connection and use delegate with windows form...

But i repeat, when I use Oracle server I've not this error...
I don't know if it's an SQL Server BUG or OleDB bug or Network fail...
If I trace my SQL Server I see that the error come always with an sql unprepare, I think that thi
sql unprepare is a result of a update from oledbdataadapter... but not understand why ? perhaps Garbage collector ?
 
Hi,

Are you using the same connection for two concurrent commands perhaps?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Zorglub said:
I use the same source code for connecting SQL Server, Oracle and Sybase, so I use OleDbConnection

I use it in a windows service and in a windows form...

In win form, I open connection, I start thread and just show a progress bar...
the thread use the connection and use delegate with windows form....

But i repeat, when I use Oracle server I've not this error....
I don't know if it's an SQL Server BUG or OleDB bug or Network fail....
If I trace my SQL Server I see that the error come always with an sql unprepare, I think that this
sql unprepare is a result of a update from oledbdataadapter... but not
Click to expand...
understand why ? perhaps Garbage collector ?
 
Back
Top