Is Coldfusion 8.0 compatible with SQL Server 2014 / 2016?

[happyev]

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!

[carl type3]

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.

[WolfShade]

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,

^ _ ^

[BKBK]

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.

[Dave Watts]

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