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@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
