TechNote (Archived)

ColdFusion MX: Enabling debugging for DataDirect SequeLink Server ODBC Services

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 covers how to enable debugging for these services in order to obtain more verbose diagnostic information.

1. Open the Services dialog box from the Control Panel and verify that the ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server services are started.
2. Open a command prompt window (Start > Run > CMD).
3. Change directory to the cf_root\db\slserver52\admin directory:

    cd \cfusionmx\db\slserver52\admin 

4. Enter the following command:
   
   

    swcla -l 

   Note: This changes the prompt to swcla>
5. Enter the following command as a single line:

    swcla>sdll "ColdFusion MX ODBC Server" debugging=on fatalerror=on  ssppackets=on ssprequests=on warnings=on errors=on  informationals=on 

6. Verify that the debug log level state is set correctly by entering the following:

    swcla>sdll "ColdFusion MX ODBC Server" 

   This command should output the following listing:
   

    ------------------------------------------------------------------ Debug log level for ColdFusion MX ODBC Server ------------------------------------------------------------------ Level State ----------------------- fatalerror on errors on warnings on informationals on debugging on ssppackets on ssprequests on swcla> 

   Note: If any of the levels are set to off, run the command from step 5 again, specifying only the debug log level you wish to change.
7. Run your query or test. This creates a "ColdFusion MX ODBC Server_xxx.log" debug log file in thecf_root\db\slserver52\logging directory.
   
   Note: The log file created with debugging enabled will increase in size rapidly so debugging should be disabled after running the test.
8. To disable debugging, enter the following command on a single line:

    swcla>sdll "ColdFusion MX ODBC Server" debugging=off  fatalerror=off ssppackets=off ssprequests=off warnings=off  errors=off informationals=off 

Additional Information

---

• Troubleshooting DataDirect SequeLink ODBC service issues (18800)
• Data Source Undefined errors when working with ODBC Socket data sources (18644)

Search Support

---