TechNote (Archived)

ColdFusion MX 7.x: Replacement files for SequeLink 5.4 Socket Server

Issue

ODBC access in Macromedia ColdFusion MX is provided through the use of the DataDirect SequeLink Server software. An update to the SequeLink socket server resolves some problems with hangs or crashes under load.

The issues fixed in this release (SP11) are:

A redesign of the poll interrupt mechanism prevents the SequeLink server from hanging occasionally under heavy load.
When using output parameters with type SQL_BIT (boolean), the SequeLink Server for ODBC Socket and the DataDirect Sybase Wire Protocol driver as backend ODBC driver, returned the error:
```
 [ODBC Socket][DataDirect][ODBC Sybase Wire Protocol driver]Sybase does not allow NULL values in 'bit' columns. Error in parameter 1. 
```

Note: This patch is not compatible with the ColdFusion MX 6.1 ODBC Server unless the SequeLink ODBC server has been upgraded to version 5.4. See Technote e917887 for complete information on the upgrade.

Solution

The latest version of the SequeLink 5.4 Socket server is provided below.

Installation instructions

The SequeLink 5.4 SP11 patch replaces the socket server components, swsoc.exe and swsocmsg.dll. The enhanced code page server swsocw.exe is also included.

Download the SequeLink 5.4 SP11 hot fix (880K).
Stop the ColdFusion MX 7 ODBC Server and Agent services.
Apply the hot fix to the cf_root/db/slserver54/bin directory.
Restart the ColdFusion MX 7 ODBC services.

Note: Verify the version by inspecting the most recent ColdFusion MX 7 ODBC Server*.log in thecf_root/db/slserver54/logging directory. For example:
Tue Oct 04 23:42:02 2005:SLX ODBC Socket. Build 009711