>It turns out that we needed to set up TCP/IP access instead of named pipes. Oh, and the ISP had given our client the wrong password. It only took sitting on the ISP's phone hold for one hour to get us the right password.

This is interesting stuff! You have a clent, connecting through an ISP, to SQL Server and the connection is made through the client's ODBC (including address, userid and password?

And then, to get it going from inside a VFP app (guessing), you are SQLCONNECTing, to the client's ODBC, which in turn logs the client, through the ISP to the server?

ARe you passing SQL and data from client to server (and back) using ADO, or client side SQL, or calls to stored procedures? How is the client asking for data and/or updating the server?
Thanks
Terry