Great! Many thanks for this one! Now I can access all databases without DSN definitions and in case of SQL Server db:s choose dynamically between Windows and SQL Server authentication.
I am grateful! Esa -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of bill lam Sent: Thursday, November 25, 2010 8:08 AM To: jprogramming Subject: [Jprogramming] odbc dsn-less connection The updated base library includes an enhancement in odbc to allow dsn-less connection in the format, ddcon 'Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Northwind.mdb;Uid=Admin;Pwd=pass;' original format of ddcon 'dsn=....' are still supported. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
