Skip to main content
J
jmbill4
Participant
April 16, 2014
Question

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

  • April 16, 2014
  • 1 reply
  • 2546 views

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

This topic has been closed for replies.

1 reply

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
April 16, 2014

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:

                                        

SoftwareRelease Year
Coldfusion MX7:2005
SQL Server 2005:2005
Coldfusion 8:2007
SQL Server 2008:2008
Coldfusion 2009:2009
SQL Server 2012:2012
J
jmbill4Author
Participant
April 16, 2014

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
Community Expert
BKBKCommunity Expert
Community Expert
April 17, 2014

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices