Thanks, for the reply. Unfortunately it didn't work. Regards, JB
admin wrote: >try running the cf service logged in as an admin account rather than local >system account >----- Original Message ----- >From: "James Blaha" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, April 02, 2003 9:53 AM >Subject: Help SQL Sever CFSTOREDPROC Issue. > > > > >>Hello All: >> >>I need some help please! >> >>Im using a couple of neat stored procedures to call a DTS package and >>write the output to a UNC path. My issue is that it only works when I >>output to my local SQL server hard drive or output to the UNC path by >>executing the DTS package from my SQL server Enterprise Manager. If I >>try to execute the CFSTOREDPROC from my CF server that goes to the UNC >>path a get an error from the SQL server. All permissions have been set >>to gives the 3 machines rights for read and write access. >> >>Any Ideas? >> >>Regards, >>James Blaha >> >> >> >>These are the stored procs. >>http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS >> >> >><CFSTOREDPROC PROCEDURE="spExecuteDTS" DATASOURCE="xx" debug="YES" >>returnCode = "Yes"> >><cfprocresult name="importData"> >> >><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname= "@Server" >>value= "mySqlServer" null="no"> >> >><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname= "@PkgName" >>value= "DTS_HR" null="NO"> >> >><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ServerPWD" >>value="xx" null="NO"> >> >><!--- Note: If you ran this with a local SA account you will need the >>line below. ---> >><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" >>dbvarname="@IntSecurity" value="1" null="NO"> >> >></CFSTOREDPROC> >> >> >> >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
