I am having difficulty in inserting records into a Mysql database from MS SQL Server as a linked server.

I have an SQL script as the following:

'SELECT task_id, task_name, task_parent, task_order FROM dotproject.tasks')

VALUES (38,'TASK TEST', 3, 0)

I'm sure I had this working before. I don't think the above SQL is worng however I recall something about a setting on the ODBC Provider Options that needs setting?

I get the error message: Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.

when I run the above SQL statement in SQL Server Query Analyser.

I can run an OPENQUERY SELECT statement which returns records successfully just cannot do updates or inserts.

Any help would be appreciated.