db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satish Bvs <bvs.sat...@ymail.com>
Subject Derby: ODBC: Access Problem
Date Thu, 22 Apr 2010 16:31:43 GMT
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.


      
Mime
View raw message