June 24, 2008 at 8:19 am
Hi guys.
I have a what appears to be a rather stupid and straightr forward problem. When trying to send a response of some action from my server via email, I wish to attach a file to the email(@attachments = 'c:\temp\test.txt',). When i send it without thos line the email works but with it I get this error:
Error: @attachments file "c:\TEMP\test.txt" does not exist
I have checked and the file does exist! Anyone have an idea
Cheers
June 24, 2008 at 8:57 am
did you check for any spaces in the path(file path). SQL Server doesnot Like that. use some like this if you have spaces in your file path. c:\"program Files\Microsoft SQL".
Maninder
www.dbanation.com
June 24, 2008 at 9:01 am
Also... remember that the path and file name have to exist on the SQL server... so if you're creating them on your local machine they aren't on the SQL server's path.
June 24, 2008 at 9:03 am
Yeah no spaces in the file. We thot about the file not being on the server but that doesn't seem to be the solution. It is a puzler
June 24, 2008 at 9:32 am
Also check that the service that is trying to send the file has access to both the folder and file.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply