Forum Discussion
ODBC error
OLE DB or ODBC error: [DataSource.Error] Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host I get this error when i do changes in tra...
Hi swaroopjk ，
What data source are you connecting to? Could you please share the applied steps in your Advanced Editor in order to make troubleshooting? And could you please also explain which step you are applying to get that error message?
There are two similar cases below, please check the solutions given there. Hope it can help you solve the problem too.
OLE DB or ODBC error: [DataSource.Error]
However, I did a workaround on it. My query was merged with another table and that seems to be causing the error. Hence, instead of using merge, I did a LOOKUPVALUE function in the table instead to get the columns I needed and that seems to work out just fine. Not sure why the merge would cause the error, but LOOKUPVALUE was the only workaround I could think of.
Unable to read data from the transport connection (check the post from Adescrit on 07-15-2019)
Best Regards
