Highlighted

MS Access Datasources - CF 2016

Community Beginner ,
Sep 22, 2016

Copy link to clipboard

Copied

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

Views

3.7K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

MS Access Datasources - CF 2016

Community Beginner ,
Sep 22, 2016

Copy link to clipboard

Copied

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

Views

3.7K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Feb 17, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
haxtbh LATEST
Advocate ,
Feb 17, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Resources
ColdFusion User Guide
CFML Reference Guide
Develop CFML Applications
Add a group