Visual foxpro ODBC socket in Coldfusion 9

This may be your issue: look in Windows services. Do you see the "ColdFusion 9 ODBC Agent" and "ColdFusion 9 ODBC Server" listed, after ColdFusion 9 Application Server? If not, the issue is that whoever installed CF9 chose NOT to enable ODBC support (it's an option asked during installation, even in CF2016).

If that's the issue, you have good news: You can add the code by running the following code, which adds the services to Windows:

<cfscript>

   //change pw below to your CF Admin pw. If you MUST provide a username and password to login to the Admin, then swap the
   //comments and use the second login statement, and if your username is other than "admin", change that in the 2nd argument

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

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

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

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

  ds.installODBCservice();

  writeOutput("ODBC Services installed");

</cfscript>

It immediately adds the services and enables them, and then see if you see the DSN when you refresh the CF Admin DSN page.

Note, though, that if your CF service is running as other than "Local System", this code above will not work, for a couple of reasons. You could stop CF, change it to run as local system, run the code, and then set it back to the original user CF was running as (just make sure you know that user's password before removing it!)

Let us know if this gets you going.