clickhouse-odbc Unable of SQL request to ClickHouse database throgh ClickhouseODBC_UNICODE Release 1.1.7.20200414 driver from Oracle 12.2 DG4ODBC gateway on SUSE Linux 12

It looks like ClickhouseODBC driver not recognize a DG4ODBC request of SQLBindCol.

Configuration description.

Clickhouse ODBC configuration /etc/unixODBC/odbc.ini

[ClickhouseODBC_UNICODE] Driver = /usr/lib64/libclickhouseodbcw.so Description=ClickHouse ODBC Driver (Unicode) DriverLog=yes DriverLogFile = /tmp/ck_detail_UNICODE.log DriverUnicodeType = 3 Host = bi-ch-db-01 Port = 8123 Database = chdb1 Username = chdbuser Password =

DG4ODBC configuration: $ORACLE_HOME/hs/admin/initchodbc.ora

HS init parameters

HS_FDS_CONNECT_INFO = ClickhouseODBC_UNICODE HS_FDS_TRACE_LEVEL = 255 HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so HS_NLS_NCHAR=UCS2 HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1 HS_FDS_SQLLEN_INTERPRETATION=64 set ODBCINI=/etc/unixODBC/odbc.ini

$TNS_ADMIN/listener.ora

SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=chodbc) (ORACLE_HOME=/opt/oracle/db12c) (ENV="LD_LIBRARY_PATH=/usr/lib64:/opt/oracle/12c/lib") (PROGRAM=dg4odbc) )

$TNS_ADMIN/tnsnames.ora

chdb1 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=dwh-db-01)(PORT=1521)) (CONNECT_DATA=(SID=chodbc)) (HS=OK) )

Create oracle database link: CREATE PUBLIC DATABASE LINK chdb1_link CONNECT TO chdbuser IDENTIFIED by USING 'chdb1';

Query to Clickhouse database from Oracle database

SQL> select ID from aaa1@chdb1_link; select ID from aaa1@chdb1_link * ERROR at line 1: ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dwh-db-01)(PORT=1521))(CONNECT_DAT A=(SID=chodbc))) ORA-02063: preceding line from CHDB1_LINK Process ID: 3839 Session ID: 50 Serial number: 37466

Trace files analyses.

unixODBC ClickhouseODBC_UNICODE trace

==================== ODBC Driver logging session started (2020-05-29 04:46:18 PDT) ==================== ClickHouse ODBC Driver VERSION=1.1.7.20200414 SYSTEM=Linux-3.10.0-1127.el7.x86_64 UnixODBC UNICODE ODBCVER=380 sizeof(void *)=8 sizeof(SQLTCHAR)=2 sizeof(wchar_t)=4 1590752779004303 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/connection.cpp:113 in connect: Creating session with http://bi-ch-db-01:8123 1590752779004504 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:1285 in SQLGetFunctions: SQLGetFunctions:1285 id=999 ptr=0x7ffe74f20a00 1590752779005088 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 6, out_value_max_length: 1026 1590752779005351 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 7, out_value_max_length: 1026 1590752779005548 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 17, out_value_max_length: 1026 1590752779005708 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 18, out_value_max_length: 1026 1590752779005947 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 10003, out_value_max_length: 1026 1590752779006163 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 34, out_value_max_length: 2 1590752779006181 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:380 in operator(): GetInfo SQL_MAX_CATALOG_NAME_LEN, type: SQLUSMALLINT, value: 0 = 0 1590752779006423 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/impl/impl.cpp:240 in operator(): GetConnectAttr: 109 1590752779008134 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 91, out_value_max_length: 4 1590752779008159 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:361 in operator(): GetInfo SQL_SCHEMA_USAGE, type: SQLUINTEGER, value: 0 = 0 1590752779008290 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 46, out_value_max_length: 2 1590752779008311 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:201 in operator(): GetInfo SQL_TXN_CAPABLE, type: SQLUSMALLINT, value: SQL_TC_NONE = 0 1590752779008481 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 72, out_value_max_length: 4 1590752779008505 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:321 in operator(): GetInfo SQL_TXN_ISOLATION_OPTION, type: SQLUINTEGER, value: SQL_TXN_SERIALIZABLE = 8 1590752779008642 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 32, out_value_max_length: 2 1590752779008678 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:380 in operator(): GetInfo SQL_MAX_SCHEMA_NAME_LEN, type: SQLUSMALLINT, value: 0 = 0 1590752779008808 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 35, out_value_max_length: 2 1590752779008823 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:380 in operator(): GetInfo SQL_MAX_TABLE_NAME_LEN, type: SQLUSMALLINT, value: 0 = 0 1590752779008937 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 33, out_value_max_length: 2 1590752779008951 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:380 in operator(): GetInfo SQL_MAX_PROCEDURE_NAME_LEN, type: SQLUSMALLINT, value: 0 = 0 1590752779009093 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:102 in SQLGetInfoW: GetInfo with info_type: 29, out_value_max_length: 1026 1590752779009339 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/odbc.cpp:38 in SQLAllocHandle: SQLAllocHandle handle_type=3 input_handle=0x170e640 1590752779009400 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/impl/impl.cpp:446 in operator(): GetStmtAttr: 10010 out_value=0x7ffe74f23f08 out_value_max_length=8 1590752779009472 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/impl/impl.cpp:446 in operator(): GetStmtAttr: 10011 out_value=0x7ffe74f23f08 out_value_max_length=8 1590752779009488 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/impl/impl.cpp:446 in operator(): GetStmtAttr: 10012 out_value=0x7ffe74f23f08 out_value_max_length=8 1590752779009498 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/api/impl/impl.cpp:446 in operator(): GetStmtAttr: 10013 out_value=0x7ffe74f23f08 out_value_max_length=8 1590752779009808 [3844:139926825764352] /home/denis/dev/altinity/clickhouse-odbc-canonical/driver/driver.h:238 in operator(): 07005 (Column info is not available)[rc: -1]

DG ODBC trace

Heterogeneous Agent Release 12.1.0.2.0

Oracle Corporation --- FRIDAY MAY 29 2020 04:46:18.831

Version 12.1.0.2.0

Entered hgogprd HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255" Entered hgosdip setting HS_OPEN_CURSORS to default of 50 setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER" setting HS_FDS_RECOVERY_PWD to default value setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG setting HS_IDLE_TIMEOUT to default of 0 setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED" HOSGIP returned value of "UCS2" for HS_NLS_NCHAR setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE" setting HS_FDS_DATE_MAPPING to default of "DATE" setting HS_RPC_FETCH_REBLOCKING to default of "ON" setting HS_FDS_FETCH_ROWS to default of "100" setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE" setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE" setting HS_FDS_PROC_IS_FUNC to default of "FALSE" setting HS_FDS_MAP_NCHAR to default of "TRUE" setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS" setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE" setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536" setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE" setting HS_FDS_QUERY_DRIVER to default of "TRUE" setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE" setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE" setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF" setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE" setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE" HOSGIP returned value of "64" for HS_FDS_SQLLEN_INTERPRETATION setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo;gtw$:OPTTables;gtw$:OPTColumns;gtw$:OPTPrimaryKeys;gtw$:OPTForeignKeys;gtw$:OPTProcedures;gtw$:OPTStatistics" setting HS_FDS_DELAYED_OPEN to default of "TRUE" setting HS_FDS_WORKAROUNDS to default of "0" setting HS_WORKAROUNDS to default of "0" Exiting hgosdip, rc=0 ORACLE_SID is "chodbc" Product-Info: Port Rls/Upd:2/0 PrdStat:0 Agent:Oracle Database Gateway for ODBC Facility:hsa Class:ODBC, ClassVsn:12.1.0.2.0_0023, Instance:chodbc Exiting hgogprd, rc=0 hostmstr: 0: HOA After hoagprd HOA 05/29 04:46:18.835137000: (hotker_ExecuteRpcs) ncrorpi: status = 0 HOA 05/29 04:46:18.851815000: (hotker_ExecuteRpcs) ncrorpi: status = 0 hostmstr: 0: HOA Before hoainit Entered hgoinit HOCXU_COMP_CSET=1 HOCXU_DRV_CSET=31 HOCXU_DRV_NCHAR=1000 HOCXU_DB_CSET=873 HS_LANGUAGE is AMERICAN_AMERICA.WE8ISO8859P1 LANG=en_US.UTF-8 HOCXU_SEM_VER=121000 HOCXU_VC2_MAX=4000 HOCXU_RAW_MAX=2000 Entered hgolofn at 2020/05/29-04:46:18 HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/lib64/libodbc.so" Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLAllocHandle symbol_peflctx=0x39d07520 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLBindCol symbol_peflctx=0x39d07650 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLBindParameter symbol_peflctx=0x39d07e90 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLCancel symbol_peflctx=0x39d091e0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLDescribeParam symbol_peflctx=0x39d11380 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLDisconnect symbol_peflctx=0x39d117e0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLEndTran symbol_peflctx=0x39d14200 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLExecute symbol_peflctx=0x39d158e0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLFetch symbol_peflctx=0x39d160b0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLFreeHandle symbol_peflctx=0x39d17b10 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLFreeStmt symbol_peflctx=0x39d17b20 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetData symbol_peflctx=0x39d19160 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetEnvAttr symbol_peflctx=0x39d1c660 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetFunctions symbol_peflctx=0x39d1c9f0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLMoreResults symbol_peflctx=0x39d1e420 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLNumResultCols symbol_peflctx=0x39d1eff0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLParamData symbol_peflctx=0x39d1f310 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLPutData symbol_peflctx=0x39d211a0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLRowCount symbol_peflctx=0x39d21640 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLSetEnvAttr symbol_peflctx=0x39d235c0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLSetDescRec symbol_peflctx=0x39d233a0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLColAttribute symbol_peflctx=0x39d09bd0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLColumns symbol_peflctx=0x39d0b2f0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLConnect symbol_peflctx=0x39d0eee0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLDescribeCol symbol_peflctx=0x39d10cc0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLDriverConnect symbol_peflctx=0x39d12400 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLExecDirect symbol_peflctx=0x39d15350 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLForeignKeys symbol_peflctx=0x39d16a00 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetConnectAttr symbol_peflctx=0x39d17ea0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetDescField symbol_peflctx=0x39d19830 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetDescRec symbol_peflctx=0x39d19d30 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagField symbol_peflctx=0x39d1b110 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetDiagRec symbol_peflctx=0x39d1bdc0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetInfo symbol_peflctx=0x39d1d380 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetStmtAttr symbol_peflctx=0x39d1d640 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLGetTypeInfo symbol_peflctx=0x39d1e060 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLPrepare symbol_peflctx=0x39d1faf0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLPrimaryKeys symbol_peflctx=0x39d1fff0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLProcedureColumns symbol_peflctx=0x39d205c0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLProcedures symbol_peflctx=0x39d20c10 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLSetConnectAttr symbol_peflctx=0x39d218f0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLSetStmtAttr symbol_peflctx=0x39d24910 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLSetDescField symbol_peflctx=0x39d23020 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLStatistics symbol_peflctx=0x39d26210 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Entered hgolofns at 2020/05/29-04:46:18 libname=/usr/lib64/libodbc.so, funcname=SQLTables symbol_peflctx=0x39d26eb0 hoaerr:0 Exiting hgolofns at 2020/05/29-04:46:18 Exiting hgolofn, rc=0 at 2020/05/29-04:46:18 HOSGIP for "HS_OPEN_CURSORS" returned "50" HOSGIP for "HS_FDS_FETCH_ROWS" returned "100" HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536" HOSGIP for "HS_NLS_NUMERIC_CHARACTERS" returned ".," HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF" HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE" HOSGIP for "HS_FDS_WORKAROUNDS" returned "0" HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE" HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE" treat_SQLLEN_as_compiled = 1 Exiting hgoinit, rc=0 at 2020/05/29-04:46:18 hostmstr: 0: HOA After hoainit hostmstr: 0: HOA Before hoalgon Entered hgolgon at 2020/05/29-04:46:18 reco:0, name:chdbuser, tflag:0 Entered hgosuec at 2020/05/29-04:46:18 Exiting hgosuec, rc=0 at 2020/05/29-04:46:18 HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER" HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG" HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE" HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE" HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE" HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE" HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE" HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE" HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE" using chdbuser as default schema HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE" Entered hgocont at 2020/05/29-04:46:18 HS_FDS_CONNECT_INFO = "ClickhouseODBC_UNICODE" RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING" Entered hgogenconstr at 2020/05/29-04:46:18 dsn:ClickhouseODBC_UNICODE, name:chdbuser optn: Entered hgocip at 2020/05/29-04:46:18 dsn:ClickhouseODBC_UNICODE Exiting hgocip, rc=0 at 2020/05/29-04:46:18 #>Connect Parameters (len=52)<# DSN=ClickhouseODBC_UNICODE; #! UID=chdbuser; #! PWD=* Exiting hgogenconstr, rc=0 at 2020/05/29-04:46:18 Entered hgolosf at 2020/05/29-04:46:18 ODBC Function-Available-Array 0xFBFE 0x00FF 0xBB00 0xF7F0 0x03CE 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0x0000 0xFE00 0x3F5F Exiting hgolosf, rc=0 at 2020/05/29-04:46:18 DriverName:CLICKHOUSEODBCW.DLL, DriverVer:1.1.7.20200414 DBMS Name:ClickHouse, DBMS Version:01.00.0000 Exiting hgocont, rc=0 at 2020/05/29-04:46:18 SQLGetInfo returns Y for SQL_CATALOG_NAME SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN Exiting hgolgon, rc=0 at 2020/05/29-04:46:18 hostmstr: 0: HOA After hoalgon RPC Calling nscontrol(0), rc=0 HOA 05/29 04:46:19.007684000: (hotker_ExecuteRpcs) ncrorpi: status = 0 hostmstr: 0: RPC Before Upload Caps hostmstr: 0: HOA Before hoaulcp Entered hgoulcp at 2020/05/29-04:46:19 Entered hgowlst at 2020/05/29-04:46:19 Exiting hgowlst, rc=0 at 2020/05/29-04:46:19 SQLGetInfo returns 0x0 for SQL_SCHEMA_USAGE TXN Capable:0, Isolation Option:0x8 SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN SQL_SU_DML_STATEMENTS bit is not set. Schemas are not supported by FDS. SQLGetInfo returns 0 for SQL_MAX_TABLE_NAME_LEN SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER SQLGetInfo returns ` (0x60) for SQL_IDENTIFIER_QUOTE_CHAR Entered hgopoer at 2020/05/29-04:46:19 hgopoer, line 240: got native error 1 and sqlstate 07005; message follows... Column info is not available {07005,NativeErr = 1} Exiting hgopoer, rc=0 at 2020/05/29-04:46:19 hgoulcp, line 1247: calling SQLBindCol got sqlstate 07005 Exiting hgoulcp, rc=28500 at 2020/05/29-04:46:19 with error ptr FILE:hgoulcp.c LINE:1247 ID:Bindcol: Type Name

May 29 '20 13:05 igorfedor

Proper implementation of #235 should resolve this too. Currently, the generated error is not possible to easily fix in driver's code.

May 29 '20 13:05 traceon

@traceon Thank you, Have you had a chance to fix this issue in the next release of ClickhouseODBC ?

May 30 '20 10:05 igorfedor

Could you please check with the recent version of the driver? https://github.com/ClickHouse/clickhouse-odbc/releases/tag/v1.1.8.20200710

Jul 10 '20 14:07 traceon

Denis, The new version of driver is working with Oracle HS ODBC as expected. I will continue testing and will inform you if I encounter an issue. Thank you. Best regards,

Igor.

On Fri, Jul 10, 2020 at 5:01 PM Denis Glazachev [email protected] wrote:

Could you please check with the recent version of the driver? https://github.com/ClickHouse/clickhouse-odbc/releases/tag/v1.1.8.20200710

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ClickHouse/clickhouse-odbc/issues/299#issuecomment-656692393, or unsubscribe https://github.com/notifications/unsubscribe-auth/APYOXLBZXQ45LPV4YXLH6XTR24NLLANCNFSM4NOA6DGQ .

-- Igor Fedorov | Senior DBA

31-33 Smolenskaya St., Bldg 5, Kyiv 03057, Ukraine Phone: +380.44.524.38.88 Mobile: +380.50.440.19.53 Email: [email protected] [email protected] Skype: i.fedorov Web: www.astoundcommerce.com http://www.astoundcommerce.com/

http://www.astoundcommerce.com/

CONFIDENTIALITY NOTE: This e-mail and any attachments are confidential. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please notify us immediately by returning it to the sender and delete this copy from your system. Thank you for your co-operation.

-- This e-mail, including any attachments, contains confidential information of Astound Commerce or its affiliates (collectively "Astound"), and/or its clients. It may be read, copied and used only by the intended recipient. Any use by a person other than its intended recipient, or by the recipient but for purposes other than the intended purpose, is strictly prohibited. If you received this e-mail in error, please contact the sender and then destroy this e-mail. Opinions, conclusions and other information in this message that do not relate to the official business of Astound shall be understood to be neither given nor endorsed by Astound.

Jul 13 '20 08:07 igorfedor

Hello. Which version is correct? I try Windows 10( x64) clickhouse-odbc-1.2.1 + Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 (x86) clickhouse inside VirtualBox Oracle on host machine.

SELECT * FROM table1@ch

ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PRM-WS)(PORT=1521))(CONNECT_DATA=(SID=ch))) ORA-02063: preceding line from CH Process ID: 23568 Session ID: 6 Serial number: 27

Dec 20 '23 11:12 AlexGruPerm