I have a VB application. I have both a production and test database set up.
In a BASIC module, I have four constants that define the parameters for a database connection (DATASOURCE, INITIAL_CATALOG, UID, PWD)
I want the values of these to be set to different values if I am running within the VB IDE than when I compile the application. Is there some way I can accomplish this?