To connect to ODBC dbs, you have to specify a DSN in Windows ODBC driver manager.
It would be nice to support "on the fly", DSN-less ODBC connections, e.g. by letting the user fill out the entire connection string.
Alternatively, some examples from well-known providers could be included in the GUI; see e.g.
...hopefully including my favourite, Firebird (OdbcFb.dll); see documentation chm file in
example for a remote server with UTF8 character set, Firebird client fbclient.dll is in path:
Driver=Firebird/InterBase(r) driver;Dbname=someserver:C:\test dir\DEMO.FDB;CHARSET=UTF8;UID=SYSDBA;PWD=masterkey
example for an embedded database where we need to specify the Firebird embedded dll, no character set chosen:
Driver=Firebird/InterBase(r) driver;Dbname=C:\test dir\DEMO.FDB;Client=C:\Program Files\Firebird\Firebird_2_5\bin\fbembed.dll;UID=SYSDBA;PWD=masterkey