portal entry

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

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

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

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

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

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

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

<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

Brenda?

Comment by Charlie Arehart