What is the latest version of SQL Server which ColdFusion 7 supports?

[jmbill4]

What is the latest version of SQL Server which ColdFusion 7 supports? For example can Cold Fusion 7 connect to SQL Server 2012 or 2008 without any problem? Thanks

[BKBK]

I can imagine you being unable to find Coldfusion MX 7 information on the web. Adobe has, very unwisely, converted most of the links to point to information about the current product, ColdFusion 10.

However, you can make an intelligent guess from the release dates. Here is the result of a quick product search on the web:

Software	Release Year
Coldfusion MX7:	2005
SQL Server 2005:	2005
Coldfusion 8:	2007
SQL Server 2008:	2008
Coldfusion 2009:	2009
SQL Server 2012:	2012

[jmbill4]

Thanks for your information. Basically we have a legacy website which is still using ColdFusion 7 and unlikely we could upgrade it to use the new CF version. But we also have another project for upgrading all the SQL Servers from 2005 to 2008 or 2012. Did you experience any problems with CF7 while connecting to SQL Server e.g. 2008 or 2012?

The earliest version of official system support matrix I can find from Adobe is just for Cf 8.

[BKBK]

First things first, I would advise you to apply the upgrades, if you haven't yet done so. I remember Coldfusion MX7 to be quite buggy. We could not wait to apply the upgrades and hotfixes. Version MX7.0.2 turned out to be the lasting upgrade. We used MySQL, however, not SQL Server.

You can get the information you want from Adobe Support. But you can think it through yourself. The way I think about it is as follows.

Coldfusion is an application that includes database functionality. I may therefore assume that Coldusion would be backwardly compatible in its support of database server versions. In other words, a new version of Coldfusion, say 9 or 10, would work with an older database server like SQL Server 2005.

However, I would not expect a previous version of Coldfusion, say MX7, to be compatible with newer database server versions like SQL Server 2008 and SQL Server 2012. Even if someone told me they were compatible, I would still expect such a set-up to be an accident waiting to happen.