ODBCSQL Error Occurs after Installing Siebel Gateway
Last updated on APRIL 30, 2018
Applies to:Siebel CRM - Version 16.0 [IP2016] and later
Information in this document applies to any platform.
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.
ODBC error 00000 in SQLConnect
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.
The issue has the following business impact:
Due to this issue, users cannot to ODBCSQL.
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