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?
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">
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.