I got the same error and then I looked to see if there were any illegal conventions, and found the database name had a hyphen �-� in it and when I got rid of the hyphen, the error went away.
Stan
>Hi. I just got this response to a support request from Crystal Tech.
>
>"CF 5 does not support DSNs using MySQL. You have to specify a
>connection string."
>
>Obviously this isn't true. I can connect to their MySQL Server from
>here at home using the same driver (3.51). I tried to explain that
>the only thing CF 5 can't do is MANAGE the DSNs through the CF Admin.
>No response yet.
>
>Here is the error I get whenever trying to run a cfquery. Any clues
>on what the problem may be? I've tried from 2 separate servers, but
>both databases are on mysql5.
>
>By the way, the ONLY difference in the error from one servers to
>another is the '2' (in near '2') is '1' on one of the servers.
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check
>the manual that corresponds to your MySQL server version for the
>right syntax to use near '2' at line 1
>
>The error occurred while processing an element with a general
>identifier of (CFQUERY), occupying document position (4:1) to (4:72).
>
>Thanks!
>--
>
>Bud Schneehagen - Tropical Web Creations, Inc.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
