OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection:

[mpmsltd]

Hi, I'm trying to pull a sales documents table from Dynamics BC and keep getting the error:

OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

Does anyone have an idea of how to deal with this error?

Thanks,
Mariana

[OliT]

Hi @mpmsltd 

>> An existing connection was forcibly closed by the remote host..

You can refer to this article, Troubleshoot PostgreSQL: ‘An existing connection was forcibly closed by the remote host’ - Microsoft...

Let’s say a client application tries to execute a query using a previously opened connection object retrieved from a connection pool. When the application attempts to use the connection object, the connection has gone “stale” and the client application throws an exception from attempting to send query data over the “open” connection.  The client-side logic catches the exception and the TCP connection is closed. 

(Although you are using Dynamics, I think this article can be used for reference)

The only way to understand exactly what is causing the issue is to capture network trace at the client-side at the time when the issue occurrs. Network Traces can be captured by different applications such as NetMon, WireShark, Fiddler, etc.

Regards,

OliT