Forum Discussion
Helper IIIOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Okay what in the world just happened...I am getting some OLE DB ODBC connection error..the werid thing is that when I duplicate this query it loads in fine..but I dont want to do that because then I have to rebuild all of my connections..is there a way to fix this?
I ended up fixing it..I basically copied the query steps from the advanced editors...I deleted all of the steps up until the Source...I let it refresh, to see if there were any errors. There were no errors displayed, so I pasted back the query steps into the Advanced Editor and everything worked. I don't understand it, but now it works.
2 Replies
- lbendlin
Super User
Any fancy characters in your data?
Solved: 0x80040E4E Error - OLE DB or ODBC - Microsoft Fabric Community
wherdzikI ended up fixing it..I basically copied the query steps from the advanced editors...I deleted all of the steps up until the Source...I let it refresh, to see if there were any errors. There were no errors displayed, so I pasted back the query steps into the Advanced Editor and everything worked. I don't understand it, but now it works.
