Highlighted

Is Coldfusion 8.0 compatible with SQL Server 2014 / 2016?

New Here ,
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

447

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

Is Coldfusion 8.0 compatible with SQL Server 2014 / 2016?

New Here ,
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

448

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

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...
Feb 15, 2018 0
LEGEND ,
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,

^ _ ^

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...
Feb 16, 2018 0
Adobe Community Professional ,
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.

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...
Feb 17, 2018 0
Adobe Community Professional ,
Feb 17, 2018

Copy link to clipboard

Copied

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

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...
Feb 17, 2018 0