ColdFusion 11 to ColdFusion 2021 upgrade

[Ron Hoit]

Is there an upgrade path from ColdFusion 11 to ColdFusion 2021 using an upgrade?

[Ron Hoit]

The DBsettings are the same as the current server that is working server that is running CF 11

[Priyank Shrivastava.]

Hi,

I think there is some issue with the DB connectivity in CF2021 even though it is working fine in CF11. Can you please check the same in CF2021 CF Admin> Datasources. 

[Ron Hoit]

The DB connnection settings in CF Admin for our CF2021 server are exactly the same as for our CF11 server with the exception our where the DB files are.

On one server they are on the "D" drive

On the other server they are on the "E" drive

Both the DB path in CF Admin is correctly set on each server.

 

[Charlie Arehart]

Is that dsn an access db? Or if not, what driver type is it? If it's access, and as you're on Windows, is the coldfusion 2021 odbc listed in Windows Services, and is it running?

There can be various things that make running Access dbs much harder in recent releases in the past. (And of course some will say that one should not be doing it, 2+ decades into the 21st century.) But it can often be made to work. It just may take more effort than easily offered in a forum like this. But let's see what you may report regarding the above. 

(I will say that given your situation of being the lone cf admin, and new to it, not that you need not "go it alone". There are consultants, like myself and Dave and others, who can help you directly, remotely. I list such consultants at cf411.com/cftrouble.)

[Ron Hoit]

Charlie,

Thanks for your response.  It's actually both MS Access and SQL.  We have 15 different websites that we host.  And yes, being a lone CF admin that doesn't know alot about CF is definately a challange.  The CF 2021 Gold Support that I bought into from Adobe is a joke.  Or I just had a bad run with the last technician.  I actually was able to get support from the guy who originally setup our CF 11 server.  So I'm alittle better off than I was.  We actually got the websites using MS Access DBs to work.  It turned out that I was not using the correct MS Office Access database engine,  64 bit CF 2021 server needs to use the 64 bit version of the MS Office Access database engine, than we needed to use the matching 64 bit ODBC data source connector.  Once that was all correct we could get to the login page for the websites that were using MS Access DBs.  No I'm getting ready to create temp.subdomains for each webite so I can go live and finish configuring the websites that are making a SQL connection to our SQL server (a seperate server).  Then I can also load the required certs, and turn on the SSL for the actual logging into each website to get into the content.  Again, thanks for your added support and I'll definately reach out in the future if needed,

[Priyank Shrivastava.]

Hi Ron,

You can also use Ucanaccess http://ucanaccess.sourceforge.net/site.html  and create the connector using JDBC. 

Please let me know if that helps.