Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

OLE DB or ODBC error: [DataSource.Error]

Hi,   I've got this error code while applying query changes:   OLE DB or ODBC error: [DataSource.Error] An error happened while reading data from the provider: 'A transport-level error has occurr...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I tried changing the parameters previously and it didn't work.

     

    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.

     

    Thanks!

AshutoshL_7697's avatar
AshutoshL_7697
Regular Visitor
1 year ago

Hey , I'm facing the same issue :

 

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

I'm trying to connect Business Central and sometimes it connects (2/100) , mostly it is failign with this reason . This just started couple of days ago .

I tried all the resolutions on the this page , but I'm unable tos olve this issue . My numbe rof rows (Data Load) is also less.

Can someone please help me out ?