Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DNS-less VFP IWAM vs IUSR - MDAC 2.6 vs 2.8
Message
 
 
To
29/11/2005 22:27:56
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01073089
Message ID:
01073093
Views:
15
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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform