odbcsql connect to DB2 database fails witj SQL1032N-ARCHIVE
(Doc ID 488459.1)
Last updated on JANUARY 25, 2020
Applies to:Siebel System Software - Version 22.214.171.124 SIA  and later
IBM AIX on POWER Systems (64-bit)
Version: 126.96.36.199  NLD Fin Svcs
Database: DB2/UDB 7.2
Application Server OS: IBM AIX 5L
Database Server OS: IBM AIX 5L
This document was previously published as Siebel SR 38-969073651.
Using odbcsql to test the ODBC connection to a DB2 V7.2 database returns with ODBC error 08001 and DB2 error SQL1032N.
Specifying db2_36.o library has also been tried, but gave the same result.
odbcsql command used to test:
odbcsl /u sadmin /p xxxxx /s siebsrvr_siebel
odbcsql /u sadmin /p xxxx /s siebel
DB2 cli tracing has been switched on, but the command probably fails before cli is executed. Direct cli connect by sadmin user is possible (i.e bypassing ODBC).
Lots of siebel_assert files found indicating an error at line 149 in ssstring.cpp
Siebel version is 7.5.2 base. DB2 is V7.2 + FP7s
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