query: from mssql to myssql

• koen_huys

  Old Hand

  Points: 337

  More actions

  February 21, 2013 at 12:32 am

  #289889

  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