Skip to content
Advertisement

Connection to SQL Server from Julia on Ubuntu Linux using ODBC.jl won’t connect

I have tried every permutation I can find on the web but still no luck. I know the connection is possible because it works easily from R, dbeaver, and command line sqlcmd, but I can not get it to work from Julia using ODBC.jl

JavaScript

However in Julia 1.7.0 I just get this error:

JavaScript

I think it might have something to do with the odbcinst.ini setup but don’t know how to debug/fix it. Any suggestions most welcome. Thx. J

Advertisement

Answer

I finally got a working solution to this problem but it was quite difficult, primarily due to a lack of documentation for most of this. I’m not convinced that the ODBC drivers are set up correctly but it works! Thx for all suggestions.

JavaScript
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement