CF5 uses ODBC data sources directly so will of course be able to see any that exist on the system.
CF5 will be able to SEE it so you can create a DSN under CF5, but here, creating the DSN under CF9 also creates it in CF5. Kind of weird. But I created and deleted these DSN so often, that nothing surprises me anymore. In fact CF5 need two things in order to have a DSN defined: - data in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI (this is for the ODBC connection) - data in HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSources (this is the definition of the CF5 DSN) An ODBC database does not make automatically a DSN in CF 5 (or 9) When I delete a DSN in CF 9, also defined in CF 5, it will delete the first, the ODBC part, but not the second. The DSN still disappears from CF5 since there is no ODBC connection any more. But if I create again, the DSN, the CF5 key is still in the system, and the DSN will reappear in CF as well. When I create a brand new DSN under CF 9, It will create the ODBC data in registry, but not the data for allaire-CF5, so the DSN should not be created in CF 5. This explains the apparent correlation between CF 5 and CF 9, but not why the JDBC bridge does not work in CF 9. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
