Skip to main content
E
erics17815277
Participating Frequently
March 25, 2015
Question

ColdFusion 10: All services missing from Services dialog (except ColdFusion 10 Application Server)

  • March 25, 2015
  • 1 reply
  • 2763 views

I'm receiving the following error when I try to add a DSN:

The ColdFusion ODBC Server service is not running or has not been installed

In trying to resolve that error, I discovered that other than ColdFusion 10 Application Server, there are literally no ColdFusion services listed -- running, stopped, or otherwise.

1: Is this normal?

2: How do I install, start or register those services? Clearly they're needed.

    This topic has been closed for replies.

    1 reply

    Anit_Kumar
    Anit_Kumar
    Inspiring
    March 25, 2015

    Hi Eric,

    You need the ODBC service installed, in order to use the Datasources. Save the below code in a cfm page and run this. It will create the ODBC services.

    <cfscript>

      //login using admin 

      //createObject("component","cfide.adminapi.administrator").login("administrator_password");

      createObject("component","cfide.adminapi.administrator").login("admin");

      //instantiate datasource object

      myObj = createObject("component","cfide.adminapi.datasource");

    </cfscript>

     

    TO Install ODBC Services:

    <cfscript> 

             writeOutput("Installing ODBC Services...<br>"); 

             returnValue = myObj.installODBCservice(); 

             writeOutput("ODBC Services installed"); 

    </cfscript>

    Regards,

    Anit Kumar

    E
    erics17815277Author
    Participating Frequently
    March 25, 2015

    Anit, thanks -- this code errors out.

    1: Is that one page, or two? (If I run it as a single page, it errors out.)

    2: Do you have any insight as to why the services weren't instantiated on install?

    Anit_Kumar
    Anit_Kumar
    Inspiring
    March 25, 2015

    This is a single page code. Remember to change the "admin" to your "ColdFusion Administrator Password". It will work.

    <cfscript>

      //login using admin

      //createObject("component","cfide.adminapi.administrator").login("administrator_password" );

      createObject("component","cfide.adminapi.administrator").login("admin");

      //instantiate datasource object

      myObj = createObject("component","cfide.adminapi.datasource");

    </cfscript>

    TO Install ODBC Services:

    <cfscript>

            writeOutput("Installing ODBC Services...<br>");

            returnValue = myObj.installODBCservice();

            writeOutput("ODBC Services installed");

    </cfscript>

    You may have to check the install logs for the same.

    ERIC SCOLES wrote:

    Do you have any insight as to why the services weren't instantiated on install?

    Regards,

    Anit Kumar

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