February 21, 2013 at 12:32 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply