ODBC to named file does not work

[ErikJansenIRefact]

What happens?

I try to connect to existing duckdb database with ODBC on a Mac. The connect succeeds but it seems the connection is made to an empty in memory database. No tables are available although they are in the database.

To Reproduce

Install ODBC as documented. Create a database test.db in home folder and create a table with name test (by means of duckdb without odbc). Insert a record into the table:

duckdb test.db

create table test (id integer);
insert into test values (1);

Create an entry in ~/.odbc.ini:

[duckdb-test]
Driver = DuckDB Driver
Database=/Users/erik/test.db
allow_unsigned_extensions=true

Connect with isql:

isql duckdb-test

select * from test;

Returns error.

OS:

macOS Sonoma

DuckDB Version:

10.0.0

DuckDB Client:

odbc

Full Name:

Erik Jansen

Affiliation:

I-Refact BV

Have you tried this on the latest nightly build?

I have tested with a release build (and could not test with a nightly build)

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• [X] Yes, I have

[ErikJansenIRefact]

Any progress on this issue? Tested with release 10.3 (also installed latest driver). Problem is still there.