I am assuming that you have opened explorer and tried this \\10.1.0.192\foldername\126894.pdf'
And does it work? On 6/12/07, Selvakumar Selvaraj <[EMAIL PROTECTED]> wrote: > > Hi All, > > I have a problen in my SQL script, > > declare @Path varchar(128) , > @FileName varchar(128) > select @Path = '\\10.1.0.192\' , > @FileName = 'foldername\126894.pdf' > > declare @i int > declare @File varchar(1000) > > select @File = @Path + @FileName > print @File > exec master..xp_fileexist @File, @i out > if @i = 1 > print 'exists' > else > print 'not exists' > > but it says "not exists". > > The file exists in different server. I have given full rights for this > folder. But still getting the same. Please help to resolve this. > > Thanks in advance, > Selva > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2856 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
