Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Production or NOT production
Message
From
12/02/2004 16:05:07
 
 
To
12/02/2004 16:01:21
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00876843
Message ID:
00876849
Views:
10
>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).


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform