<snip>
>Thanks for the tip. It lead me to the fact that lcSql was formated wrong. For some reason it needed to have single quotes around the values instead of double quotes. Below is the line I changed that fixed the problem
>
>lcSql = "update mysqltable set myfield1 = 'value1' where myfield2 = 'value2'"

Check topic SET QUOTED_IDENTIFIER in SQL Server Books Online for explanation.