Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

linked server to transfer info from mssql to mysql Expand / Collapse
Posted Wednesday, February 20, 2013 12:01 PM


Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:18 AM
Points: 11, Visits: 78
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
Post #1422238
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse