Hello,
My program is using TODBCConnection, TSQLTransaction, TSQLQuery, TDataSource and TDBGrid components on a form. It worked fine until I decided to allow the user to select a DSN to deal with (there are several available). Just changing TODBCConnection.DatabaseName doesn't work: subsequent SQL queries continue to work with the first DatabaseName assigned. I'm going to prepare a trivial example, but maybe the problem is already known: what are the necessary steps to switch to another Database during run-time?