Skip to main content
L
LinuxLen
Participant
January 17, 2022
Answered

Setting up MSAccess to ColdFusion

  • January 17, 2022
  • 1 reply
  • 593 views

I'm brand squeaky new to cold fusion and access, as well as Windows, as I'm a Linux dev.

 

I'm trying to connect Access to cold fusion. I've got as far as installing the accessdataengine.exe, and opened odbcad32.exe. I don't know what to write in the Data Source Name. the helpful instructions I'm following at https://yiengly.wordpress.com/2017/05/02/setting-up-an-ms-access-32-bit-data-source-in-coldfusion/ say use the exact name in the Cold Fusion Administrator. I appear to have missed something there. I've got Commandbox installed, but have no access to the adminitrator page. I've tried going to http://127.0.0.1:8500/CFIDE/administrator/index.cfm with the server running (as it says to do here: https://helpx.adobe.com/coldfusion/configuring-administering/administering-coldfusion.html ), but it says "page isn't working". I have no idea what I'm doing. Then to select the database, what am I looking for? If I even had any idea what name to type in, I can't locate the database, as I have no idea of what it might be or where. The instructions say it's some sort of access database with .mdb but there's nothing on any of my drives with that file extension. The database I created with Access in my home drive is .accdb. Is it that one?

 

So 3 basic issues: can't get in coldfusion administrator, name of data source name, what database to select.

 

Can anyone shed any light on it please? Please be gentle with me, Windows is not my forte. 

    This topic has been closed for replies.
    Correct answer LinuxLen

    Hi,

     

    Thanks for your reply, sorry for the delay I was away for the week. 

     

    Ok, so I was only running CommandBox, which means there was no password set for coldfusion administrator, and the MSAccess connector is deprecated for it. I abandoned it and installed the adobe 2021 version, developer. Then I completely abandoned MSAccess, as I was advised I could use MySQL after all, thankfully! 

     

    The UCanAccess driver definitely looks the part, so it's good to know it is still possible if I need it!

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    January 18, 2022

    What is your ColdFusion version and Update level? Do you realize ColdFusion no longer has support for Microsoft Access?

     

    Nevertheless, you can use an Open Source driver, like UCanAccess. You will find more on that in the following posts:

    https://community.adobe.com/t5/coldfusion-discussions/cf16-and-access-datasource/m-p/9341326 
    https://community.adobe.com/t5/coldfusion-discussions/coldfusion-2021-and-access-database/m-p/11735544 

     

      L
      LinuxLenAuthorCorrect answer
      Participant
      January 25, 2022

      Hi,

       

      Thanks for your reply, sorry for the delay I was away for the week. 

       

      Ok, so I was only running CommandBox, which means there was no password set for coldfusion administrator, and the MSAccess connector is deprecated for it. I abandoned it and installed the adobe 2021 version, developer. Then I completely abandoned MSAccess, as I was advised I could use MySQL after all, thankfully! 

       

      The UCanAccess driver definitely looks the part, so it's good to know it is still possible if I need it!

        BKBK
        Community Expert
        BKBKCommunity Expert
        Community Expert
        January 25, 2022

        @LinuxLen , whoever advised you to choose MySQL over MS Access gave you splendid advice.

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