odbc driver oracle problem

From: Shih-Ping Liou <liou_at_scr.siemens.com>
Date: Thu, 17 May 2001 13:21:54 -0400
Message-ID: <cHTM6.5493$DW1.244206@iad-read.news.verio.net>

Could anyone help me with the following problem:

installation of merant odbc drivers for oracle 8.1.6 client on solaris 2.7:

The installation script (unixpi.ksh) works without any problems, but the test of the odbc installtion via

/opt/odbc/demo/demoodbc -uid <valid database user name> -pwd <password>
<odbc data source name>

fails with the following error:

/opt/odbc/demo/demoodbc MERANT, Inc. ODBC Sample Application.
/opt/odbc/demo/demoodbc: will connect to data source 'stestora.sbt' as user
'sandbox/sandbox'.
SQLConnect: Failed...
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [MERANT][ODBC lib] Data source name not found and no default driver specified

SQLConnect: Retrying Connect.
SQLConnect: Failed...
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [MERANT][ODBC lib] Data source name not found and no default driver specified

SQLConnect: Retrying Connect.
No connection could be established. Received on Thu May 17 2001 - 12:21:54 CDT