Coldfusion 9 will not connect to sql database set up as ODBC

Question

I've just installed the 64 bit version Coldfusion 9 on a 64 bit Win 7 machine where I have several SQL Server data bases set up with ODBC.

When I go into CF admin to add a datasource, it will not see the ODBC connections I have set up.

Unless I find a solution I will have to uninstall this 64 bit version of Coldfusion and try the 32 bit version instead.

Just a note, these ODBC data sources were set up using c:\windows\sysWOW64\odbcad32.exe

I hope there is a setting somewhere that I missed.

JR__Bob__Dobbs-qSBHQ2 · Answer

Have you considered using JDBC rather than ODBC? I suspect that both Adobe and Microsoft view ODBC as a legacy technology.

Sign up