[gdal-dev] ADBC driver and DuckDB on Windows

[Even Rouault]

Seth,

there has been an enhancement in *master* (not in 3.11) for being able 
to load libduckdb when the ADBC driver is built without 
libadbc-driver-manager support. So if you're not on master, this is 
expected

Even

Le 12/07/2025 à 12:45, Seth G via gdal-dev a écrit :
> Hi all,
>
> I'm wondering if anyone has got this working on Windows?
>
> With a test.db the following works fine on a full Linux GDAL Docker image:
>
> docker run -it --name gdal-ubuntu -v D:/Data/GDAL:/data ghcr.io/osgeo/gdal:ubuntu-full-3.11.0 /bin/bash
> ogr2ogr out.gpkg test.db
>
> >From the docs https://gdal.org/en/latest/drivers/vector/adbc.html
>
> "Assuming libduckdb.so, libduckdb.dylib or duckdb.dll is available (and it is in a system location, or can be located through LD_LIBRARY_PATH on Linux, DYLD_LIBRARY_PATH on MacOSX or PATH on Windows)."
>
> I'm trying to get this working using GDAL via Conda on Windows. The ADBC driver is isntalled:
>
> gdal vector --formats
> # includes ADBC -vector- (ro): Arrow Database Connectivity
>
> I tried downloaded the duckdb.dll from https://duckdb.org/docs/installation/?version=stable&environment=cplusplus&platform=win&download_method=direct&architecture=x86_64 (https://github.com/duckdb/duckdb/releases/download/v1.3.2/libduckdb-windows-amd64.zip) and setting the path:
>
> $env:Path = "D:\Tools\libduckdb-windows-amd64;" + $env:Path
> ogr2ogr out.gpkg test.db
>
> Each time, the following error is returned:
>
> ERROR 1: Unable to open datasource `test.db' with the following drivers.
>
> With a longer command:
>
> ogr2ogr -f parquet overture-vt-addresses.parquet `
> 	-oo ADBC_DRIVER="D:/Tools/libduckdb-windows-amd64/duckdb.dll" `
> 	-oo PRELUDE_STATEMENTS="LOAD SPATIAL" `
> 	-oo PRELUDE_STATEMENTS="LOAD PARQUET" `
> 	-oo PRELUDE_STATEMENTS="load httpfs" `
> 	-oo PRELUDE_STATEMENTS="load aws" `
> 	-oo SQL="select * from read_parquet('s3://overturemaps-us-west-2/release/2025-05-21.0/theme=addresses/type=address/*')'"  ADBC:
>
> Results in:
>
> ERROR 1: AdbcLoadDriver() failed:
> ERROR 1: Unable to open datasource `ADBC:' with the following drivers.
>
> I tried various paths for ADBC_DRIVER:
>
> 	-oo ADBC_DRIVER="D:/Tools/libduckdb-windows-amd64"
> 	-oo ADBC_DRIVER="D:/Tools/libduckdb-windows-amd64/duckdb.dll"
> 	-oo ADBC_DRIVER="D:\Tools\libduckdb-windows-amd64\duckdb.dll"
>
> Just to note the following works in the Conda environment:
>
> python -c "import ctypes;ctypes.CDLL(r'D:\Tools\libduckdb-windows-amd64\duckdb.dll')"
>
> conda install duckdb doesn't help and `conda install conda-forge::libduckdb` isn't available on Windows.
>
> Thanks for any suggestions,
>
> Seth
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.