Check your case...all tables need to be referenced lower case
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]
Sent: 20 February 2004 15:49
To: CF-Talk
Subject: Re: MySQL and CF 5
>Of course that is not correct. We have been supporting MySQL via DSN
from CF
>5.0 ever since 5.0 was released. Both on Windows and Linux platforms.
>
>CFMX 6.1 also supports MySQL DSNs.
They don't have a problem with MX.
>======================================
>Stop spam on your domain, Anti-spam solutions
><http://www.clickdoug.com/mailfilter.cfm>http://www.clickdoug.com/mailf
ilter.cfm
>For hosting solutions
<http://www.clickdoug.com>http://www.clickdoug.com
>======================================
>Aspire to Inspire before you Retire or Expire!
>
> ----- Original Message -----
> From: Bud
> To: CF-Talk
> Sent: Friday, February 20, 2004 7:50 AM
> Subject: MySQL and CF 5
>
> 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.
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> Web Based Solutions / eCommerce Development & Hosting
> <http://www.twcreations.com/>http://www.twcreations.com/ -
><http://www.cf-ezcart.com/>http://www.cf-ezcart.com/
> Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968
>
>[
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Re: MySQL and CF 5 Bud
- Re: MySQL and CF 5 Thomas Chiverton
- RE: MySQL and CF 5 Matt Robertson
- Re: MySQL and CF 5 Jochem van Dieten
- RE: MySQL and CF 5 Mike Townend
- Re: MySQL and CF 5 Stephen Moretti
- Re: MySQL and CF 5 Doug White
- Re: MySQL and CF 5 Paul Lowton
- Re: MySQL and CF 5 Stan Winchester