COM connector fails under load

lee

Good afternoon.

I'm having some problems with using the COM connector to connect my ASP.NET page to Axapta. It fails if I try to create too many records too quickly but is fine if I do it slowly.

AxaptaConn.TTSBegin()

Dim updateRec As AxaptaCOMConnector.IAxaptaRecord
updateRec = AxaptaConn.CreateRecord(TableName)
updateRec.ExecuteStmt(<MY SELECT QUERY HERE>)

If updateRec.Found Then
updateRec.field("Field1") = "ABC"
<etc>
End If

updateRec.DoUpdate()
AxaptaConn.TTSCommit()


It logs on OK and everything works fine, as long as I do not try to create
more than about one record per second. If however I start to send the records very quickly, I get an exception when the code reaches AxaptaConn.TTSBegin().

The exception is of type InteropServices.COMException. The message is "The remote procedure call failed. (Exception from HRESULT: 0x800706BE).

Additionally, when this occurs, I get an event in the Application log for
the OS of EventId 110.

The text is :

Axapta COM Connector Session 65535.

Exception 0xc0000005 occured in thread 0xcf8 handling session 65535.

Basically what I hoped someone could point out is

A) Does the COM connector have known limitations when it comes to handling this kind of high-load request (ie. rapidly creating many records).

or

Is there perhaps some obvious way in which I could re-configure my server / IIS / COM to accomodate this high load?

or

C) Is there some obvious problem with my code? Am I misusing TTSBegin()?

I have read that the COM connector will not cope with more than 250
simultaneous web connections. Is this possibly another kind of limitation of
the connector?

Thanks in advance for any ideas, I'm under high pressure to come up with
some kind of solution.

Lee.