topic Re: DuckDB odbc issue in Discussions

DuckDB odbc issue

guillaumebugnon — Fri, 09 May 2025 09:58:41 GMT

Hello,

I have some issue when I try to connect JMP 17 / 18 and 19EA8 using the DuckDB Windows ODBC.

Does jmp support DuckDB connectivity?

Has anyone tried it?

Thank you

Reference: https://duckdb.org/docs/stable/clients/odbc/windows

Re: DuckDB odbc issue

Ressel — Fri, 09 May 2025 10:03:36 GMT

I haven't tried DuckDB Windows ODBC but have had an issue connecting JMP 18 to Google BigQuery:

What helped was going to a lower version nr. of the same driver. (The issue referenced above is not yet updated, seeing how JPM Tech Support wanted to this themselves.)

Re: DuckDB odbc issue

jthi — Fri, 09 May 2025 10:47:25 GMT

At least DuckDB isn't mentioned here Data Connectors | JMP.

You could use Python in between with JMP18 (query data with integrated Python and convert the dataframe to JMP table). I think in JMP19 you could build your own data connector using JMP's Python integration

Edit: But it might be that the ODBC "should just work". @bryan_boone

Re: DuckDB odbc issue

guillaumebugnon — Fri, 09 May 2025 12:03:43 GMT

Hi,

Yes, that's the solution I'll probably consider now.

Re: DuckDB odbc issue

briancorcoran — Fri, 09 May 2025 13:00:46 GMT

Hello Guillaume,

Does the DuckDB connect through the ODBC Manager driver connection test? Windows and Mac offer varying ways to test the DSN that you create. The other thing to make sure of is that you installed the 64-bit, and not the 32-bit version.

If you write JMP Tech Support I think they'll at least try some common troubleshooting for this driver, even though it is not something we typically support.

Brian Corcoran

JMP Development

Re: DuckDB odbc issue

guillaumebugnon — Fri, 09 May 2025 13:16:46 GMT

Hello Brian,

I am using the 64bits version yes.
I will contact the support.

Thanks

Re: DuckDB odbc issue

guillaumebugnon — Tue, 13 May 2025 09:26:09 GMT

Hello,

With the latest duckdb odbc driver release (v1.2.2), it works with jmp 17 (still have issue with jmp 18).

https://github.com/duckdb/duckdb-odbc/pull/46

Thanks