ODBCSQL Error Occurs after Installing Siebel Gateway (Doc ID 2279827.1)

Last updated on JUNE 02, 2023

Applies to:

Symptoms

ODBC error occurs while installing IP16

ODBCSQL is not getting connected and failing with below error.

[siebel@ze51-v-oradb bin]$ odbcsql /u XXXXX /p XXXX /s ZENBI_SIEBEL
ODBCSQL - ODBC SQL Interface program
Copyright (c) 1994,2015, Oracle. All rights reserved.

The Programs (which include both the software and documentation) contain
proprietary information; they are provided under a license agreement containing
restrictions on use and disclosure and are also protected by copyright, patent,
and other intellectual and industrial property laws. Reverse engineering,
disassembly, or decompilation of the Programs, except to the extent required to
obtain interoperability with other independently created software or as specified
by law, is prohibited.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of
Oracle Corporation and/or its affiliates. Other names may be trademarks
of their respective owners.

If you have received this software in error, please notify Oracle Corporation
immediately at 1.800.ORACLE1.

Type help for usage information.

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

ERROR
-----------------------
ODBC error 00000 in SQLConnect




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install Siebel Server and gateway.
2. Configure gateway.
3. Run dbuser.sql file and try to connect odbcsql by sourcing dbenv.sh file throughs below error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot to ODBCSQL.

Changes

New Installation. 

Cause

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