Forum Discussion

smather's avatar
smather
Helper III
3 years ago

OLE DB or ODBC error [DataSource.Error]

I'm using the Dataverse connector to connect to Dyanmics 365, and for a month everything was fine, until Monday when I got this error:

 

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

 

And now everytime I attempt to refresh it, it spits out that error. I've cleared global permissions, ran as admin, and zip, nadda, zilch. 

 

I'm connecting to Oppotunities within the Sales Hub and I have several different tables - won, lost, in progress, to ease the data load burden.

 

I'm at a lost on how to fix this and I'm still waiting for Microsoft to get back to me regarding this, so I thought I'd ask the community for any ideas?

Need Help

4 Replies

    • smather's avatar
      smather
      Helper III
      3 years ago

      thanks amitchandak I'll check that link. And I am waiting to hear back from Microsoft re: ticket regarding this issue, as mentioned, I just wanted to see if anyone else has had/have this issue an if they knew of a fix whilst I wait, given that they tend to take their time 🙂 

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi smather ,

         

        Could please tell if there's any update from you opened ticket?

        Hope your problem can be solved as soon as possible.

         

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.