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.
======================================
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions 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.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 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