I am having trouble creating a linked Server.
I set a system ODBC to a mySQL server in the ODBC Data Source Administrator. It test ok.
But I can't figure out to make it a linked server in the Management Studio. I have:
PROVIDER: MediaCatalogDB OLE DB Provider.
What's PRODUCT NAME?
Cannot initialize the data source object of OLE DB provider "MediaCatalogDB" for linked server "myTest".