TechNote (Archived)

Unable to create ODBC Socket data source using instances created by Instance Manager

Issue

In a multi-server configuration, one can use the Instance Manager to create additional server instances. When using a server instance created by the Instance Manager, any attempt to create an ODBC Socket or Access data source will fail with one of the following errors:

 Unable to update the ColdFusion MX 7 ODBC Server. An error occurred when performing a file operation WRITE on file C:\JRun4\servers\cfusion2\cfusion.ear\cfusion.war\WEB-INF\cfusion\db\ slserver54\admin\{datasource name}.inp.
		

	 The cause of this exception was: java.io.FileNotFoundException: C:\JRun4\servers\cfusion2\cfusion.ear\cfusion.war\WEB-INF\cfusion\db\ slserver54\admin\{datasource name}.inp (The system cannot find the path specified).

 "Error","web-11","08/02/05","15:05:18","cfadmin","An exception occurred when invoking an external process.The cause of this exception was that: java.io.IOException: CreateProcess: C:\JRun4\servers\test2 \cfusion.ear\cfusion.war\WEB-INF\cfusion\db\slserver54\admin\swcla.exe -l dsd 'ColdFusion MX 7 ODBC Server' 'test' error=2. The specific sequence of files included or processed is: C:\JRun4\servers\test2\cfusion.ear\cfusion.war\CFIDE\administrator\ datasources\msaccess.cfm "

Reason

This is due to a bug in the Instance Manager.

Solution

To resolve the error, it is necessary to copy the slserver54 directory from the main cfusion instance (for example, the instance running the Instance Manager) to the other instances created by the Instance Manager. In a default installation, this would be located in C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\db\slserver54. If a second instance was called cfusion2, this should be copied to C:\JRun4\servers\cfusion2\cfusion-ear\cfusion-war\WEB-INF\cfusion\db\.