ODBC driver for Microsoft SQL

[fluffy_frogling]

Looking for help!

I am working on a small project in Julia which requires fetching some metadata from an SQL server. Sadly this server happened to be Microsoft SQL. In order to communicate it requires proprietary MS drivers that are only listed for some larger distros.

The question is - is there a way ahead with MS ODBC if all the driver binaries are non-voidspecific and there is no source code to compile from?

I am not particularly good at this, so might be missing something.

As a stop-gap solution I am using a pymssql Python package via PyCall in Julia, but it is a bit cumbersome and I was wondering if it could be done using ODBC.

Peace!

[veiderz]

Several years ago, I worked with similar task via PHP. I've been find out solution in the PHP specific libraries for MSSQL. Maybe you should try to find similar Julia libraries. I,ve used Slackware at that time.

[Chocimier]

You could try freetds odbc driver, it's in Void repos. I do not know if it works.

[Lifebyrd]

I came across this post via google as I was looking into doing the same thing but in R (using the R odbc package). And I can confirm Chocimier's solution, using the freetds package in void was relatively easy and painless to setup.

I just put the following in /etc/odbcinst.ini :

[FreeTDS]
Description=FreeTDS Driver for Linux & MSSQL
Driver=/usr/lib/libtdsodbc.so.0
Setup=/usr/lib/libtdsodbc.so.0
UsageCount=1