Re: Getting DB2 Connectivity

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Thu, 2 Mar 2006 12:54:52 -0700
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Harold Lee wrote:
> (defparameter *odbc-library-filenames*
> -  '("odbc32" "libodbc" "libiodbc"))
> +  '("odbc32" "libodbc" "libiodbc" "libdb2"))

So the db2 library comes with an ODBC interface built-in and does not
require odbc32 or libodbc? Does the connection method differ if you
have an odbc library (say, libodbc) as well as libdb2 installed on
one's system?

> Also, DB2 does not need a user/password to connect in some cases (for  
> example, when your Lisp is running on the DB2 server under a userid  
> allowed to connect to DB2). This seems really useful to me because  
> you don't need to keep a copy of your password in your Lisp  
> application for connecting to DB2. To do this, I made these changes  
> to the connection spec code:

Those are reasonable changes. I'll add them to the next release.

Kevin