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.
- 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>
<!--- 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>
Keywords:
tn_19135
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.
