cold fusion error ODBC Server service is not running or has not been installed

Now that you have clarified that you are using cf builder 2018, do you mean you took its offer to install cf2018 for you?  If you've separately installed cf2021 or 2018 and are referring to that, let us know.

If it's cf2018 at port 8600, that's the cf installed by CFB. It's different than normal in a couple of key ways: a) it's implemented within folders where CFB is installed, rather than it's own cf folder (so instructions related to cf will need to be translated for that difference), and b) it does not offer or implement such related services as the odbc support. (Many folks don't even realize there IS this different way to install CF, which adds to the challenge of solving such problems. I'll add that this bundled CF install is NOT offered with the new free CFB released last year which is based on the Visual Studio Code ide.)

So first, if you're working that way and having this odbc challenge, that was discussed in another forum thread here in 2021. See in particular 3 comments:

• my reply (marked as the thread's "answer") where I discuss the CFB challenge starting in the 4th paragraph, and in my last paragraph I point to past other discussions by bkbk on installing an alternative Access driver
• Then 2 months later BKBK offered that info again. If you're on cf2018, check out his posts on that alternative Access driver
• Finally, if you may be using cf2021 that you installed separately from CFB, see a last comment by @TheRealMC suggesting that he used the cf admin package mgt feature (only in cf2021 and beyond) to remove and re-add the odbc package.

Let us know if any of this gets you going. You'll see that other thread also has more admonition from me, Dave, and BKBK to encourage movement off of Access. I led with it there but not here, because I know some people feel the choice is "out of their hands".

Still, the admonition should be pressed, by us to the community and by you to your decision-makers--even if that's you, alone. 🙂 But again we keep throwing out the lifeline for those who prefer to be towed through the murky waters rather than be brought onto the boat. 

@minals74665441 , Please let us know 

1.  your ColdFusion version, Update Level and Edition (whether Enterprise or Standard);
2.  the Operating System on which ColdFusion is installed.

Step 1: yikes!

Seriously, I have a lot of things to say here. First, why are you using Access with ColdFusion? It's really not a good idea. Just because you can do something doesn't mean you should. I've spent countless consulting hours trying to fix screwed up Access with CF issues, because Access is not intended to be used by CF or similar systems. Those hours have paid me very well! But they've still been frustrating. The Access database format has a lot of features that benefit you if you have one or two users, but don't work well if you have many users. For example, the Access database doesn't get smaller as you delete data, but it obviously gets larger as data is added. So you might end up with a very large database with a very small amount of data in it! This is ... bad.

Second, why not use the MS Access with Unicode driver? I honestly don't know if it's still included in the latest versions of CF or not, but it sidesteps all the JDBC-ODBC hassle you get when you're setting up 64-bit ODBC. Use that if possible.

Third, make sure the ODBC Server and ODBC Agent services are running. I'm not sure why there are two services, but there are. @Charlie Arehart mentioned something about this.

Dave Watts, Eidolon LLC

Well, first, is the cf odbc service listed in and running in the Windows Services panel (I assume you're running Windows)?