Check the ColdFusion DSN definition (in the CF Admin) that you use to call the sp. Make sure that the user specified in the DSN definition has sufficient permissions to perform the DTS.
------------------------------- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -----Original Message----- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 10:37 AM To: CF-Talk Subject: Re: Help SQL Sever CFSTOREDPROC Issue. 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
