No SQLOLEDB.1 drivers for linux

Support Third-party Applications
1

Hi
I was wondering whether it is possible to install OLEDB provider for mssql on a client side. Referring to the Microsoft’s documentation the SQLOLEDB provider is included with Windows os OLE DB support policies section, but possibility of installing it on a linux machine is never mentioned anywhere. While other providers like ODBC have install scripts ready to use on various distros ODBC. I need it to be able to connect to Microsoft sql server with OLEDB from azure data studio, it is possible on windows machine no problem, but it fails instantly on my manjaro machine. If it’s not possible because of OLEDB being deprecated and underdeveloped from its very beginning so be it, I will find some other way.

Thanks for any thoughts in advance.

2

I dont know about OLEDB, but for ODBC there are a number of available packages…

https://packages.manjaro.org/?query=odbc

https://aur.archlinux.org/packages?K=odbc&O=0&SB=v&SO=d

3

OLE DB is a technology internal to Microsoft products and is an acronym for Object Linking and Embedding Database.

As it has been superseeded by ODBC, I suggest you use ODBC instead as this is a cross platform communication protocol.

That is not a requirement - Azure datastudio has no issues with SQL server on Linux.

pamac build azuredatastucio-bin
Screenshot

image
image506×642 39.6 KB

4

I am facing a similar issue
whenever I am trying to connect
I get this error
Failed to connect to the database: [Error: [odbc] Error connecting to the database] { odbcErrors: [ { state: '01000', code: 0, message: "[unixODBC][Driver Manager]Can't open lib ''{ODBC Driver 18 for SQL Server}' : file not found" } ] }

I tried installing different packages from the link above
but all end up with the same error

but when I run
odbc_config --version
I get 2.3.12

5

There are two links. You didn’t tell which you meant - and you didn’t tell which packages you tried.

From the posted error message

I’d have tried this:

AUR (en) - msodbcsql

But without any information this is purely a guess based on the name.
And: I have zero experience with any database and cannot actually help.