search

ClickHouse / clickhouse-odbc

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

Could not find ODBCINSTGetProperties() from #396

Closed belonesox closed 1 year ago

belonesox commented 2 years ago

I has compile driver from commit 860b06f934d850e9db711f4922600c41d2a9498c

/etc/odbcinst.ini

[ClickhouseU]
Description     = ODBC for ClickhouseU
Driver          = /usr/local/lib64/libclickhouseodbcw.so
Setup       = /usr/local/lib64/libclickhouseodbcw.so
UsageCount  = 1

I was using unixODBC project to test ODBC connection to CH. ( «unixODBC-gui-qt» fedora package, «ODBCCreateDataSourceQ5» application).

I got

«Could not find ODBCINSTGetProperties()»

«Could not construct a property list for (ClickhouseU). Contact your; SysAdmin, driver vendor, or folks at the unixODBC project for support.»

image

I am doing something wrong? Should it work?

Enmk commented 1 year ago

This looks like some extension method required by that particular tool only. As of now, clickhouse-odbc doesn't export that method (ODBCINSTGetProperties); hence, this GUI-tool is not supported. However, you can take a look at how to properly set up all configuration files in CI/CD workflows: https://github.com/ClickHouse/clickhouse-odbc/blob/a623c895eb9754f7231d91bc8b09d31fae9e8cee/.github/workflows/Linux.yml#L156-L210

Alternatively, you can submit a PR that implements that particular method.