Hi,

       This is my first mail within Derby Community. And need some help.

       Trying to,
               Use Derby 10.5.3. tru 
               ODBC access (unixODBC is the driver manager)
       Using
               IBM CLIdriver

       When I invoked the tool to test the connectivity,
           isql -v TEST,

       It is throwing below error,
           [08001][unixODBC][IBM][CLI Driver] SQL1013N  The database alias name or database name "TEST" could not be found.  SQLSTATE=42705
 
       Can anyone please suggest possible workarounds or insights into this problem.

       .odbc.ini file,
[TEST]
Driver          = /opt/driver/db2/lib/libdb2.so
Server=localhost:1527
Database=test
dbalias=test
DBNAME=test
Database Name=test
Protocol                = tcpip
Hostname                = localhost
SERVER          = 127.0.0.1
PORT            = 1527
SysSchema               = firstdb
SchemaList              = "'firstdb'"
UsageCount              = 5
CurrentSchema=firstdb


Thanks,
Satish.