ColdFusion 2016 Support for SQL 2019?

New Here ,
Jul 08, 2020 Jul 08, 2020

Copy link to clipboard

Copied

Does ColdFusion 2016 support SQL Server 2019? How about the newer versions like 2018? The Product Matrix for 2018 does not list SQL Server 2019 but I have seen some internet chatter that it was coming.

TOPICS
Database access

Views

203

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
community guidelines

correct answers 1 Correct Answer

Adobe Community Professional , Jul 09, 2020 Jul 09, 2020
If it's not listed, it's not supported. But that doesn't mean it won't work. Very little changes between one version of SQL Server and the next, when it comes to client connectivity. So, I'm very confident you can use the DataDirect driver that comes with CF 2016 to connect to SQL Server 2019. If for some reason that's not supported, you could use Microsoft's own JDBC drivers, which you'd have to set up as "other" in the data source configuration. Dave Watts, Eidolon LLC

Likes

Translate

Translate
Explorer ,
Jul 09, 2020 Jul 09, 2020

Copy link to clipboard

Copied

I believe it does, at my company, we have cf versions from cf9 to cf2018  connecting to an azure 2019 SQL servers.

...sorry typo 2018 SQL servers

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
community guidelines
Adobe Community Professional ,
Jul 09, 2020 Jul 09, 2020

Copy link to clipboard

Copied

If it's not listed, it's not supported. But that doesn't mean it won't work. Very little changes between one version of SQL Server and the next, when it comes to client connectivity. So, I'm very confident you can use the DataDirect driver that comes with CF 2016 to connect to SQL Server 2019. If for some reason that's not supported, you could use Microsoft's own JDBC drivers, which you'd have to set up as "other" in the data source configuration.

 

Dave Watts, Eidolon LLC

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
community guidelines
Adobe Community Professional ,
Jul 09, 2020 Jul 09, 2020

Copy link to clipboard

Copied

Adding to Dave's great answer (which I agree to and have marked as "the answer" to the question), there can be times with the support matrix may not yet have been updated though some new "support" has been added. While one could look through the technotes for every CF update to see if they may mention some new support, better still is the available "update release notes" docs that Adobe offers, for both CF 2018 and 2016, which highlights the key changes across all the updates:

 

https://helpx.adobe.com/coldfusion/release-note/coldfusion-2018-updates-release-notes.html

https://helpx.adobe.com/coldfusion/release-note/coldfusion-2016-updates-release-notes.html

 

I can confirm there's no mention there (yet) of support for SQL Server 2019. But like Dave said, that doesn't mean it "won't work", with either the Adobe- or MS-provided driver.


/Charlie (server troubleshooter, carehart.org)

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
community guidelines
Adobe Community Professional ,
Jul 10, 2020 Jul 10, 2020

Copy link to clipboard

Copied

LATEST

To add to the answers you've received, I would suggest you only use versions of SQL Server recommended by Adobe for production. Unless you're willing to accept a substantial risk of failure. 

 

Software integration, for example, CF + SQL Server, is a common source of unpredictable behaviour. Such behaviour can be hard to anticipate or to debug. How many times have you heard, "It had been working for 8000 times. Then, all of a sudden: kaboom!". In my experience, when you hear that, nine times out of ten, it's got to do with integration.

 

When you use the technologies that the folks at Adobe recommend, you benefit from the exhaustive tests, quality control and certification they had performed beforehand. 

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
community guidelines