ODBC.drivers() does not list/find drivers

JuliaDatabases / ODBC.jl

An ODBC interface for the Julia programming language

https://odbc.juliadatabases.org/stable

Other

106 stars 63 forks source link

ODBC.drivers() does not list/find drivers #233

Closed kskoeld closed 4 years ago

kskoeld commented 5 years ago

Using version 0.8.2 with Julia 1.1.0 ODBC.drivers() only returns 0×2 Array{String,2} Using unixODBC 2.3.4 and testing driver and DSN with isql works fine. ODBCINIand ODBCINSTINI are set correctly in environment. How can I specify the driver? ODBC.ODBCDriverConnect! looks like it could be a good candidate, but its not documented (see #232)

laashe commented 5 years ago

I'm experiencing the same issue, feedback here would be wonderful!

@kskoeld Have you gotten any further in connecting with ODBC?

quinnj commented 4 years ago

This should be fixed on master; we now ship and configure our own driver managers (iODBC/unixODBC) that should use a consistent odbcinst.ini file (on non-windows of course). Note, however, that after doing ODBC.adddriver or ODBC.removedriver, you often need to restart your julia session to see the changes reflected in ODBC.drivers() since the driver manager will often cache the file per session.