ODBC access in Macromedia ColdFusion MX and higher is provided through the use of the DataDirect SequeLink Server software, which runs under the Windows services labeled ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server (MX 6.x) orColdFusion MX 7 ODBC Agent and ColdFusion MX 7 ODBC Server (MX 7). This TechNote provides information on how to install and uninstall these services manually in order to help in instances when ColdFusion may fail to install them properly, such as in upgrades or new installations.

Installing the ColdFusion MX ODBC Services:

1. Create a ColdFusion template to run the following code on your ColdFusion MX Server, modifying the cfusionHome variable if necessary:
   
   ColdFusion MX 7:

    <!--- set this to the location of your cfusion directory ---><cfset cfusionHome="C:\CFusionMX7"><!--- install sequelink ---><cftry><cfexecute      name="#cfusionHome#\db\SequeLink Setup\Setup.exe"      arguments='!TargetDir="#cfusionHome#" !DoDNS=true'></cfexecute><cfregistry    action="set"    branch ="HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX"    entry="SqlLink"    type="String"    value="#cfusionHome#\db\slserver54"><cfcatch type="Any"><cfoutput><font color="red">Error Occurred:</font>   #cfcatch.message#<br>#cfcatch.detail#<p></cfoutput></cfcatch></cftry> 

   ColdFusion MX 6.x:

    <!--- set this to the location of your cfusion directory ---><cfset cfusionHome="C:\CFusionMX"><!--- install sequelink ---><cftry><cfexecute      name="#cfusionHome#\db\SequeLink Setup\Setup.exe"      arguments='!TargetDir="#cfusionHome#" !DoDNS=true'></cfexecute><cfregistry    action="set"    branch ="HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX"    entry="SqlLink"    type="String"    value="#cfusionHome#\db\slserver52"><cfcatch type="Any"><cfoutput><font color="red">Error Occurred:</font>   #cfcatch.message#<br>#cfcatch.detail#<p></cfoutput></cfcatch></cftry> 

   Note: Standard web server security should be implemented with the template containing this code to prevent accidental or malicious use.
2. Confirm that the ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server services were created in Services in the Windows Control Panel.

Uninstalling the ColdFusion MX ODBC Services:

1. Run the cf_root\db\SequeLink Setup\RemoveSequeLink.bat file.
2. Confirm that the ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server (MX 6.x) or ColdFusion MX 7 ODBC Agent and ColdFusion MX 7 ODBC Server (MX 7) services are no longer listed in Services in the Windows Control Panel.

Additional Information

• Troubleshooting DataDirect SequeLink ODBC service issues (18800)

Products affected