VB6 SQL ADODC CONNECTION STRING OFFLINE
Posted on 2014-03-31
I have inherited a VB6 app that uses and ADODC to serve a datagrid.
The default connection string is trying to connect to a database that doesn't exist, and the development machine has a different database (and credentials etc) to the production server. I can build/test the exe on the dev machine, but, because this connection is 'hardwired' into the design, the app crashes before it can load the production connection (from an ini file).
How does one configure the ADODC at design-time so that I can compile it with no connection, and so that it hopefully connects on site (as the form loads)