SQLNumParams support about clickhouse-odbc HOT 14 CLOSED

Implemented in master.

from clickhouse-odbc.

@filimonov , @traceon , @Enmk , thank you for the efforts, guys, but the issue is still there. The logs for select 1 query:
SQL.LOG

from clickhouse-odbc.

It is basically about the Clickhouse ODBC driver not supporting parameters properly, and thus being non-compliant with the ODBC core level interface.

from clickhouse-odbc.

It is probably closely related to #27

from clickhouse-odbc.

@nvm1 could you please check if issue is resolved now?

from clickhouse-odbc.

@Enmk , i'd love to, but I'm afraid I don't uderstand how to setup the version from master on windows without msi :(

from clickhouse-odbc.

We are preparing the next release, it will be made available soon, msi's will be published too.

from clickhouse-odbc.

@traceon, super, looking forward to the release! I will test it asap and get back with the results ;)

from clickhouse-odbc.

@nvm1 please try https://github.com/ClickHouse/clickhouse-odbc/releases/tag/v1.1.0.20191028

from clickhouse-odbc.

Oh, ok, I see where the problem is. The function is not exported.

from clickhouse-odbc.

Please give this a try: https://github.com/ClickHouse/clickhouse-odbc/releases/tag/v1.1.1.20191108

from clickhouse-odbc.

@traceon, it is alive! I managed to connect and obtain some data. Thank you! The only problem that I currently see, is that turbodbc is surprisingly 30-40% slower than pyodbc, while in other cases like postgresql or mysql it's like 50-200% faster. I guess the problem is somewhere in the communication between clickhouse-odbc and turbodbc. I'm not sure if you guys want and look into that, but if you will, probably @MathMagique could help to diagnoze the problem. From my side I'd happy to actively participate in tests :)

from clickhouse-odbc.

@nvm1 Glad it improved things for you!

Regarding the performance issue, it would really help if you provide some self-contained reproducible cases, with both pyodbc and turbodbc, that could be used as reference for the problem and, hopefully, the improvement. Maybe in a separate issue?

from clickhouse-odbc.

Closing this as SQLNumParams is now supported.

@nvm1 @MathMagique please open issue with samples showing performance difference. We definitely will look on that and will try to improve driver if possible.

from clickhouse-odbc.