So, VFPOLeDB requires no management, just installation? My connection string which I creted via Vis Studio wizard is "Provider=VFPOLEDB.1;Data Source=\\lmca-server4\sdrive"
and it worked! I also had to tweak IIS DIRECTORY SECURITY and checked off both "anonymous access" and "integrated windows authentication" and in web.config I have "identity impersonate="true"/"
All this seems a recipe for confusion.



Why does VFPOLeDB need to be on my developement desktop and the server too?



>Tim,
>Use VFPOleDb. Either you use one or the other nothing to configure in ODBC administrator (at least I don't like to configure something there and prefer DNSless connection - if you'd configure something then that might be connection pooling only, even for that defaults are fine).
>Cetin
>
>>I am using .NET 2 but I guess my next question is in the ODBC administrator, must I configure the user DSN for database or free tables and the correct path?
>>
>>
>>>Install VFPOLEDB. ODBC works too but I had problems with .Net 1.1 and ODBC namespace (didn't dig much as OLEDB worked much better - fp ODBC doesn't support all the things that VFPOLEDB does).
>>>Cetin
>>>
>>>>Still a bit bedazzled with this. Should I be installing foxpro ODBC or OLEDB?
>>>>
>>>>