You have to use the username and password that the web service app is using and give them rights on the remote server.
>All,
>
>I have a web application that access VFP tables via a web service. If the tables are local, all is well, but the tables normally reside on a remote server and the OLEDB driver cannot access them. When I use this driver to create a connection in the VS Server Explorer, I have the ability to enter a user id and password, but the driver seems to ignore them.
>
>Am I missing something, or is there no way to access VFP tables from a remote server using VFPOLEDB?
>
>TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer