VB Forum / Database Access / December 2004

I am trying to connect a VB6 on Win app to MySQL on Lin. I have VB6
referencing ADO 2.7, which in turn connects via a system-wide DSN
using MyODBC 3.51 and links to another machine running Linux and
MySQL.

I hope someone can help. I'm using an update query on the click event of a
button. The query updates a table in an SQL7 db using a string/text box. The
problem that I have is that when users enter text that contains the ' (or
apostrophe, in case this insert fails!!) character ...