Skip to main content
edesrosi
edesrosi
Participant
May 17, 2019
Question

Installing Coldfusion 2016 32-bit on Windows 2016

  • May 17, 2019
  • 3 replies
  • 934 views

I am having issues trying to install Coldfusion 2016 32-bit on Windows 2016.  I can get the executable to run but it completes with errors.  It looks like it only partially installs.  There is nothing in the install error log that is helpful (or I don't understand it). 

We are loading 32-bit because we require 'MS Access with Unicode' for a datasource.  We are migrating Coldfusion 2016 32-bit from Windows 2008 version where it installed fine. Is there something about Windows 2016 where this won't install?  If someone has done this successfully, that would be helpful information.

    This topic has been closed for replies.

    3 replies

    J
    jpullam
    Known Participant
    July 31, 2019

    Thanx a lot for pointing me to that posting. I had been using different search terms and missed it entirely. Problem now solved with a 64 bit Access install.

    J
    jpullam
    Known Participant
    July 29, 2019

    Does this mean that we must still install ColdFusion 2016 in 32-bit in order to support Microsoft Access databases? I know this was the case when I ran CF 10 but had assumed that this restriction would have been eliminated by now.

    If you must go 32 bit, is there a current article that says what to do for CF and IIS? The one I used to count on is no longer available.

    It was "ColdFusion Home - ColdFusion "

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    July 30, 2019

    I seem to recall finding some ways to set up 64-bit CF to work with MS Access, so I'd try one of those first. You can find them by searching "coldfusion 64 bit microsoft access" or something like that. Here's one that looks likely to work.

    create data source for microsoft access on 64 bit server and ColdFusion 16

    If you do go with a 32-bit CF install, you'll need to set up 32-bit application pools in IIS. I'd recommend that you skip the IIS configuration part during the install, then do this yourself with wsconfig.exe after you've set up the 32-bit application pools. This might help with that.

    IIS7 – Running 32-bit and 64-bit ASP.NET versions at the same time on different worker processes – Rakki Muthukumar

    My overall recommendation to move from Access to a standalone DB engine still stands, though.

    Dave Watts, Eidolon LLC

    Dave Watts, Eidolon LLC
    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    May 17, 2019

    If you're trying to connect ColdFusion with IIS during the install, IIS isn't going to have any 32-bit application pools configured so you may have problems there. So, I'd recommend you skip that option during the install, then configure an IIS virtual server to have a 32-bit application pool, then use the web server configuration tool to connect to that specific IIS virtual server.

    Honestly, I would recommend that you reevaluate your need to use MS Access. It's just going to be a problem for you going forward. You can migrate your data to much more friendly data sources. You could migrate to a free, limited use version of MS SQL Server, or you could migrate to MySQL. Anything would be better than MS Access.

    Dave Watts, Eidolon LLC

    Dave Watts, Eidolon LLC
    kkfin
    kkfin
    Participating Frequently
    May 18, 2019

    There is absolutely no need to give up with MS Access. It is a rock solid software like Exel basically without any real competitors and to have an runtime option is great add on feature. Access can link to SQL Server or Azure SQL Database so you can share same database with ColdFusion and keep your credibility . (Access can also link to Sharepoint lists (not Office365), Dynamic365 and Salesforce). Great software.

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    May 18, 2019

    Kkfn, you may well identify benefits to Access that suit some use cases, but it's really NOT well-suited (nor any longer to be recommended) to running under a mult-user, multi- threaded platform like CF.

    Instead, a multi-user, multi-threaded db server is highly recommended. And those are now available free, for production (mysql, postgres, and more, as well as free versions of sql server, oracle and so on), easily installed, and as has been mentioned with tools available to facilitate migration.

    I can understand someone arguing they don't want to make the move. Just offering a counterpoint to promoting Access as a choice to consider for a CF deployment, in 2019.

    /Charlie (troubleshooter, carehart. org)
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices