I have established a linked server to MYSQL to SQL Server Database
When I run this query I get error :
select * from mysql.brightlink.src_customers
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "mysql". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.
however this works fine..
select * from openquery(MySql, 'select * from brightlink.src_customers')
I want to avoid using openquery as this is slow in production
please advise about four part naming convention from sql server to mysql