var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Updating/Inserting to MYSQL from SQL Server
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.