>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 had thought of just using a local DBF file to store the values. > >I was going to define a different DSN for the Production version and use a different DSN for the development version. > >However the DSN is in the DBC and NOT a variable. > >The SQL servers are exactly the same, just a different IP.
Make it DSNLess, using SQLSTRINGCONNECT() and change the IP depending on Version(2).
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry