Correct SQL Server linked server connection settings to MySQL that will allow inserts
Just a quick observation: you using MySQL 5.1 Driver against MySQl 5.0.92

I recommend you should either


downgrade to MySQL 5.0 ODBC Driver (easier option)
upgrade to MySQL 5.1.61