TechNote (Archived)

Data Source Undefined error when working with ODBC Socket data sources in a multi instance configuration

Issue

ODBC Socket data sources are those that utilize the DataDirect SequeLink ODBC Socket Server services. Within the ColdFusion Administrator, this corresponds to the selections in the drop-down driver box for Microsoft Access and ODBC Socket.

When working in a multiple server instance configuration, each instance communicates with the same SequeLink services. When defining an ODBC Socket data source, the data source details are written both to ColdFusion MX's neo-query.xml file as well as the SequeLink swandm.ini file. If a data source with the same name is defined in two or more server instances, each instance will share the same details defined in swandm.ini. If you delete a data source from one instance, the corresponding information will be deleted from swandm.ini. Therefore, any attempt to use that same data source from the other instances will result in a data source undefined error. For example:

 Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.

 Connection verification failed for data source: Yo java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server] The specified data source is not defined.

Reason

Although the data source is still defined in the other instance's neo-query.xml file, the details have been removed from the shared swandm.ini file.

Solution

To resolve this error, it is necessary to edit the data source in one of the other instances, and re-sumbit the data source. This will recreate the necessary settings in the swandm.ini file.

Note: While you may find a swandm.ini file under each instance's directory tree, located in the \WEB-INF\cfusion\db\slserver54\cfg directory, the SequeLink services are configured to only use one of these. This is determined by the most recent time you installed the SequeLink Services. If you wish to see which directory structure SequeLink is using, you may look in the Windows registry under the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ColdFusion MX 7 ODBC Agent\Parameters and HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ColdFusion MX7 ODBC Server\Parameters keys. You may also look at the properties for the ColdFusion MX 7 ODBC Server and ColdFusion MX 7 ODBC Agent services in the Services Control Panel in Windows. This will show the path to the executable run by each service.