My Oracle Support Banner

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

Last updated on AUGUST 02, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.