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

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


Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:18 AM
Points: 11, Visits: 78
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