Comments on: Working with MS SQL Server in Python on Linux

By: Salvatore

Salvatore — Wed, 30 Oct 2019 13:50:38 +0000

You need to install the MSSQL drivers on Linux first – that’s the driver that ODBC is looking for in the connect string.

DRIVER={{ODBC Driver 13 for SQL Server}}

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

By: mike

mike — Wed, 04 Sep 2019 08:01:06 +0000

In reply to Adrian Keister.

It depends on the problem…

By: Adrian Keister

Adrian Keister — Tue, 03 Sep 2019 21:06:57 +0000

Do you have any tips on troubleshooting when this procedure doesn’t work?

By: Bjorn Lindstrom

Bjorn Lindstrom — Fri, 14 Dec 2018 21:52:34 +0000

Hi, this looks very useful, however I do have a question regarding the connection string. It appears that there might be an extra closing parenthesis following the curly brace for “password”?

I just wanted to confirm that it is supposed to be that way?

Thanks!

By: christophe

christophe — Thu, 08 Nov 2018 14:11:21 +0000

In reply to mike.

Thanks for your help, ilt’s not working for me 🙁

By: mike

mike — Thu, 08 Nov 2018 08:48:31 +0000

In reply to christophe. Look at the answer here, it may help you

By: christophe

christophe — Wed, 07 Nov 2018 14:49:03 +0000

hi,
Thank’s for your help
i tried to use pyodbc in my Debian9
my MSSQL is installed on windows server

i do installation of pyodbc with pip3 -> it’s OK
but when i try to connect with your example (or another in other wibsite) pyodbc return me :

pyodbc.Error: (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘ODBC Driver 13 for SQL Server’ : file not found (0) (SQLDriverConnect)”)

Can you help me ?
best regards
Christophe