ExecuteNonQuery halts thread

[Cakkie]

I'm calling the ExecuteNonQuery method of a oledbcommand object. This is done in a class module which runs it's own thread.
When I call the method, the thread seems to freeze, sleep, disappear whatever. The execution never get's to the next line.
Errorhandlers aren't firing either.

Anyone know what could cause this? And How do I solve this?

Dim DBCmd As New OleDb.OleDbCommand()
Dim Sql As String

Sql = "INSERT INTO ....."
DBCmd.CommandText = Sql
DBCmd.Connection = SYS_DBMails ' open OledbConnection

Try
    Dim iRecs As Integer
    iRecs = DBCmd.ExecuteNonQuery() ' "freezes" here 
Catch ex As Exception
    Dim s As String = ex.ToString
End Try

[Edneeis]

Is the connection in the same thread also? Or is it created in the main thread and referenced in the other.

[Cakkie]

Nope. The connection is a public object in a module (not a class). The connection is opened by the main application thread, in another class.

[Edneeis]

Could that be the trouble? Some kind of marshaling problem with the connection. Try opening a new connection in the new thread and see if it still hangs.

[Cakkie]

Hmm, appearantly ADO.Net doesn't respond that well to multithreading...

This is what I've done...

Dim DBCnn = New OleDbConnection(SYS_DBCnn.Connectionstring)
DBCnn.Open
...
DBCmd.Connection = DBCnn
DBCmd.ExecuteNonQuery()

...and it works.

Thanks