CF 2018 ODBC Server won’t start after update 3 installed

March 29, 2019
Newbie 1 posts
Followers: 0 people
19

CF 2018 ODBC Server won’t start after update 3 installed

Newbie 1 posts
Followers: 0 people
March 29, 2019

We moving from CF9STD on WinSer 2008r2 to CF2018STD on WinSer2016DS for one legacy application with an Access database back-end until we can port it something else. This is a high priority for us because of the APSB19-14  even though this app doesn’t use CFFile (???). Trouble is I can’t get the ODBC service to start after I apply the update. Is there anything I can do? Can I set it up before I update and be ok? I’ve seen others have similar issues but with older versions.  Any direction would be awesome.

Comments (19)
2019-04-03 18:19:51
2019-04-03 18:19:51

I have the same issue and I have to uninstall the update 2 and 3.

Like
(3)
>
weipingz72007364
's comment
2019-04-03 19:50:33
2019-04-03 19:50:33
>
weipingz72007364
's comment
Like
>
Charlie Arehart
's comment
2019-04-23 21:15:13
2019-04-23 21:15:13
>
Charlie Arehart
's comment

This solution does not work.

 

Like
>
bastionh84226254
's comment
2019-04-24 01:06:11
2019-04-24 01:06:11
>
bastionh84226254
's comment

Actually, it “does” work and it has for many. You mean it “did” not work for you, right?

If you can give more details, perhaps we can help.

Like
2019-04-03 16:48:25
2019-04-03 16:48:25

Hello Tim,I’ve faced similar issue on my newly migrated ColdFusion 2018 with update level 3. If you still have this issue,Please follow few steps manually to get ODBC server running .Stop ODBC agent, if it’s currently running.Navigate to ColdFusion18/cfusion/db/slserver54 and take a backup of admin, bin, cfg and tools folders and delete them.Navigate to ColdFusion18/cfusion/hf-updates/hf-2018-00003-xxxx/backup/db/slserver54 and copy admin, bin, tools and paste it in original directory (step-2 for navigation).(in the above navigation hf-2018-00003-xxxx is update level of current ColdFusion server).Now, try refresh and restarting  both ODBC agent and server in services.I hope this should solve your issue.

Like
(1)
(6)
>
H_kumar
's comment
2019-04-03 16:55:15
2019-04-03 16:55:15
>
H_kumar
's comment

Well, that’s a bit risky in that you are restoring a lot of files, and thus undoing potential changes that Adobe felt were intentional.

I’m curious, had you tried the simpler step, of just restoring the one needed file, as outlines in the Adobe technote for known issues, and as I elaborated on in a blog post I had pointed to below many days ago:

https://coldfusion.adobe.com/2019/02/fix-recent-cf11-2016-updates-causing-failure-cf-odbc-services/

BTW, I notice how botched your comment is. Sadly (these days in the portal here), if you edit a comment or reply, it gets all jumbled up like that. Nothing you can do, sadly.

Like
>
Charlie Arehart
's comment
2019-04-03 17:04:31
2019-04-03 17:04:31
>
Charlie Arehart
's comment

That’s the suggestion I had from ColdFusion support to fix this issue and every thing looks good from my end.

Yeah,I’ve tried editing the comments couple of times ,but it’s still going on it’s way.

Like
>
H_kumar
's comment
2019-04-03 19:49:33
2019-04-03 19:49:33
>
H_kumar
's comment

But for the sake of readers, had you tried the simpler approach before doing that? It would be sad if they are recommending that, when the update know issues page proposed the seemingly simpler and safer single file solution.

Like
>
Charlie Arehart
's comment
2019-04-04 13:24:40
2019-04-04 13:24:40
>
Charlie Arehart
's comment

If you’ve any simpler solution to fix this issue ,please let us know that would be really appreciated,Thanks

Like
>
H_kumar
's comment
2019-04-05 02:37:43
2019-04-05 02:37:43
>
H_kumar
's comment

I do and did. See my first reply to you, and the link I shared.

Like
>
Charlie Arehart
's comment
2019-04-08 20:40:07
2019-04-08 20:40:07
>
Charlie Arehart
's comment

My install Support tech had me do the same slserver54  backup and restore process and it had no effect at all. That’s when he asked me to install both C++ redistributables and it worked. I’m betting we didn’t need both.

Like
2019-04-01 18:59:50
2019-04-01 18:59:50

Attachment

In my case we needed to install the Microsoft Visual C++ Redistributable for both x86 and x 64. Awesome installation support BTW. Remember it’s CFInstal@adobe.com…. One “L”.

Like
(1)
>
CFTim1965
's comment
2019-04-01 21:13:36
2019-04-01 21:13:36
>
CFTim1965
's comment

Wow, interesting. For those not catching the subtlety, note that when you install CF itself, it always first installs the VC++ Redistrib for whatever bit-level you are installing CF (so for most, that would be 64-bit).

I gather Tim is saying that for his resolution, he needed to run the one for 32-bit (aka “x86”). Did Adobe provide you a link to that, in case others may want to consider it?

And did they ask you to confirm what version you may have already had, in case they wanted you also to install a later one? Would you have needed to remove an older to add a newer?

Just asking all these to help others who may see this down the road. It’s the first I’ve heard of this as a solution to any problem with CF, let along this specific one.

Like
2019-04-01 13:30:17
2019-04-01 13:30:17

Tim, first the solution applies to cf2018 as well . Though the Adobe resources don’t indicate it, I have had others who ran cf2018 find that the fixes there helped.

Second, yes you do need the services beyi d creating the dsn, if your are using an odbc or access db (really time to get off those, if you needed another reason).

Finally, yes there is free installation support: cfinstall@adobe.com

Like
(3)
>
Charlie Arehart
's comment
2019-04-01 14:08:06
2019-04-01 14:08:06
>
Charlie Arehart
's comment

Perfect. Thanks Charlie

 

Like
>
Charlie Arehart
's comment
2019-04-01 15:04:16
2019-04-01 15:04:16
>
Charlie Arehart
's comment

Attachment

cfinstall not found.

Like
>
CFTim1965
's comment
2019-04-01 16:02:00
2019-04-01 16:02:00
>
CFTim1965
's comment

OK, take off the 2nd “L”, so cfinstal@adobe.com.

Sorry, I thought they had fixed that (As it’s always caused confusion, when people think it’s mispelled without the 2nd “L”.

And I would correct my first post, to save future readers tripping over it, but it seems somehow that the ability to edit comments has been removed (at least today). Grr.

Like
2019-04-01 13:08:13
2019-04-01 13:08:13

Attachment

Thanks Charlie. but because don’t see a similar names file in my backup directory so I’m squeamish about replacing anything. Also most of the other solutions are for older versions.

Question: Do I need the service after I create the connection? I just get an error while creating the Access connection. Meaning could I create the connection with Update 2 (via fresh install) possibly configure the server the for the App and then apply update 3 and be ok? OR export the settings with update 2, run the update 3 and import the settings?

Our license is just a few days old. Is the any installation support to get a updated server completely working ?

Like
2019-04-01 04:07:08
2019-04-01 04:07:08

Tim, check out this post of mine, and let us know if it gets you going:

https://coldfusion.adobe.com/2019/02/fix-recent-cf11-2016-updates-causing-failure-cf-odbc-services/

Like
(1)
Add your comment