[thelist] Tip - ColdFusion and Datasources
Frank
lists at frankmarion.com
Wed Aug 13 23:21:00 CDT 2003
<tip type="ColdFusion" author="Frank Marion">
For those who are setting up earlier versions of ColdFusion (notably
version 4.5), you'll notice that ColdFusion doesn't natively handle MySQL
datasources from the select menu in the ODBC administration panel.
Presuming that you are on Windows here's what you need to do to get it working:
1) Install MyODBC (available at http://www.mysql.com)
2) Set up your datasources in Start-> Programs-> Administrative Tools->
Data Sources (ODBC)
You must set up your datasource under SYSTEM DSN, not user DSN. The
ColdFusion administrative panel will still fail to display a select menu
with the MySQL ODBC source, but they will be visible, and accessible to
your apps.
I know that ColdFusion MX ships with the Merant MySQL ODBC driver, version
5 may as well.
</tip>
Not only have I now caught up on tips, I do believe that I'm one ahead!
It's kind of like paying your bills a day early! <g>
--
Frank Marion lists at frankmarion.com Keep the signal high.
More information about the thelist
mailing list