>I want to have my VFP application go to a different SQL server (for remote views) based on the data in a configuration file.

I do this in one of my VFE based apps. Like Alex suggests, I have a DSN-less connection. Then pass the statement handle obtained to the USE commend (as the CONNSTRING argument). Whatever connection that is defined in the DBC will be overridden at runtime. You can only pass a statement handle to CONNSTRING in VFP8 however.

Aren't you a VFE developer? If so, I can point you to a thread on the support conference where I posted my code which uses a global connection object based on this technique.

Del