Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    UK
    Posts
    15

    Unanswered: Get meaningful error messages…

    I have msAccess clients running smoothly with MySQL backend via ODBC.

    When I test the execution of various invalid sql statements the only error received is 3146 'ODBC--call failed’.

    Is it possible to query MySQL to discover more detail regarding the last error and return a more meaningful message?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, it is

    test your queries with a front end tool like phpmyadmin or mysql-front or sqlyog or any of a dozen similar ones, some of them even free
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2004
    Location
    UK
    Posts
    15
    How do I extract error-codes and error-mesages AFTER a failed query.

    (not how to create queries that don't fail)

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i think that would be an odbc question, not a mysql question

    and meanwhile, testing your queries where you can see the error messages is still advised

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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