Modifying ADO Connection string @ runtime

[rizvir]

Hello,
This might sound very basic but I don't seem to find my way around to modify the ADO connection string at runtime.

The development folder structure is different to the production folder structure. How can I go about modifying ADO connection string at runtime e.g. to point to d:\myapps\delphiapp\data folder instead of c:\develop\data folder.
I am using BDS-2006 and my connection object is in a data module.

Thanks.
Rizwan.

 

[buho]

Assign the ConnectionString property before opening the connection/dataset.

Example:

MyConnection.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;' +
                                 'Data Source=' + [b]MyPath[/b] + ';' +
                                 'Persist Security Info=True;';
MyConnection.LoginPrompt :=False;
MyConnection.Connected := True;

buho (A).