It sounds as though you are just expecting CF to somehow automatically pickup windows ODBC data sources. This wont happen. It only worked when you upgraded form CF5 because you were upgrading ColdFusion, so it knew about the data sources in the cfadmin and migrated. You need to add the datasources via the coldfusion administrator, this creates an ODBC DSN and then creates a JDBC bridge to connect to it. Sorry if I misunderstood, if you have done this already then read on.
If you look in C:\ColdFusion9\lib\neo-datasource.xml you will find all the DSN's defined in here. Check all the connection properties of the working DSN's and compare them to the non working DSN's and see if there is anything different. If you then look in C:\ColdFusion9\db\slserver54\cfg\swandm.ini You will find all the dsn's defined in here as well for the jdbc connector each dsn is defined like this [DataSource_5] Type=6 DataSourceLogonMethod=OSIntegrated DataSourceProviderTypesFile=C:\ColdFusion9\db\slserver54\bin\swsoc.ini ServiceName=ColdFusion 9 ODBC Server DataSourceName=mydsn DataSourceSOCODBCConnStr=dsn=mydsn DataSourceFetchTimeStampAsString=0 make sure they are defined here, comparing the working ones against broken ones and see if there is any glaring difference. trol pane If all is good, then you should check that the actual ODBC DSN is working, you can do this from administrative tools/Data Sources ODBC find the DSN and then simply test it to make sure it works. If not, then its a windows ODBC problem. Try re-creating the ODBC DSN directly in windows instead of with CF and see if that helps. Russ On Wed, Sep 29, 2010 at 9:29 PM, <> wrote: > > Ok, according to this page : http://kb2.adobe.com/cps/186/tn_18644.html > ColdFusion MX ODBC Agent errors are typically logged to the Windows Event > Log > So I went into the Windows Event Log and I found this indeed : > > " The description for Event ID ( 0 ) in Source ( ColdFusion 9 ODBC Server ) > cannot be found. The local computer may not have the necessary registry > information or message DLL files to display messages from a remote computer. > You may be able to use the /AUXSOURCE= flag to retrieve this description; > see Help and Support for details. The following information is part of the > event: ColdFusion 9 ODBC ser...@localhost,ErrorCode=3059,ErrorMessage=The > specified data source is not defined.,ClientHost=127.0.0.1,Session=20375. " > > Now if somebody is able to explain what the heck this means, I'd be very > grateful. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:337659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
