TechNote (Archived)

Troubleshooting DataDirect SequeLink ODBC service issues

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. This TechNote will cover several known issues with the services on Windows platforms and details on how to resolve them.

Error 430-Failed to open event trace file because the file version is not recognized
Rollback to ColdFusion MX
Services may not start if installed on a drive other than C:\ or install wizard did not finish
Access to necessary TCP/IP ports is not available
Error 3044-The configured debug log path for the service is not valid
Missing MSVCP60.dll
Installation hangs at Installing ODBC Services
Unable to create ODBC data sources on Windows 2003

Error 430-Failed to open event trace file because the file version is not recognized:

If the SequeLink services will not start (ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server), check the Windows application event log for entries associated with the services. You may see the following error message:

 ColdFusion MX ODBC Agent@LOCALHOST,ErrorCode=430,ErrorMessge= Failed to open event trace file because the file version is not recognized.

WorkAround:

Delete the *.trc event trace logs from the SequeLink server tracing directory, located atcf_root\db\slserver52\tracing\. You should now be able to start the services and the trace files will be recreated.

Rollback to ColdFusion MX:

Once ColdFusion MX 6.1 is installed, if you stop the new ODBC services and try to revert to the original ColdFusion MX services, you must manually update the following registry entry for SequeLink.

WorkAround:

Go to the Start menu. Select Run. Type "regedit" and OK.
Navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\InstallData\ColdFusion MX key.
Modify the value of the SqlLink entry to beUSER_INSTALL_DIR\db\slserver52

where USER_INSTALL_DIR is the cf_home location of whatever install you are pointing at.
Navigate to the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ColdFusion MX ODBC Agent key.
Modify the values as follows:

ImagePath=<old path>
Parameters\DataModel=<old path>
Parameters\LoggingPath=<old path>
Navigate to the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ColdFusion MX ODBC Server key.
Modify the values as follows:

ImagePath=<old path>
Parameters\DataModel=<old path>
Parameters\LoggingPath=<old path>

Services may not start if installed on a drive other than C:\ or install wizard did not finish

In some circumstances, the .ini files containing the location of the DataDirect SequeLink files are not updated properly, causing errors such as "500 Internal Server Error".

WorkAround:

If this is the case, edit any .ini files within thecf_root\db\slserver52\ directory path to ensure all path information is pointing to the correct drive and directory name. In particular, locate any references to \Program Files\Merant and correct the path information. The correct path should becf_root\db\slserver52\.

For example, the incorrect path may appear as:

 C:\Program Files\Merant\db\slserver52\bin\swsoc.exe

For an install using the default location, this would be changed to:

 C:\CFusionMX\db\slserver52\bin\swsoc.exe

Access to necessary TCP/IP ports is not available

The DataDirect SequeLink services need access to two TCP/IP ports: 19997 and 19998. If these ports are blocked, the services may not be able to operate.

WorkAround:

Enable access to both ports.

Error 3044-The configured debug log path for the service is not valid

 ErrorCode=3044,ErrorMessage=The configured debug log path for the service is not valid.

WorkAround:

Create the logging directory atcf_root\db\slserver52\tracing\.

Missing MSVCP60.dll

When trying to start ColdFusion MX using cfstart.bat or starting the ODBC services, the following error may be encountered:

 Dynamic link library MSVCP60.dll could not be found in the specified path

ColdFusion MX and higher requires Microsoft Visual C++ 6.0 runtime or higher, as detailed in the ColdFusion MX System Requirements. msvcp60.dll is one of the core files installed as part of this package.

WorkAround

Windows 98 and XP users can update the runtime components using the options listed in ColdFusion MX: Installation fails with MSVCRT.dll error (TechNote 18937). On computers that are running Windows 2000, these components can be updated through the latest operating system updates and service packs for the operating system. Alternatively, copy msvcp60.dll from another machine, placing it in the winnt\system32 directory.

Installation hangs at Installing ODBC Services

When running the ColdFusion Setup Wizard during the post-installation process, the wizard may hang when it reachesInstalling ODBC Services.

WorkAround

If the ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server services exist in Services in the Control Panel, manually uninstall using the steps detailed in TechNote 19135.
Open the cf_root\lib\adminconfig.xml file for editing and change the runsetupwizard attribute to false.
Manually install the services using the steps detailed in TechNote 19135.

Unable to create ODBC data sources on Windows 2003

On Windows 2003, an error may be encountered when trying to create an ODBC data source.

WorkAround

127.0.0.1 needs to be added as a trusted site in the Local intranet zone.

In Internet Explorer, go to Tools > Internet Options
Select the Security tab.
Select Local intranet.
Click the Sites button.
If you dont see an "Add this Web site to the Zone:" text box, click the Advanced button.
Type 127.0.0.1 in the text box and click Add.