James, Thanks for the reply. I do have the User Name and pass word in the CF admin. And that account has dbo rights to the database. I think my issue has to do with permission going to the UNC path. I still have a few more things to try out.
Regards, JB James Ang wrote: >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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
