I've created a linked server in MS SQL Server 2008 to a remote MySQL server. When I try to query any tables, I get an error:
.tablename. contains no columns that can be selected or the current user does not have permissions on that object.
Does anyone know why this happens?
UPDATE: Looks like this is a known issue with MSSQL SERVER 2008