D
D. Shane Fowlkes
The title sounds odd but let me explain....I have a custom DLL created with
VB6 which is installed on the server and running just fine. One of the many
functions within the COM Obj is that it will write data from a recordset to
an Excel file and save the file as using a naming convention of username +
date. For example: johndoe_nov_04_03.xls. Now IF the file already exists,
the function deletes the old and saves this new one in it's place. The
Response from my function is simple....it either returns a the path of the
new file created which I'll use in a hyperlink OR the error message from the
server.
All of this seems to work fine on my local PC for testing. But when I run
this DLL on the server and call the function from a ASP script, I get a
"Permission Denied" error when my function tries to WRITE the file. It
seems to be deleting the existing files just fine...but when it gets to the
second half of the function, it just will not WRITE a new file. Any ideas?
I could post code but I really don't think it's a code issue. It seems to
be a permission issue and it works just fine in VB Studio.
On the server, I have given the Everyone, IUSR_xxxx, and IWAM_xxx users Full
control of the folder where the Excel files should be written to.
Still....no dice. Any ideas?
Thanks!
--
*********************************
D. Shane Fowlkes - TMM
Saving the world, one web site at a time.
*********************************
VB6 which is installed on the server and running just fine. One of the many
functions within the COM Obj is that it will write data from a recordset to
an Excel file and save the file as using a naming convention of username +
date. For example: johndoe_nov_04_03.xls. Now IF the file already exists,
the function deletes the old and saves this new one in it's place. The
Response from my function is simple....it either returns a the path of the
new file created which I'll use in a hyperlink OR the error message from the
server.
All of this seems to work fine on my local PC for testing. But when I run
this DLL on the server and call the function from a ASP script, I get a
"Permission Denied" error when my function tries to WRITE the file. It
seems to be deleting the existing files just fine...but when it gets to the
second half of the function, it just will not WRITE a new file. Any ideas?
I could post code but I really don't think it's a code issue. It seems to
be a permission issue and it works just fine in VB Studio.
On the server, I have given the Everyone, IUSR_xxxx, and IWAM_xxx users Full
control of the folder where the Excel files should be written to.
Still....no dice. Any ideas?
Thanks!
--
*********************************
D. Shane Fowlkes - TMM
Saving the world, one web site at a time.
*********************************