My Oracle Support Banner

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 SIA [16061] and later
IBM AIX on POWER Systems (64-bit)
Version: [16061] 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.
.odbc.ini contains:
Specifying db2_36.o library has also been tried, but gave the same result.
db2cli.ini contains
odbcsql command used to test:
odbcsl /u sadmin /p xxxxx /s siebsrvr_siebel
Also tried:
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
 Message 1
 Message 2

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