CH ODBC with MS Access

[MahmoudGoda0]

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

[traceon]

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

[MahmoudGoda0]

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:

Then in MS Access, I select New data source :

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:

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

Please let me know if you need other infos

[traceon]

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

[traceon]

The missing functions is SQLSpecialColumns.

[MahmoudGoda0]

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

[torydal]

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

[traceon]

@torydal no timeline yet...

[YasuhiroHarada]

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