I just installed MSSQL 2017 for linux and Visual Studio code for linux on my Ubuntu 18.10 machine. Both the installation succeeded, but I cannot connect from visual studio to the DB.
I have the following running drivers:
$ odbcinst -j
unixODBC 2.3.7 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /home/neo4j/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8
but, when I try to install
$ sudo apt-get install mssql-tools unixodbc-dev
I receive the following error:
Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mssql-tools : Depends: msodbcsql17 (>= 220.127.116.11) but it is not going to be installed Depends: msodbcsql17 (< 18.104.22.168) but it is not going to be installed unixodbc-dev : Depends: unixodbc (= 2.3.7) E: Unable to correct problems, you have held broken packages.
after a lot of googling, i found a lot of suggestions, but they doesn't run, like try to remove msodbcsql and unixodbc
$ sudo apt-get remove msodbcsql
Reading package lists... Done Building dependency tree Reading state information... Done Package 'msodbcsql' is not installed, so not removed 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
At this point I'm locked and not able to go ahead.
Has anyone some running solution?