Chris 3:47 am on July 14, 2015

Adding ColdFusion 11 ODBC Services

If you didn’t get ColdFusion 11’s (and probably 10’s) ODBC Server and Client services installed but end up needing them you can create a simple ColdFusion script to get it installed.

adminObj = createObject("component","cfide.adminapi.administrator");
adminObj.login("{CF Admin Password}","{CF Admin User}" );
adminObj.installODBCservice();

Anit 5:08 am on July 14, 2015

To remove corrupted service, you can use:-

adminObj = createObject(“component”,”cfide.adminapi.administrator”);
adminObj.login(“{CF Admin Password}”,”{CF Admin User}” );
adminObj.removeODBCservice();
Mike Collins 2:48 pm on September 21, 2017

Looks lit it moved in 2016. I just made a quick change:
- Robbie 11:54 am on December 8, 2017
  
  What change did you make? I’m not seeing that installODBCservice method.
carehart 9:32 am on December 29, 2017

Mike, I found that things worked just fine in CF2016. What “change” did you make?

Also, Robbie, when you say you are “not seeing” that method, where are you looking? It’s there, and it works.
Raj N 7:49 am on February 25, 2019

There’s supposed to be 2 different calls. One of them to administrator api to login. The other one to datasource api to add/remove odbc service:

To install ODBC

adminObj = createObject(“component”,”cfide.adminapi.administrator”);
adminObj.login(“{CF Admin Password}”,”{CF Admin User}” );
datasourceObj = createObject(“component”,”cfide.adminapi.datasource”);
datasourceObj.installODBCservice();

To un-install ODBC

adminObj = createObject(“component”,”cfide.adminapi.administrator”);
adminObj.login(“{CF Admin Password}”,”{CF Admin User}” );
datasourceObj = createObject(“component”,”cfide.adminapi.datasource”);
datasourceObj.removeOdbcService();