[unixODBC-support] Cannot connect to SolidDB data source (SQLConnect fails, but isql works!!)

[Simo Neuvonen]

On Tue, 26 May 2009, Ken Resander wrote:
> I had the same problem for DB2 Express on Ubuntu 8.10 some weeks ago when I tried to connect to the 
> sample database SAMPLE.
> The solution was to set the DSN to the name of the database, i.e. SAMPLE. 
> It did not work when I set DSN to myDSN etc. 
> 
> /etc/odbc.ini
> [SAMPLE]
> Driver= DB2
> Description = DB2 Database

> Hope it works, but let me know if you find a way to use an arbitrary dsn.

Use 'db2ca' GUI tool (Configuration Assistant) to create a Database<->Data 
Source mapping for your client. After that, you can use the same DSN in 
your odbc.ini.

-- 
Simo