Admin Error when deleting DSNs?

[ghinaatrci]

:frown;

Hi, We have CFMX 7 Enterprise running on Win2003 (no SP1). We've created
another instance of CFMX and are having a lot of trouble with the ODBC
connections in this second instance. The error usually says something "cannot
be found". Anyway, we tried to delete the DSN and start over at which point we
got the following message:

Error Occurred While Processing Request
An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException: CreateProcess:
C:\JRun4\servers\OLRSC\cfusion.ear\cfusion.war\WEB-INF\cfusion\db\slserver54\adm
in\swcla.exe -l dsd 'Macromedia ColdFusion MX 7 ODBC Server' 'password_2'
error=3.

"password_2" is the ODBC connection we're trying to delete. Any help out
there?

Thanks!
Ghina

[pelkster]

all,

I am not sure if this well known or not, but we stumbled across this same
issue today when trying to delete an access database from the cf administrator.
The issue revolves around editing, creating or deleteing any datasource
requiring the slserver files.

To fix this issue, I have discovered, you will need to manually copy the
slserver54 folder from:
c:/JRun4/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/db
to
c:/JRun4/servers/NewServerInstance/cfusion-ear/cfusion-war/WEB-INF/cfusion/db

This should be a bug report to Macromedia to determine why the new instances
do not copy this folder automatically... until then, remember to manually copy
this foder if you need to maintain access or other odbc datasources.

V/r,
Charles