>I am trying to use MDAC 2.1.2.... to access a SQL Server database through http from a client using VFP. I have installed the latest ADO/RDS version on both server and client. Everything goes well until it tries to actually get data, then I get 'client cannot connect to server' error.
>
>This works on Win98 client w/ Personal Web Server on same machine, but not w/ win95 talking to IIS 4.
>
>Any help?

I had a similar problem once that was caused by not having an a DSN on the IIS server that was the same as the DSN on my development machine.