2
Vote

Cannot create ODBC DSN-less connection

description

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.
http://www.carlprothman.net/Default.aspx?tabid=90
http://www.connectionstrings.com/

...hopefully including my favourite, Firebird (OdbcFb.dll); see documentation chm file in
http://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.1-Release/OdbcFb_DLL_2.0.1.152_Win32.zip/download

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


Thanks.

comments

msorens wrote Sep 19, 2012 at 12: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 :-(.