JuliaDatabases / ODBC.jl

An ODBC interface for the Julia programming language
https://odbc.juliadatabases.org/stable
Other
106 stars 63 forks source link

How to use the default drivers from `unixODBC_jll` #368

Open schlichtanders opened 1 year ago

schlichtanders commented 1 year ago

I would like to use ODBC.jl to connect to a PostgreSQL and first thought it is just not easily possible. Then I read that ODBC.jl actually wraps their own drivers in artifacts like unixODBC_jll.

Unfortunately I am still completely lost given the documentation. The adddsn requires a driver name, but ODBC.drivers() returns an empty Dict by default, and adddriver requires a path to somewhere on the filesystem, but I just want to use the default drivers.

I really hope that only the documentation or my understanding of it is incomplete and that one can really use the drivers in the artifact unixODBC_jll

any help is highly appreciated