Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Thumbs up Unanswered: SQL syntax error in MySQL when VB6 ADO try to update

    The connection is successful in accessing table in Mysql using the MyODBC 3.51 Driver but only in query mode can anybody help me get rid out the SQL syntax error when ADO data control try to update record. Im using the Mysql 3.23.53a in redhat7 for my server and VB6 for my frontend.

  2. #2
    Join Date
    Jul 2002
    Posts
    55
    Can you post the error and the SQL you're executing? Woooh...deja vu

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Are you able to navigate through the records ok ?

  4. #4
    Join Date
    Nov 2002
    Location
    Egypt
    Posts
    5

    Re: SQL syntax error in MySQL when VB6 ADO try to update

    i dont know your error , but using client site conection solves most errors , unless its SQL syntax

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •