WangcChiKaBastar (3/26/2010)

---

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