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://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

18 questions
7
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
  • 668
  • 7
  • 17
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
  • 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
  • 581
  • 3
  • 18
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 Gebsattel
  • 691
  • 1
  • 8
  • 25
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
  • 1
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
  • 3
2
votes
0 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,057
  • 2
  • 11
  • 28
1
vote
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
0
votes
1 answer

C++ msodbcsql17 SQLConnect hangs

We have a C++ application which uses ODBC to connect to SQL Server database. It is running on CentOS 7 application server. It is working flawlessly with msodbcsql17 version 17.4.2.1-1, however it breaks with version 17.6.1.1-1. Can you please advise…
Gábor Major
  • 374
  • 1
  • 4
  • 15
0
votes
1 answer

MFC ODBC RFX_Binary sets Pseudo Null value in bound CByteArray, which gets included in serialization to DB

I have been using RFX_LongBinary together with a CLongBinary variable to move data from an SQL Server varbinary(max) field. However, now the SQL Server is upgraded to 2019 version and the newest ODBC driver is being used (MSODBCSQL17.dll, version…
10100111001
  • 705
  • 13
  • 26
0
votes
0 answers

Migrate from FreeTDS driver to MSODBC17 driver

I needed to change our sql driver from FreeTDS to msobdc17 for msi support. The problem results in a degradation in our insertion operations. Specifically, when we insert in bulk (with batch size~=50), the performance is highly degraded on…
Yoni Mantzur
  • 42
  • 8
0
votes
0 answers

Does MS ODBC SQL driver install SQLcmd.exe?

I can’t seem to find the SQLcmd.exe utility after installing msodbcsql.msi (SQL driver 17). According to MS docs “The ODBC driver comes with tools such as sqlcmd and…
deadbeat253
  • 47
  • 9
0
votes
0 answers

laragon, pdo not working after update php to php.7.4.7

I have lagaron installed on my pc, Im working with php and sql server for several years now. I used to use php 7.2 and I got no problem to connect it to mssql using php_pdo_sqlsrv_72_ts_x64 and php_sqlsrv_72_ts_x64. But... I updated my php to…
ronydavid
  • 391
  • 1
  • 2
  • 10
0
votes
0 answers

Receiving error while installing the Microsoft ODBC driver for SQL Server (Linux)

I am following this blog to install Microsoft ODBC driver for SQL Server (Linux). The only change I did is I changed the version of msodbcsql to msodbsql17 as the previous version doesn't seem to work for me. So I do ACCEPT_EULA=Y yum -y install…
Naxi
  • 758
  • 11
  • 29
0
votes
1 answer

Unable to install Microsoft ODBC Driver 17 for alpine based docker

I have been trying to install the Microsoft ODBC Driver 17 for SQL Server for alpine in my dockerfile. I run the following commands in my docker file Taken from -…
ShreyaB
  • 13
  • 3
1
2