The Status Quo:
There's a SQL Server (2005) database. On the same network, There's a user who connects a Visual FoxPro instance to said database via ODBC. This works, the user is happy, and everything is hunky dory.
Looming on the horizon:
The SS database is going to move to another network. There will be a firewall between it & the VFP user. This user does have access through the firewall via VPN, and a SQL account in the relocated database (no domain account on the new network).
The Question:
Will we be able to construct an ODBC connection string such that the VFP user can still use the SS back end? Anything special we need to do when setting it up? Anything special the user needs to do to connect?
If this belongs on SO rather than SF, let me know & I'll take it over there....