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!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

I will give this a try and I will let you know if it works!

 

Thanks for the suggestion!

 

Daren

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!