I thought that was all part of the MDAC. I have never had to verify that before. Wouldn't I get a different error if it wasn't? What should I ask for?
>Are you sure they have VFP ODBC driver on the server?
>
>>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!!