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
Last activity: Sep 12, 2024, 05:01 PM