I am developing an application which comprises of many VB6 forms with many ADO objects/controls.
My current development server is SQLDEV. The connecting strings and recordsources for the ADO controls refer to SQLDEV. Each time I want to test the application on the production server, SQLPROD, I have to manually locate all the ADO controls on each form and reset the connecting strings and recordsources to point to SQLPROD and change them back to SQLDEV if there is an error or the application did not meet specs.
Is there an easier way of avoiding this tedious way of assigning servers to apps and controls?
Will an INI file do, if yes how?
