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.

[krdosier]

+1, I second the above comment. This feature will be a lifesaver for companies with legacy systems.

[YasuhiroHarada]

https://github.com/YasuhiroHarada/clickhouse-odbc/releases

With the help of LLM, I added the missing parts. It works with MS-ACCESS in my environment,
but it's hard to judge whether this is the right change.

I'm new to github so I don't know the correct way to do it.
I hope it will be helpful to those who are struggling with legacy systems.

[laeg]

@YasuhiroHarada the best thing to do is sync your fork to the repo and then raise a PR against this repo

this tutorial will explain how to do that. In the description, if you add the following: Closes: #275 it will link the PR to this issue.

[YasuhiroHarada]

@laeg
With the additional stability improvements,
I found that the result set needs garbage collection and that HTTPClientSession needs to support concurrent access.
Once I finish cleaning up the unnecessary code, I'll try creating a pull request.

[YasuhiroHarada]

I've created PR #516 to address the missing API support for MS-ACCESS.

There is still an issue with concurrent HTTP access when opening multiple tables in MS-ACCESS.
I'll address this in a separate PR later.