Forum Discussion
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 occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)'.
I am able to load the data into query editor and view it but whenever I try to apply the query, it loads for a few minutes and this error pops up. I have tried changing the connection and command timeout but it's still not working.
Any idea what's going on here and how to fix it?
Thanks!
Daren
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!
11 Replies
Try to delete the Cache at the options in Power Bi Desktop. This helped me to solve the problem.
Anonymous
When working with SQL Server it creates a Server Process ID that is used to manage access to temporary tables. For any number of reasons, this connection could be lost and then it assigns you a new SPID. But when you try to submit the query it is acting on the old one.
Contact your SQL Admin and get them to change the Auto Close property on the database to False.
---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."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!
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 ?Excellent, it worked first time!
