All geek questions in one place

How to connect to Windows SQL Server from Ubuntu

For the past two days, I have been trying to connect to a remote Windows SQL server with no apparent success. I am trying to connect to python using the pyodbc package.

I tried to keep track of all the blog posts on this subject without much luck. I first followed which , which I think made a good effort, but ended up being too incoherent IMO.

I installed the unixODBC manager, as suggested in the blog post. I downloaded the available redhat packages from Windows and ran the installation scripts, but every time I try to connect to db, I get

 pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server Native Client 10.0' : file not found (0) (SQLDriverConnect)")

Is there a way to achieve this in a few hours without having to configure window installation scripts myself? Can someone provide an overview of the steps that need to be taken and the modules that need to be installed so that someone can connect to the Windows SQL server using a Linux machine?

I am currently using Ubuntu 15.04.

Update

I also tried the instructions given here . Looking at the details of SQL db on the azure platform, it is explicitly stated that the driver must be SQL Server Native Client 10.0. Should I consider it mandatory to use this driver, or can I use, for example, FreeTDS, as suggested in the second blog post?

+5
source share
1 answer

check the file system for a file named libsqlncli *. If you find it, check:

  • permissions
  • lines reporting "NOT FOUND" in the output of the ldd command executed against this file;

  • If everything is ok, check / ddd for the following entry in odncinst.ini:

    [SQL Server Native Client 1[0|1].0] Description=Microsoft SQL Server ODBC Driver V1.0 for Linux Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0 UsageCount=1

+3
source

Source: https://habr.com/ru/post/1240449/

More articles:


All Articles