At the moment I have the Access datasources working. Here is what solved it for me:
The underlying issue was that message that said "The ColdFusion ODBC Server service is not running or has not been installed." I observed the behaviour of the ODBC server and realized that it was running fine after an install (I redid the CF10 instrall) but it was the next reboot that caused things to stop working. I located an error message in the log that said "ColdFusion 10 ODBC Server@LOCALHOST,ErrorCode=430,ErrorMessage=Failed to open event trace file because the file version is not recognised." And when I googled that one I ran into a similar problem on CF9 where the person reporting it said "I have solved this problem by deleting all of the .trc files in folder C:\ColdFusion9\db\slserver54\tracing. Once that was done, I was able to successfully start the ODBC Server & ODBC Agent services." After deleting the .trc files from C:\ColdFusion10\cfusion\db\slserver54\tracing I was able to start the services manually. I then rebooted and it worked. I am not sure that this is a long term fix but it is working. I notice that the 2 .trc files are back in that folder and hope thay are correct now. And of course I had to also use that workaround mentioned here; http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
