I've set up a site with ColdFusion and MySQL in win2k just a month ago. It
works great. No problems I know of.
About the setting up, the only pointer I have is that the DSN must be a
system DSN, or ColdFusion won't recognize it. Other than that, ODBC should
be smooth sailing.
-----Original Message-----
From: Steve Ruby [mailto:[EMAIL PROTECTED]]
Sent: March 8, 2001 2:24 PM
To: Andrew Staples
Cc: [EMAIL PROTECTED]
Subject: Re: Cold Fusion
Andrew Staples wrote:
>
> New to list, and to mySQL. If there are archives available, please let me
> know--I'll search them.
>
> I have a client who is building a new win2k server, and wants to use
> ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it
> will work with myODBC, but gives examples for Unix.
>
> 1. Can CF work with mySQL via myODBC on win2k?
> 2. Is there a better way to use CF and mySQL?
> 3. Any other gotchas?
>
> Thanks,
>
> Andrew Staples
> Snow Day -- stay home.
>
Link to archves at the bottom of the page.
1. Yes
2. Not that I know of as win2k CF supports OLEDB but there is no driver for
mysql
3. You will have to add the datasources through the control pannel and then
set the CF settings in the CF administrator, you can't add datasource in the
administrator like you can for Access and MS-SQL,
other than that it works great I mean I'm not a fan of CF anymore but I've
got several sites that still run CF and Mysql with no problems at all.
This is definately do-able.
It has come up (see archives) before buut I don't recall anybody having
problems
other than setting the DSN.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
