Is Coldfusion 8.0 compatible with SQL Server 2014 / 2016?

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

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.

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,

^ _ ^

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.