MS Access Datasources - CF 2016

[webdev314027918]

Configuration: Coldfusion 2016 Standard 64-bit on Windows Server 2012 R2 Standard - 64bit, Java 1.8.

We need to create datasources to several Access databases. (Comments regarding Access not helpful; we do not control this). We do see that Access is not listed on the Systems Support Matrix, however the April 2016 post referenced below seems to indicate that connections can still be made.

We have successfully created such connections in ColdFusion 11 Standard (Server 2012 R2 Standard), but so far cannot create them in Coldfusion 2016 Standard.   The error is 'The specified data source is not defined'.

Have followed to the letter the solution mentioned in this post, to no avail.  Have compared the registry values for both Software/ODBC/ODBC.INI/[datasource] and Wow6432Node/ODBC/ODBC.INI/[datasource] in CF 2016 to those in CF11, no differences.

Have successfully installed Ucanaccess  (jdbc driver for Access) and can connect to databases.  However, driver does not properly interpret our robust queries, dates and more.

We need to connect to these databases:  via ODBC, JDBC - doesn't really matter.  If you've managed to do this using our same configuration, we'd be very grateful to know how.

Thanks in advance,

Sarah

[Guest]

Has anyone come up with a working solution to creating a DSN for an MS Access DB woth CF 16?  I have also tried what the previous poster has.  Is MS Access compatible with CF 2016 at all?  Thank you

[haxtbh]

If its not listed on the Support Matrix then its not supported. This doesn't mean it will not work, its will just be a pain to get working or will not support certain features or work the way you want it.