MySQL four-part name
Posted by sheezy on 16 June 09
All day I’ve been trying to use this four-part name to run queries on my linked server. All day…… 
Everyone seemed to suggest doing the four-part name instead of OpenQuery.
Every time I tried the four-part name, I would get this error:
“A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.”
Of course when I found someone else with the same problem as me, they hadn’t found a solution. But…I finally figured it out. MySQL doesn’t support schemas or owners. So saying, LinkedServerName.DBName.Owner/Schema.TableName wasn’t working because it wasn’t supported. I’m too lazy to try to remember my search query that brought me to those forums of people with the same problem as me. Now, there won’t be an answer to their problem. Oh well.
Anyways, what ended up working for me was: LinkedServerName…TableName
