Connection busy SQL Server

[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

 

[Miha Markic [MVP C#]]

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

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 server

 

[Guest]

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 ?

 

[Miha Markic [MVP C#]]

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

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

understand why ? perhaps Garbage collector ?

 

[Guest]

The same connection for each thread but then one work, another wait....

 

[Miha Markic [MVP C#]]

Hi Zorglub,

You should really create a connection instance per thread.