2 Replies Latest reply on Feb 17, 2017 7:16 AM by haxtbh

    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