2008.07.13  multiple open connections. also:  "DSN=host:port;UID=..;PWD=..;"
[we can use odbc.k to load other databases into kdb+.]

this file is about the kdb+ odbc driver. odbc is deprecated. 
if you can please use http://kx.com/q/c/readme.txt e.g.
from java use c.java
from .net use c.cs

we might still use odbc to get data into old excel/vb's.
1. install: http://kx.com/q/c/odbc/odbc.exe
2. connect: "DRIVER=kdb+;DBQ=host:port;UID=usr;PWD=pwd;"
3. if you make a fileDSN, PWD has to added manually. odbcad32 deletes it.

e.g. >q sp.q -p 5001

the default language for odbc is sql. to use q we execute("q)..");

from excel: (getexternaldata/newdatabasequery)
=SQL.REQUEST("DRIVER=kdb+;DBQ=localhost:5001;UID=usr;PWD=pwd;",,,"select*from t")

from vb: (add-ins/visual data manager/file/opendatabase/odbc)
r=new adodb.recordset
r.Open "select*from t","DRIVER=kdb+;DBQ=localhost:5001;UID=usr;PWD=pwd;"

or
connQ.Open"Provider=MSDASQL.1;DRIVER=kdb+;DBQ=localhost:5001;UID=usr;PWD=pwd;"