odbcsql failing with ODBC error 00000 in SQLConnect: Unknown ODBC error! (native error 0). (Doc ID 519083.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 7.7.1 [18306] to 8.1.1.4 [21225] [Release V7 to V8]
Siebel CRM - Version 7.7.2 SIA [18325] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.1 [18306]
Database: Oracle 9.2.0.2
Application Server OS: Sun Solaris 5.8
Database Server OS: Sun Solaris 5.8

This document was previously published as Siebel SR 38-1723275777.

***Checked for relevance on 12-May-2011***


Symptoms

Customer reported the following:

Whilst checking the installation of theSiebel Enterprise Server, we have attempted an ODBC connection, (odbcsql /u system /p password /s ADMD1), which fails with the following:

Logging into "ADMD1" as "system" ...
ODBC error 00000 in SQLConnect:
Unknown ODBC error!
(native error 0).
Unable to login using specified ODBC parameters.

We have checked through all environment variables and all other recommended settings,
Running truss against the odbcsql call showed a lot of merant odbc libraries not being found, and on checking the ${SIEBEL_ROOT}/lib/odbc/merant directory only contains 3 files:
base.txt
enu.txt
libodbc.so

Is this the correct amount?


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms