topic Re: Executing a Stored Process from Excel in Developers

Executing a Stored Process from Excel

KarenCEI — Wed, 26 Jul 2006 17:50:08 GMT

We have a user who created a simple Stored Process. He can execute it from Excel, but I cannot. I see the following. Does anyone know what thie means? Thanks!

"Unable to execute the stored process "ASUV_SP". Please report this error to your site administrator."

System.Runtime.InteropServices.COMException (0x80041001): Transaction open failed.Physical file does not exist, C:\Documents and Settings\dbisbik\My Documents\My SAS Files\9.1.
at SASStoredProcessService.ExecutionClass.WaitForCompletion(Int32 waitMilliSeconds)
at SAS.OfficeAddin.StoredProcess._ExecuteInternal(String& errorMessage)

Re: Executing a Stored Process from Excel

Vince_SAS — Thu, 27 Jul 2006 15:30:19 GMT

Karen-

Could you please repost this question in the "Integration with Microsoft® Office" forum? Someone there will be better suited to answering your question. The link is:

http://support.sas.com/forums/forum.jspa?forumID=7&start=0

Another, perhaps better option, is to open a track with our Technical Support department:

http://support.sas.com/techsup/contact/submit_emits2.html

One quick thought that I have is perhaps you do not have operating system permission to access the directory "C:\Documents and Settings\dbisbik\My Documents\My SAS Files\9.1".

Best regards,

Vince DelGobbo
SAS R&D