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

query: from mssql to myssql Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 12:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 6, 2014 7:53 AM
Points: 9, Visits: 71
Like I posted before, 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

I can however access the database through openquery, but I need at this moment a query to transfer data from one database (mssql) to mysql

I have a table in mssql: appel with 5 coloms, col 1 till 5
I have a table in mysql: beer with 4 coloms, cal1 till 4

the first colom of table appel and beer have the same article
what i want is when an article in table appel = article table beer then he should copy the value in col 5 of table appel to the cal4 of table beer

hopefully somebody can help me
Post #1422418
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse