I want an ADODC which has to connect to a different location(database,username and password).
Now when i specify the connection string at design time the databinding of the other controls seem to work fine. Now when i remove the connectionstring from the design time settings and then set the connection string of the ADODC control at run-time, the ADODC gives an error of 'Object Required' when any reference to the underlying recordset is made.
It will be great if someone has a solution for the same.
Many thanks in advance as it is a matter of urgency.