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

[Mikee]

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]

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

[Mikee]

I will look into JDBC. Thx for the tip.

Mike