Skip to main content
M
mahancm
Participating Frequently
November 18, 2020
Question

32 bit ODBC with 64-bit Coldfusion 2018

  • November 18, 2020
  • 1 reply
  • 264 views

The last time I saw this specific question asked was many years ago. However, I was wondering if Coldfusion 2018 release could see a 32-bit ODBC connection with its ODBC Socket option? It seems 64-bit Microsoft programs like Power BI Desktop will no longer work (or see) a 32-bit ODBC driver unless you install the 32-bit version of the software. Can anyone confirm 32-bit ODBC support still in CF or better yet is anyone using a 32-bit ODBC driver in CF2018?

 

Thank you.

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    November 22, 2020

    ColdFusion certainly has an ODBC Socket driver. You can obtain the details as follows:

    <!--- Login into Coldfusion Administrator. --->
 <cfset  createObject("component","cfide.adminapi.administrator").login("your_CF_Admin_password")>

<!--- Instantiate the data source object. --->
 <cfset  datasourceObject = createObject("component","cfide.adminapi.datasource")>
 
 <!--- Get a structure containing all the database drivers --->
 <cfset databaseDrivers = datasourceObject.getDriverDetails()>
 <!---<cfdump var="#databaseDrivers#" label="All available database drivers">--->

 <!--- Driver for the ODBC Socket --->
 <cfdump var="#databaseDrivers['ODBC Socket']#" label="ODBC Socket driver">

     

    M
    mahancmAuthor
    Participating Frequently
    November 23, 2020

    I am exploring whether or not the ODBC socket in CF would see and be able to use a 32-bit ODBC configuration setup in the Windows Server 32-bit ODBC Administrator. It seems all 64-bit programs I have come across need to have the 32-bit version of that program (if it exists) installed on the machine in order to see 32-bit ODBC setup in the Windows Server 32-bit ODBC Administrator. CF is of course 64-bit now, so I am checking to see if anyone can confirm 32-bit ODBC Administrator setups still work on a Windows Server with CF? I do not have the option to test this yet myself, and am wanting to know if I should even pursue it as an option.

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