portal entry

select a category, or use search below
(searches all categories and all time range)

Fix for recent CF11/2016 updates causing failure of CF ODBC services

| View in Portal
February 28, 2019 05:06:28 AM GMT
<p>If you find that the CF ODBC services fail to start after applying the Feb 2019 (or Sep 2018) updates to CF11 or CF2016. (It does not seem to affect those on CF2018), some "good news" is that as a documented "known issue", and more important there is a documented resolution to recover from the problem.</p>
<p>The post <a rel="nofollow" href="https://coldfusion.adobe.com/2019/02/fix-recent-cf11-2016-updates-causing-failure-cf-odbc-services/">Fix for recent CF11/2016 updates causing failure of CF ODBC services</a> appeared first on <a rel="nofollow" href="https://coldfusion.adobe.com">ColdFusion</a>.</p>
Labels: Blog, CF11 Updates, ColdFusion 11, 11, blog, cf11 updates, coldfusion 11


Hey <a href="https://coldfusion.adobe.com/profile/Charlie Arehart">Charlie Arehart,</a> Great post!  Do you have any good and safe resources for disabling and or removing the ODBC Agent and Server in an existing CF Installation for those folks who may want to "cut the cord"? Best buddy, Phill
Comment by Phill Nacelli
1812 | February 28, 2019 02:10:25 PM GMT
It looks like the fix just hit the cf update: <a href="https://helpx.adobe.com/coldfusion/kb/coldfusion-2016-update-9.html" rel="nofollow">https://helpx.adobe.com/coldfusion/kb/coldfusion-2016-update-9.html</a> <a href="https://helpx.adobe.com/coldfusion/kb/bugs-fixed-coldfusion-2016-update-9.html#bugsfixed" rel="nofollow">https://helpx.adobe.com/coldfusion/kb/bugs-fixed-coldfusion-2016-update-9.html#bugsfixed</a>
Comment by Phill Nacelli
1813 | February 28, 2019 02:44:45 PM GMT
I just updated to CF 2018 from CF 11 (developer). The ODBC Agent and Server will not start. When I try to start them, I get "The CF 2018 ODBC Agent Service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs." I have a Microsoft Access database with all my data in it but can't access it (in Dreamweaver) because the services won't start. What can I do to get them to start and stay started or is there another or better way to access the data? Brenda
Comment by Brenda Bowling
1814 | February 28, 2019 08:04:06 PM GMT
Hi, Phil. Well, as I noted, one could just stop it and set the service to be disabled. Or one could use windows to remove them if you really wanted to. For CF11: 1. Open the command prompt using Run as Admin. 2. Run these commands: a) sc delete "ColdFusion 11 ODBC Agent" b) sc delete "ColdFusion 11 ODBC Server" There is also the option to delete them using cfml, using cf's admin API. It that interests anyone, see the last several comments (from June 2014 to Dec 2017) here: https://coldfusion.adobe.com/discussion/1505656/
Comment by Charlie Arehart
1817 | March 01, 2019 02:44:02 AM GMT
Phil, I'm not understanding. I pointed out in the post how this was indeed recognized in the "fixed issues" of the latest updates. Or am I misunderstanding you here?
Comment by Charlie Arehart
1816 | March 01, 2019 02:46:45 AM GMT
Brenda, sorry I missed this. Do you still have the problem? Since you say that this has happened on an upgrade from CF11 to 2018 (as opposed to an update *of* CF2018), it could be simply that you left the CF11 ODBC services in place, and ALSO have the CF2018 ODBC services. If so, can you confirm if it matters whether the CF11 ones are started or not, regarding whether the CF2018 ones will start? If that's the case, it's perhaps simply that they are both using the same ports. If so, it could be that you had CF11 stopped when CF2018 was installed, in which case CF2018 assumed it could use the default ports that CF2016 also assumed to use. Let us know where things stand, and then we can talk about how to resolve it. Or if it IS that things were working in CF2018 until you did an update, then that may be like the problem discussed in this post about what happened to folks in CF11 and 2016.
Comment by Charlie Arehart
1949 | March 27, 2019 09:40:49 PM GMT
Hey <a href="https://coldfusion.adobe.com/profile/Charlie%20Arehart">Charlie Arehart,</a> Great post! its look like <a href="https://helpx.adobe.com/coldfusion/kb/coldfusion-2016-update-9.html" rel="nofollow">https://helpx.adobe.com/coldfusion/kb/coldfusion-2016-</a><a href="https://globalhacknews.com" rel="nofollow">update</a>-<a href="https://helpx.adobe.com/coldfusion/kb/coldfusion-2016-update-9.html" rel="nofollow">9.html</a>
Comment by stevenr88601625
2237 | August 13, 2019 12:47:15 PM GMT
<p>Hi, Steven. First, thanks for the kind regards on the post.</p><p>As for the link you share (to the technote for cf2016 u9) , that page itself makes no mention of the odbc issue. Instead, perhaps you meant to point to the “known issues” link for that update, like I did in the post. Indeed, I quote the pertinent point from it. </p><p>As for whether my post “looks like” it, well, not really. <img src="https://s.w.org/images/core/emoji/2.3/72x72/1f642.png" alt="??" class="wp-smiley" style="height: 1em; max-height: 1em;" /> </p><p>My point was of course to draw attention to that known issue and the fix. (Some people never read the update technotes, let alone the known issues.)  I also offer more context above and below my quote of it. I hope that’s what led you to regard it as a “great post”. <img src="https://s.w.org/images/core/emoji/2.3/72x72/1f642.png" alt="??" class="wp-smiley" style="height: 1em; max-height: 1em;" /> </p>
Comment by Charlie Arehart
2239 | August 14, 2019 01:02:57 PM GMT
Comment by Charlie Arehart
2238 | August 14, 2019 01:03:43 PM GMT