CF2018 new install, (64bit windows) Error: ODBC service not running or has not been installed

October 21, 2019
Newbie 1 posts
Followers: 0 people
2

CF2018 new install, (64bit windows) Error: ODBC service not running or has not been installed

Newbie 1 posts
Followers: 0 people
October 21, 2019

I downloaded CF developer edition yesterday and installed successfully.Went to set up the DNS in the admin. I entered the name and selected MS Access from the drop down list of drivers and get this message:

“The ColdFusion ODBC Server service is not running or has not been installed. You may also use the “MS Access with Unicode” driver to connect to MS Access datasources.”

(there is no “MS Access with Unicode” in the list, but never mind)

Here are the details copied from the CF admin system info:

System Information
Server Details
Server Product ColdFusion 2018
Version 2018.0.02.313961
Tomcat Version 9.0.10.0
Edition Developer
Operating System Windows 10
OS Version 10.0
Adobe Driver Version 5.1.4 (Build 0001)
JVM Details
Java Version 11.0.1
Java Vendor Oracle Corporation
Java Vendor URL http://java.oracle.com/
Java Home C:ColdFusion2018jre
Java File Encoding Cp1252
Java Default Locale en_US

Is there an update or fix for this? I have found this issue listed on other help forums but the solution is either missing, redirects to a generic page, or, in one case, just too convoluted to follow. Any help much appreciated!

Comments (2)
2019-10-21 18:57:10
2019-10-21 18:57:10

Well, ARE the two cf odbc services showing as running? They are a choice offered during install of cf. Did you install cf? Did you tell it to install those?

Like
(1)
>
Charlie Arehart
's comment
2020-01-16 20:16:52
2020-01-16 20:16:52
>
Charlie Arehart
's comment

I have the same problem with a fresh install. Both ODBC services are installed but the ODBC Server service wont start.  Error 1053: the service did not respond to the request in a timely manner. This is a fresh CF 2018 install with no updates applied. I tried installing the x86  vc++ runtime redistributable package as one post suggested but that did not help.

System Information

Server Details

Server Product
ColdFusion

Version
2018,0,02,313961

Edition
Enterprise Trial

Operating System
Windows Server 2008 R2

OS Version
6.1

Adobe Driver Version
5.1.4 (Build 0001)

Tomcat Version
9.0.10.0

Any help would be appreciated as we are evaluating CF 2018 to use with a legacy application that requires a single ODBC data source to run successfully. This is a show stopper unfortunately.

Like
Add your comment