• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Is Coldfusion 8.0 compatible with SQL Server 2014 / 2016?

New Here ,
Feb 15, 2018 Feb 15, 2018

Copy link to clipboard

Copied

Hello.

Is/Has anyone using/used Coldfusion 8.0 with SQL Server 2014 or 2016?

We currently have Coldfusion 8.0 and it works well with SQL Server 2012.

Now, we are about to update our SQL Server to 2014 or 2016.

Wondering if I need to ask for exception if 2014/2016 is incompatible with CF8.

Thank you in advance!

Views

645

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
Guide ,
Feb 15, 2018 Feb 15, 2018

Copy link to clipboard

Copied

Hello,

As I recall CF8 supports to SQL 2005.

CF2016 offers support for SQL 2014 and 2016.

https://helpx.adobe.com/pdf/coldfusion2016-support-matrix.pdf

HTH, Carl.

Votes

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
LEGEND ,
Feb 16, 2018 Feb 16, 2018

Copy link to clipboard

Copied

To add to carl type3​'s answer, if you are deploying code to a public facing site/app, you really don't want to use CF8, if for no other reason than security.  Not to mention the updates to processing and the use of Tomcat for Java instead of JRUN.

I know CF isn't inexpensive - that's one of my irks with Adobe.  But you really should consider upgrading.  At the very least to CF10.  Which can be acquired from the CFML Repo.  Licensing will be another issue.

HTH,

^ _ ^

Votes

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
Community Expert ,
Feb 17, 2018 Feb 17, 2018

Copy link to clipboard

Copied

ColdFusion 8 was released in July 2007. Its End-Of-Core-Support date was July 31, 2012. Its End-Of-Extended-Support date was July 31, 2014.

SQL Server 2012 was released in March 2012. Service Pack 1 was released in November 2012 and Service Pack 2 in June 2014.

To me, the risks and the choice are clear. I wouldn't use on ColdFusion 8 any version of SQL Server 2012 released after March 2012.

Votes

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
Community Expert ,
Feb 17, 2018 Feb 17, 2018

Copy link to clipboard

Copied

LATEST

Like everyone else here, I would definitely upgrade ColdFusion. But from a purely technical perspective, you can use ColdFusion 8 with whatever JDBC database drivers you can find. So, even if you can't use it with the ones shipped with it, you can download Microsoft's own JDBC driver and install that, and select "other" instead of "SQL Server" for your database connection.

Dave Watts, CTO, Fig Leaf Software

Dave Watts, Eidolon LLC

Votes

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
Resources
Documentation