I am trying to set up mySQL as a linked server in MSSQL. I have done this with both servers on the same machine but they reside on different machines. I have a working ODBC system datasource. But when I try to access the tables from MSSQL enterprise manager-security-linked servers I get
"Error 7399:OLE DB provider 'MSDASQL' reported an error. Data source name not found and no default driver specified] OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
I suspect it is the settings I am using in the Linked server wizard. Does anyone know either the ad_linkedserver sp parameters, or what I should be entering into the linked server wizard in enterprise manager.