I followed the steps in this article and successfully got a Linked Server on SSMS.
The database is there, but no tables are visible. Aren't I supposed to be able to view the tables, just like regular SQL Server tables can be viewed? None are listed.
I also ran some code manually to get info on a table:
SELECT * FROM OPENQUERY (MYSQL, 'SELECT * FROM Mytable')
and got this error:
An unexpected NULL value was returned for column "[MSDASQL].checked_out_time"
from OLE DB provider "MSDASQL" for linked server "MYSQL". This column cannot be NULL.