Problem with Paradox db when web enabling an app
Posted on 2004-10-13
I am trying to web enable a database application based on a Paradox database.
When I try to return a query (basically using page producers) I get an error in my web browser saying file not found and it lists aload of temp files as follows
Internal Application Error
Invalid parameter. Permission denied. File: C:\WINNT\system32\_QSQ1.MB Table: C:\WINNT\system32\_QSQ1.MB File or directory does not exist. File: C:\WINNT\system32\_QSQ1.DB File: C:\WINNT\system32\_QSQ2.MB Table: C:\WINNT\system32\_QSQ2.MB File: C:\WINNT\system32\_QSQ2.DB
The reason it cannot find those files is that the internet user account does not have access to the system32 directory as that would just be stupid.
Why is paradox trying to make temp files in my system32 directory? I can't find any options to change this in the BDE
If I use a table it works fine, if I do a query then it says it can't find those files. Also if I use a database that doesnt have memo fields in it then it works fine.