clickhouse-odbc icon indicating copy to clipboard operation
clickhouse-odbc copied to clipboard
verified publisher icon ClickHouse

Cognos -> ClickHouse connection

Open msestak opened this issue 4 years ago • 2 comments

We are trying to connect Cognos with ClickHouse (21.3.16.5). We installed latest driver for MS Windows 64 bit (1.1.10.20210822) on a 64 bit Windows machine running 64 bit Cognos. We are getting this error when trying connection:

cognos_clickhouse_error

Anybody tried to connect Cognos with ClickHouse to help us with this error? It complains about architectures but we installed all 64 bit.

msestak avatar Nov 03 '21 13:11 msestak

Well, there is arch mismatch obviously. Try installing 32-bit driver instead.

traceon avatar Nov 03 '21 13:11 traceon

We tried with 32 bit driver. Error is now different: cognos_click_error2

Connection: https://bdcognos:[email protected]:8443/query?database=bddwh&max_result_bytes=4000000&buffer_size=3000000

cognos_click_connection2

User and pass is correct, database exists, telnet works towards port 8443 from cognos machine. Anything else we can check?

msestak avatar Nov 04 '21 10:11 msestak