|
| I'm using the Biztalk odbc adapter from the GotDotNet site. I've successfully
sent insert statements to a Microsoft Visual Foxpro database via a send port
that's using the odbc adapter provided that the database is on the same
computer as the Biztalk server. The odbc driver allows unc paths and connects
to locations across the network and I can use VS.NET's server explorer to
connect to that data source and perform any operations on it... so the odbc
driver seems to be working fine.
I've tried different transaction levels and I still get errors (not all the
same errors) but it feels like the errors are secondary to the actual problem.
Can anyone help?
The error I get is as follows:
Unhandled exception caught, exception details:
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCAdapterException:
The ODBCAdapter encounted an error transmitting a batch of messages. --->
System.InvalidOperationException: This OdbcTransaction has completed; it is
no longer usable.
at System.Data.Odbc.OdbcTransaction.Rollback()
at Microsoft.BizTalk.Adapters.ODBC.BTSODBCQueryEngine.Rollback()
at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdapterBatch.SendODBCRequest(TransmitterMessage
msg, Boolean getResponse, Stream& ResponseStream)
at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdapterBatch.OneWaySend(TransmitterMessage msg)
at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdapterBatch.ProcessWorkItem()
--- End of inner exception stack trace ---
at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdapterBatch.ProcessWorkItem()
at
Microsoft.Samples.BizTalk.Adapters.BaseAdapter.ThreadPool.WorkerThreadThunk(Object state).
|
|