32-bit or 64-bit OS? In any case, Barney's advice is the best choice if possible.
Dave Watts, CTO, Fig Leaf Software Sent from my DROID On Jun 23, 2011 12:58 PM, "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:6960 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
