JuliaDatabases / ODBC.jl

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

ODBC.adddriver - Unable to find component name #325

Open johanneswaage opened 3 years ago

johanneswaage commented 3 years ago

Hi, I'm adding support for julia on our data science platform, which already supports R and Python and ODBC connections to a MS SQL Server, but I'm getting an "Unable to find component name on adddriver? Any suggestions for diagnostics is appreciated.

I'm running Julia from a Jupyter Notebook with the iJulia kernel on Redhat Linux 7.x

Thanks in advance JW

/etc/odbcinst.ini:

[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1
UsageCount=1

julia:

using Pkg; Pkg.add("ODBC")
Pkg.build("ODBC")
path = "/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.6.so.1.1"
isfile(path)
# true
ODBC.adddriver("ODBC Driver 17 for SQL Server", path; UsageCount=1)

Unable to find component name

Stacktrace: [1] adddriver(::String, ::String; kw::Base.Iterators.Pairs{Symbol,Int64,Tuple{Symbol},NamedTuple{(:UsageCount,),Tuple{Int64}}}) at /home/jwa/.julia/packages/ODBC/qhwMX/src/API.jl:561 [2] #adddriver#51 at /home/jwa/.julia/packages/ODBC/qhwMX/src/ODBC.jl:156 [inlined]

Status ~/.julia/environments/v1.5/Project.toml [a93c6f00] DataFrames v1.1.1 [c91e804a] Gadfly v1.3.3 [7073ff75] IJulia v1.23.2 [be6f12e9] ODBC v1.0.4 [91a5bcdd] Plots v1.14.0 [fd094767] Suppressor v0.2.0