SAP Knowledge Base Article - Preview

2994356 - DBCO connection fails on Unrecognized encryption option 'skip_certificate_name_check' - SAP IQ NLS

Symptom

  • SAP IQ ODBC driver 16.0 is installed
  • A symbolic link libdbodbc17.so points to the real lib file libdbodbc16.so
  • SAP IQ server is started with encryption option -ec
  • When connecting through DBCO with client encrypted connection option SYBASE_SSL=1, this error can be seen in dev trace log:

B Connect to IQNLS as SAPSUER with SYBASE_CONN_TIMEOUT=10 SYBASE_CONTYPE=IQ SYBASE_IQ_CESU-8=1 SYBASE_SERVER=IQHOSTNAME SYBASE_DBNAME=DBNAME SYBASE_PORT=11111 SYBASE_IQ_ENGINE=IQNLS SYBASE_SSL=1 SYBASE_IQ_BUFFER_SIZE=500000 SYBASE_IQ_LOCKWAIT=600
C using ssl.
C using lock wait time 600 for Sybase IQ.
C load of IQ library libdbodbc17.so successful. ==> DBSL finds and loads libdbodbc17.so
C lib_dbsl 753 04/16/2020 12:36:00
C dbsybslib.dll patch info
C SAP patchlevel 0
C SAP patchno 700
C Last SYBASE DBSL patchlevel 0
C Last SYBASE DBSL patchno 700
C Last SYBASE DBSL patchcomment SAP Support Package Stack Kernel 7.53 Patch Level 700 (2957666)
C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6500]
C (-895) [08001] [Sybase][ODBC Driver][SQL Anywhere]Encryption error: Unrecognized encryption opt
C ion 'skip_certificate_name_check'
C Connection 0 failed using DRIVER={SQL Anywhere 12}; CommLinks=tcpip(HOST=IQHOSTNAME;ServerPort=11111);uid=SAPUSER;DatabaseName=DBNAME;ServerName=IQNLS;pwd=xxxxx;
   Encryption=tls(fips=NO;tls_type=rsa;trusted_certificate=/usr/sap/SID/SYS/global/certificate.crt;skip_certificate_name_check=yes);
C
B ***LOG BY2=> sql error -895 performing CON [dbds 989]
B ***LOG BY0=> [IQ Error SQL-895:08001][SQL Anywhere]Encryption error: Unrecognized encryption option 'skip_certificate_name_check' [dbds 989] 


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1 

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

libdbodbc17.so; libdbodbc16.so; skip_certificate_name_check; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.