Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File creation with a stored procedure

Status
Not open for further replies.

crabgrass

Technical User
Aug 29, 2007
111
US
I have a stored procedure like so in a VFP database.

Code:
function createexcel
filespec = (justpath(dbf())+ "../output/sampleout") 
select * from sites into table (filespec)
use (filespec)
filespec = (justpath(dbf())+ "../output/sampleout2") 
copy to (filespec) type xl5
return filespec
endfunc
When run from VFP the code will work fine and both files will be created. However when run from an ASP page the code fails with an error that says "feature not available". If I remove the "copy to " line it will work OK from ASP so I know the file permissions are OK. Any ideas what's happening here? btw- CREATE TABLE also works but my need is for the excel file.


 
You might try temporarily setting this ASP to run as local administrator, just to be sure on the permissions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top