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 SEPTEMBER 04, 2023

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.