I made a linked server (as descriped) but I get the following error,
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "mysql" reported an error. The provider did not give any information about the error.
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.
I can access this one through openquery, can somebody tell me how to resolve this issue.
because I need some information from the mssql database to the database of mysql
I know there is a lot on these forums about this but I don't how to resolve this