Stack Overflow
Stack Overflow

Questions tagged [msodbcsql17]

Questions regarding Microsoft's ODBC Driver 17 for SQL Server.

Windows:
https://www.microsoft.com/en-us/download/details.aspx?id=56567

Linux/Mac:
https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

22 questions
9
votes
1 answer

How do I install msodbcsql17 driver for alpine linux?

I found a related issue on github but it is under the msphpsql repo so I'm not sure if it applies to the driver in general for alpine. It says MS does not support yet. Official MS installation page has installation instructions only for Debian,…
scientific_explorer
  • 858
  • 12
  • 29
8
votes
3 answers

SQLAlchemy error: An attempt to complete a transaction has failed. No corresponding transaction found

I have installed: Ubuntu (18.04) Python (3.6.8) msodbcsql17 (Microsoft ODBC Driver 17 for SQL Server) SQLAlchemy (1.3.5) Pandas (0.24.2) and I want to create just a proof of concept using SQLAlchemy with an Azure SQL Data Warehouse. However, when…
Efstathios Chatzikyriakidis
  • 1,341
  • 2
  • 15
  • 33
6
votes
2 answers

Driver's SQLAllocHandle on SQL_HANDLE_HENV failed (0) (SQLDriverConnect) when connecting to Azure SQL database from Python running in OpenShift

Only when trying to connect to my Azure DB from Python 3.7 running in a OpenShift container (FROM rhel7:latest) I see the following error: sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('IM004', "[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle…
Denis Schlesinger
  • 65
  • 1
  • 1
  • 4
4
votes
1 answer

Using SQL Server file streaming in Python

I am attempting to use SQL Server 2017 filestream in python. All of the functionality i use goes through sqlalchemy, thus i am attempting to find a way of using this, since i haven't found any implementation within sqlalchemy or other libraries (may…
Zerg Overmind
  • 955
  • 2
  • 14
  • 28
4
votes
2 answers

How to fix 'Can't open libmsodbcsql-17.3.so.1.1'

In ubuntu 19.04 when working with Python3 in an anaconda environment with pyodbc 4.0.26 installed I get the Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.3.so.1.1' : file not…
Jochen Haßfurter
  • 875
  • 2
  • 13
  • 27
3
votes
1 answer

problem locating msodbcsql17 on ubuntu 21.04 using Laravel Sail

I am trying to set up connection to sql server on laravel using Docker via Sail. Here is how I am trying to get the msodbcdriver17 as listed in the installation…
Tushar
  • 1,166
  • 4
  • 14
  • 31
3
votes
1 answer

Big Sur and Install msodbcsql17

I followed Microsoft's installation for the ODBC PDO driver. /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew…
Rafael
  • 31
  • 2
3
votes
1 answer

Ubuntu 18.04 and msodbcsql17: Can't open lib - SHOULD I FILE A BUG REPORT?

Folks, I have installed the msodbcsql package at least several dozen times. Never had this issue come up. Even spent the entire day yesterday trying to fix this. Step 1: add the apt key and repo to sourced.list.d Step 2: apt-get install the…
Dean Rantala
  • 49
  • 4
2
votes
2 answers

Connection problem Linux Apache+PHP to MS SQL Server using WindowsAuth / Kerberos ("No Kerberos credentials available")

Following setup: I have a Linux (Debian) machine as a webserver (apache) and a MS SQL Server on Windows. Furthermore I am not able to get a SQL user for this, only authentication through AD/Windows Auth. I am using the Microsoft ODBC Driver and…
user8175587
1
vote
3 answers

Problems installing msodbcsql17 with Docker

I have a dockerfile to upload some python code on Azure. It has been working for a few months, but today it suddenly stopped working. The relevant commands in the Dockerfile are: FROM python:3.9.5 : : RUN curl…
Thomas Elboth
  • 21
  • 4
1
vote
0 answers

Ubuntu 16.06 Unable to locate package msodbcsql

I'm trying to install the Microsoft ODBC Driver for SQL Server on my Ubuntu 16.04. I've already done curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list and apt-get update and it looks…
modzel
  • 11
  • 3
0
votes
0 answers

How to resolve the below error while running a c program to connect to Ms SQL server from Linux fedora7 using mssqlodbc

How to resolve the below error while running a c program to connect to Ms SQL server from Linux fedora7 using mssqlodbc Need to connect to Ms SQL server from c app on Linux fedora7 using msqlodbc gcc -o prog prog.c -lc -lpthread -lodbcinst -lodbc…
Laurel
  • 1
0
votes
0 answers

Unable to locate package msodbcsql17

I'm having an issue adding Microsoft package list to apt-get in my Dockerfile running on my M1. I was able to run this on other ubuntu machines, but now on my mac, I get the Unable to locate package msodbcsql17 error
Yugesh Marahatta
  • 1
  • 1
0
votes
0 answers

MS SQL ODBC: setting scale of NUMERIC value is always rejected with "Numeric value out of range"

I am running MS SQL server 2019 on Windows and try to fill - besides others - a 'numberic(5,2)' field using MS ODBC driver version 18 for Linux, but always get an error if I set scale. The table structure: CREATE TABLE [dbo].[dboutput_test]( …
Christian Springer
  • 1
  • 1
0
votes
1 answer

How do I automatically accept EULA for MS ODBC for unix with Ansible?

I have a playbook that updates our Linux servers. One server (Centos 7) in this case, requires acceptance of the EULA for the MS odbc driver. I have seen how to do this on an install, but have not been able to make it work with update. tasks: …
Kevin Nelson
  • 185
  • 3
  • 11
1
2