Is the CF Services Logged in as a User that has rights to the share? I.E. In Windows NT/2K YOu can have the user login as a Local User who has access to the Drive Mapping
----- Original Message ----- From: "Carlisle, Eric" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 2:40 PM Subject: RE: executing dts package...part 2 > Any chance you can use a UNC path instead of drive mapping? > > > -----Original Message----- > From: Steven Dworman [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 28, 2002 9:42 AM > To: CF-Talk > Subject: executing dts package...part 2 > > > Well I have been able to fire off any dts package I want through my CF app. > However, when it has to open the excel file to import data into a temp table > the process fails. Reason being that it can't find the file. I have mapped > the location where SQL server reads the excel file properly on the CF > server. So both machines recognize the share as "drive-letter:\blah". I > believe the problem is SQL server thinks the "drive-letter:\blah" is on the > end-user machine sending the request. How do I get SQL server to understand > the share is not on the local machine and to use the mapping on the server? > > Thanks, > > Steven D Dworman > Macromedia Certified Developer > --------------------------------------------------------- > Web Consultant > Systems Administrator > > ComSpec International - http://www.comspecinternational.com > phone: 248.647.8841 > cell: 248.767.9925 > --------------------------------------------------------- > EMPOWER-XL ***Software for Higher Education*** > http://www.empower-xl.com > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists