I did a Web Service API that allows you to remotely setup DSN's, mappings and sandboxes, it is being used in HELM control panel. I could not solve this error so we reverted back to using the Java Service Factory.
Russ -----Original Message----- From: Dan Parker [mailto:[EMAIL PROTECTED] Sent: 09 October 2006 19:32 To: CF-Talk Subject: Re: Automating data source password changes For our MX 6 server, I've been working with the following code. It keeps giving a numerical error. The number seems to be based on the password that I pass to the component: <cfset setDSN=createObject("component","cfide.administrator.components.datasource") > <cfinvoke component="#setDSN#" method="setOracle"> <cfinvokeargument name="dsn" value="parkerd"/> <cfinvokeargument name="host" value="[IP removed]"/> <cfinvokeargument name="sid" value="[SID removed]"/> <cfinvokeargument name="port" value="1813"/> <cfinvokeargument name="username" value="thisUser"/> <cfinvokeargument name="password" value="howBoutThat"/> <cfinvokeargument name="epassword" value="howBoutThat"/> <cfinvokeargument name="class" value="macromedia.jdbc.MacromediaDriver"> </cfinvoke> 11 The error occurred in E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 332 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 3 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 1 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\datasource.cfc: line 540 Called from E:\Inetpub\wwwroot\virt.parker\dsp\setMyDatasource.cfm: line 18 Called from E:\Inetpub\wwwroot\virt.parker\index.cfm: line 11 Stack Trace at cfsetdsn2ecfm2110276039._factor4(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:332) at cfsetdsn2ecfm2110276039._factor5(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:3) at cfsetdsn2ecfm2110276039.runPage(E:\Inetpub\wwwroot\CFIDE\administrator\compo nents\_datasource\setdsn.cfm:1) at cfdatasource2ecfc1645517805$funcSETORACLE.runFunction(E:\Inetpub\wwwroot\CFI DE\administrator\components\datasource.cfc:540) at cfsetMyDatasource2ecfm1566537573.runPage(E:\Inetpub\wwwroot\virt.parker\dsp\ setMyDatasource.cfm:18) at cfindex2ecfm919545483.runPage(E:\Inetpub\wwwroot\virt.parker\index.cfm:11) java.lang.ArrayIndexOutOfBoundsException: 11 at coldfusion.sql.TwoFishCryptor.toByte(TwoFishCryptor.java:162) at coldfusion.sql.TwoFishCryptor.decrypt(TwoFishCryptor.java:65) at coldfusion.sql.Executive.mapModified(Executive.java:258) at coldfusion.server.ConfigMap.setChanged(ConfigMap.java:64) at coldfusion.server.ConfigMap.put(ConfigMap.java:238) at coldfusion.runtime.Struct.StructInsert(Struct.java:409) at coldfusion.runtime.CFPage.StructInsert(CFPage.java:4091) at cfsetdsn2ecfm2110276039._factor4(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:332) at cfsetdsn2ecfm2110276039._factor5(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:3) at cfsetdsn2ecfm2110276039.runPage(E:\Inetpub\wwwroot\CFIDE\administrator\compo nents\_datasource\setdsn.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfdatasource2ecfc1645517805$funcSETORACLE.runFunction(E:\Inetpub\wwwroot\CFI DE\administrator\components\datasource.cfc:540) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java: 250) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:331) at cfsetMyDatasource2ecfm1566537573.runPage(E:\Inetpub\wwwroot\virt.parker\dsp\ setMyDatasource.cfm:18) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfindex2ecfm919545483.runPage(E:\Inetpub\wwwroot\virt.parker\index.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4