search

ClickHouse / clickhouse-odbc

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

CH ODBC with MS Access #275

Open MahmoudGoda0 opened 4 years ago

MahmoudGoda0 commented 4 years ago

Does CH ODBC working fine with MS Access ? Its not working with me. Error message says "driver does not support this function (#0)"

traceon commented 4 years ago

Could you please provide exact steps to reproduce? That will help a lot.

MahmoudGoda0 commented 4 years ago

Okay I have a CH DB in a server. and I need to access this DB from MS Access (from Windows OS). I installed CH ODBC driver from this link https://github.com/ClickHouse/clickhouse-odbc/releases (clickhouse-odbc-1.1.4-win32.msi), 32 because the MS Access is 32 bit. Then I created new connection like this: 1

Then in MS Access, I select New data source : 2

Then select "From other sources", then select "ODBC Database" A pop-up window will open, select the second option "Link to the data ....." A pop-up window will open, select the second tab "machine data source", then you will find the already created connection with its name, select it and press OK, then you will see a new window with all tables you have in the CH DB like this: 3

If I select any table then press OK, this error appear: 4

Please let me know if you need other infos

traceon commented 4 years ago

Thanks @MahmoudGoda0, I reproduced it. We will triage this report and will fix it.

traceon commented 4 years ago

The missing functions is SQLSpecialColumns.

MahmoudGoda0 commented 4 years ago

Thanks, Do you know expected date when this fix will be available ?

torydal commented 3 years ago

@traceon Добрый день! Ожидается ли фикс в ближайшее время?

traceon commented 3 years ago

@torydal no timeline yet...

YasuhiroHarada commented 2 months ago

+1, This feature will be a lifesaver for companies with legacy systems.