search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
245 stars 86 forks source link

Cognos -> ClickHouse connection #381

Closed msestak closed 1 year ago

msestak commented 2 years ago

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.

traceon commented 2 years ago

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

msestak commented 2 years ago

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

Connection: https://bdcognos:pass@10.0.0.8: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?