Status/Resolution/Reason: Closed/Withdrawn/UserError
Reporter/Name(from Bugbase): Aaron Neff / ()
Created: 04/30/2018
Components: Database, MSAccess
Versions: 2018
Failure Type: Non Functioning
Found In Build/Fixed In Build: 2018.0.01.308605 (PreRelease) /
Priority/Frequency: Normal / Some users will encounter
Locale/System: / Windows 10 64 bit
Vote Count: 0
Issue: Access DSN creation fails
Repro:
1) In CF Admin, create a "Microsoft Access" data source named "MyAccessDSN" pointing to attached MyAccessDatabase.mdb.
2) See red error text:
-----------
- Unable to update the NT registry.
Variable DRIVERPATH is undefined.
-----------
3) See writeDump(queryExecute("SELECT * FROM myTable", [], {datasource="MyAccessDSN"})) throws "java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused."
4) Per CF-4202199, change all '20006' to '20008' in neo-datasource.xml and restart CF.
5) See writeDump(queryExecute("SELECT * FROM myTable", [], {datasource="MyAccessDSN"})) throws "java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified"
6) In CF Admin, delete the "MyAccessDSN" DSN
7) Install AccessDatabaseEngine_X64.exe (Microsoft Access Database Engine 2016 Redistributable) from https://www.microsoft.com/en-us/download/details.aspx?id=54920
8) Repeat #1
9) See red error text:
-----------
- Connection verification failed for data source: MyAccessDSN
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
-----------
10) Repeat #4
11) See writeDump(queryExecute("SELECT * FROM myTable", [], {datasource="MyAccessDSN"})) succeeds
Actual Result: Step #7 is necessary
Expected Result: Step #7 is unnecessaryAttachments:
Comments: