This project has moved and is read-only. For the latest updates, please go here.

Cannot create ODBC DSN-less connection


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



msorens wrote Sep 19, 2012 at 1:07 AM

I agree completely. I have thought of doing that but it was way down on my "to do" list. Now that I know someone else is interested I will try to get to it sooner, but I cannot promise a date at this point :-(.