Our client has an ASP page that is used to run on an IIS server hosting an Access database and which extracts the data from the Access database and outputs it into an XML file which is also created on the IIS server.
They have also got a Unix server running ChilisoftASP and the database has been changed to a MySQL database (exact same data structure). They still want the data to be extracted into an XML file just the same as it was before, but are getting the following errror message:
Scripting.FileSystemObject.1 error '80070005'
You are not permitted to access a file which is not located within your ASP application's root.
/testaccount/shopping/[url removed, login to view], line 60
I have minimal experience with Unix/MySQL, and so was wondering if the error message has to do with permissions (i.e. where the XML file is trying to be created), or whether it is more likely to do with the connectivity to the MySQL database. It may well be that the issue can be addressed through the correct permissions being set but I do not know if this is the case.
I have attached the file we have been using (it is what worked successfully on the IIS/Access machine).
1) Complete and fully-functional working ASP page(s) installed and operational on the Unix server of our client
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).