I think you are still not understanding. CF5 is not JAVA, it doesn't use JDBC, it uses ODBC. CF9 doesn't create the DSN in CF5,it creates an ODBC DSN in windows, and this is what CF5 is picking up. If you create an ODBC DSN in the windows control panel, then it will also show up in the CF5 admin. I know 100% that this is true as this is how we allow customers to create DSN's for CF through our hosting control panel.
Russ On Thu, Sep 30, 2010 at 5:20 PM, <> wrote: > > 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:337694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
