Can you grab the free SQL Server edition, upscale from Access to that, and then use JDBC? Not a totally transparent upgrade but avoiding both ODBC and Access will save you a world of pain in the long run, and the upgrade is pretty straightforward.
cheers, barneyb On Thu, Jun 23, 2011 at 9:57 AM, Ryan Patsko <[email protected]> wrote: > > I upgraded from CFMX7 Standard to CF9 Enterprise this week. Since the > upgrade, I am unable to create a new datasource using either the ODBC Socket > driver or the Microsoft Access driver. When I attempt to add an ODBC Socket > ds, I get this message: > > The ColdFusion ODBC Server service is not running or has not been installed. > > Both the ODBC Server service, and the ODBC Agent service are installed and > running. I tried uninstalling and reinstalling the services (using the > instructions in the comment of this tech note: > http://help.adobe.com/en_US/ColdFusion/9.0/Installing/WSc3ff6d0ea77859461172e0811cdec18ae0-7fed.html) > > but the problem was not solved. I also had to fix port numbers as described > in this post: > http://russ.michaels.me.uk/index.cfm/2010/3/5/Microsoft-Access-DSNs-no-longer-working-after-upgrading-to-ColdFusion-9. > > (After my original install, none of my imported datasources worked until I > changed those ports from 19999/20000 to 19997/19998) > > Has anyone run into this issue? I've googled it for days and I have an open > case with Adobe, but so far we have not been able to solve it. I appreciate > any suggestions. > > Other install details: Windows Server 2003 Web Edition SP2, using IIS v6.0. > Also using Sequelink 5.4 - I feel like the issue might be with that but I'm > just guessing at this point. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6959 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
