Changing Connection string at run-time

[Caro]

When I change the connection string at run-time (form initialize)- with datacontrol this doesn't seem to work - should I be using a DSN (ODBC) instead?
Thanks for the help with previous question, Serge