I'm using the Biztalk odbc adapter from the GotDotNet site. I've successfull
y
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 connect
s
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 proble
m.

Can anyone help?

The error I get is as follows:

Unhandled exception caught, exception details:
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCAdapterExcep
tion:
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.ODBCTransmitAdap
terBatch.SendODBCRequest(TransmitterMessage
msg, Boolean getResponse, Stream& ResponseStream)

at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdap
terBatch.OneWaySend(TransmitterMessage msg)

at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdap
terBatch.ProcessWorkItem()

--- End of inner exception stack trace ---

at
Microsoft.BizTalk.Adapters.ODBC.RunTime.ODBCTransmitAdapter.ODBCTransmitAdap
terBatch.ProcessWorkItem()

at
Microsoft.Samples.BizTalk.Adapters.BaseAdapter.ThreadPool.WorkerThreadThunk(
Object state).

[ Post a follow-up to this message ]