Sample Header Ad - 728x90

The OLE DB provider "MSDASQL" for linked server "(null)" reported an error

1 vote
1 answer
5536 views
I created a linked server to MySQL database server on my SQL Server database server. I tested the connection. It succeeded successfully for MySQL connection. I can see the databases on MySQL instance via my linked server but when i try to run a query with OPENROWSET, it gives me an error message like below. I have searched it on google many times but i couldn't solve my issue. What is the problem? Why do i get this message and how to solve it? > The OLE DB provider "MSDASQL" for linked server "(null)" reported an > error. The provider reported an unexpected catastrophic failure. Msg > 7330, Level 16, State 2, Line 25 Cannot fetch a row from OLE DB > provider "MSDASQL" for linked server "(null)".
Asked by DBA (69 rep)
May 26, 2020, 08:35 PM
Last activity: Sep 12, 2024, 05:01 PM