<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.