Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, February 20, 2013 12:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:36 AM
Points: 8, Visits: 68
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