Status/Resolution/Reason: To Track//CannotReproduce
Reporter/Name(from Bugbase): Terry B. / ()
Created: 01/16/2020
Components: Database, MSAccess
Versions: 2016
Failure Type: Non Functioning
Found In Build/Fixed In Build: 2016 r12 /
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Win 2016
Vote Count: 0
Problem Description:
Similar to CF-4203902 which fix was applied in 2016 Update 11 but this is against 2016 Update 2012
It works on Windows 2008 CF11.
This is on CF 2016 r12 on Windows 2016
Feature is critical to operation of application
Adding a Datasouce to ODBC Socket or Microsoft Access leads to below errors.
CF Admin datasource
Connection verification failed for data source: FSC_MDB
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
Application Log
The description for Event ID 0 from source ColdFusion 2016 ODBC Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
ColdFusion 2016 ODBC Server@LOCALHOST,ErrorCode=3059,ErrorMessage=The specified data source is not defined.,ClientHost=127.0.0.1,Session=1
coldfusion-out.log
Jan 16, 2020 07:07:06 AM Error [ajp-nio-8016-exec-2] - [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.
Steps to Reproduce:
32/64 System DNS exists
Add ODBC Socket, select DSN Name, Click Submit
Actual Result:
See above
Expected Result:
Datasource OK
Any Workarounds:
None Found
Checked Permissions on install folders and ODBC registry entries. Service account has full access.
Attachments:
Comments: