In the past, I have written a couple applications in ASP for websites that use VFP FreeTables for it's file/database use (I hate using Access). Some work fine, some I have had problems with.
Here is my latest situation... I copied some code that worked on another client's server. I set it up on the latest host and I get an error. I believe the error involves the permission setting for the IWAM because in the past, on other hosting servers, that seems to correct the issue.
Here is the code snippet that usually works:
set DBdb=server.createobject("adodb.connection")
DBpath="sourceDB=" & server.mappath("../maint")
DBdb.Open "DRIVER={Microsoft Visual Foxpro Driver}; SourceType=DBF; " & DBpath & "; Exclusive=No"
set openSet=server.createobject("ADODB.RecordSet")
openSet.Open "select * from user", DBdb, adOpenDynamic, adLockPessimistic, adCmdText
When I run the code I get...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver does not support this function
It errors on the DBdb.Open line...
The tech support says they have the IUSR set for READ/WRITE on the maint folder. They won't change the IWAM.
My questions:
- What is the difference?
- Do I definately need the IWAM set for a DNS-less connection to work?
- They are also using MDAC 2.6... one server once said I needed 2.8, do I?
Any help, suggestions, would be greatly appreciated.
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!