Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.18.dylib' : file not found (0) (SQLDriverConnect)") #1116

manamhr · 2022-11-01T03:46:33Z

Environment

To diagnose, we usually need to know the following, including version numbers. On Windows, be
sure to specify 32-bit Python or 64-bit:

Python: 3.9.7
pyodbc: 4.0.34
OS: Mac (M1)
DB:
driver: ODBC

Issue

I have Mac M1, trying to connect to Azure SQL server using pyodbc. my settings works well on my previous windows base laptop, but not here. This is the error I get when trying to connect to sql server using pyodbc

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.18.dylib' : file not found (0) (SQLDriverConnect)")
but file exists.

I checked lipo -info /opt/homebrew/Cellar/msodbcsql18/18.1.1.1/lib/libmsodbcsql.18.dylib

returns:
Non-fat file: /opt/homebrew/Cellar/msodbcsql18/18.1.1.1/lib/libmsodbcsql.18.dylib is architecture: arm64

libmsodbcsql.18.dylib exists in /opt/homebrew/Cellar/msodbcsql18/18.1.1.1/lib/libmsodbcsql.18.dylib, but there is a shortcut in /opt/homebrew/lib/libmsodbcsql.18.dylib. I also changed Driver to the above address, still same result.

This was my process:
I have installed ODBC V18 and brew using Microsoft instruction. when I run this on terminal works fine:

odbcinst -j
unixODBC 2.3.11
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/user_name/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
(base) User_name@TMDLXNPPVJ4J ~ % cat /opt/homebrew/etc/odbcinst.ini
[ODBC Driver 18 for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/homebrew/lib/libmsodbcsql.18.dylib
UsageCount=1

pyodbc.drivers() returns [ODBC Driver 18 for SQL Server]

I have also did these:

brew install unixodbc
export LDFLAGS="-L/opt/homebrew/Cellar/unixodbc/2.3.11/lib"
export CPPFLAGS="-I/opt/homebrew/Cellar/unixodbc/2.3.11/include"
pip install pyodbc

isql -v -k "DRIVER={ODBC Driver 17 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx" works by the way

Please help. thanks

The text was updated successfully, but these errors were encountered:

v-makouz · 2022-11-01T21:26:25Z

When you say isql -v -k "DRIVER={ODBC Driver 17 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx" does that mean you have both 17 and 18 installed? And if so have you tried isql -v -k "DRIVER={ODBC Driver 18 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx"?

If isql can load the .so and pyodbc can't load the same exact .so, I wonder if pyodbc somehow runs under emulation and not in the ARM mode, and thus can't load the ARM driver.

manamhr · 2022-11-01T21:35:00Z

When you say isql -v -k "DRIVER={ODBC Driver 17 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx" does that mean you have both 17 and 18 installed? And if so have you tried isql -v -k "DRIVER={ODBC Driver 18 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx"?

If isql can load the .so and pyodbc can't load the same exact .so, I wonder if pyodbc somehow runs under emulation and not in the ARM mode, and thus can't load the ARM driver.

sorry the correct one is: isql -v -k "DRIVER={ODBC Driver 18 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx"

That's my suspecion too. I have installed pyodbc under anaconda, and also using pip install on terminal. I tried installing through brew, but didn't work. How could I solve this issue? Thanks

manamhr · 2022-11-01T21:43:01Z

also when I run Jupiter notebook through terminal, pyodbc.driver returns null

v-makouz · 2022-11-08T23:13:00Z

It looks like the driver and unixODBC are correct ARM versions, what about python itself?

AraHaan · 2022-11-30T19:41:40Z

Does this support connecting to sql server 2016 perhaps?

v-chojas · 2022-11-30T19:50:40Z

Yes it does

dilshatu · 2023-02-10T18:55:12Z

I have exactly the same problem. Has it been resolved? And why is it closed?

v-makouz · 2023-02-14T23:14:54Z

In the original issue isql worked, but the connection through pyodbc didn't. So the driver and unixODBC were definitely correct, it seems either pyodbc was a non-ARM version, or it was loading a different driver or driver manager, than isql.

SebDigital · 2023-06-05T19:44:58Z

Hi, I am running into the same issue, has anyone has solved it? also when I run this one:
isql -v -k "DRIVER={ODBC Driver 18 for SQL Server};SERVER=xxx;UID=xxx;PWD=xxx"
My password has a ! and it created this error:
bash: !": event not found

Thanks

v-chojas · 2023-06-05T20:19:47Z

Use single quotes to escape your connection string.

SebDigital · 2023-06-06T14:31:52Z

Thanks @v-chojas , worked well.
So I am in the same situation as you @v-makouz . Did you find a solution?

--
pyodbc.drivers()
Return [] so empty.

odbcinst -j show:

unixODBC 2.3.11
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/sebdigital/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

And connection using isql is working..

Thanks!

v-chojas · 2023-06-06T17:54:36Z

Run otool -L on the pyodbc module file (pyodbc.__file__) and see whether it is linking to same libodbc as the odbcinst.

SebDigital · 2023-06-08T09:45:36Z

Thanks @v-chojas ,

This is the result I have:

/Users/sebdigital/.local/share/virtualenvs/testconnect-7i8svD64/lib/python3.10/site-packages/pyodbc.cpython-310-darwin.so:
        /usr/local/opt/unixodbc/lib/libodbc.2.dylib (compatibility version 3.0.0, current version 3.0.0)
        /usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 1300.36.0)
        /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1319.0.0)

Thanks for your help

v-chojas · 2023-06-08T14:52:06Z

Do the same with the isql and odbcinst files and check which libodbc they are linking to.

SebDigital · 2023-06-08T15:13:30Z

Thanks @v-chojas , here are my results

odbcinst

/usr/local/bin/odbcinst:
        /usr/local/Cellar/unixodbc/2.3.11/lib/libodbcinst.2.dylib (compatibility version 3.0.0, current version 3.0.0)
        /usr/local/opt/libtool/lib/libltdl.7.dylib (compatibility version 11.0.0, current version 11.2.0)
        /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1311.100.3)

And isql


 /usr/local/Cellar/unixodbc/2.3.11/lib/libodbc.2.dylib (compatibility version 3.0.0, current version 3.0.0)
        /usr/local/opt/libtool/lib/libltdl.7.dylib (compatibility version 11.0.0, current version 11.2.0)
        /usr/lib/libiconv.2.dylib (compatibility version 7.0.0, current version 7.0.0)
        /usr/lib/libedit.3.dylib (compatibility version 2.0.0, current version 3.0.0)
        /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1311.100.3)

orlandombaa · 2023-09-04T21:43:09Z

Hello, I have the same issue. I have been triying to make the conection without sucess.

Has anyone been able to establish the connection?

silverlightjashmin · 2024-02-06T14:02:14Z

pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmyodbc8a.so' : file not found (0) (SQLDriverConnect)")
same error, i am able to connect to mysql server using same driver but , unable to connect using pyodbc. what might be the cause

v-chojas · 2024-02-06T15:59:16Z

Check whether pyodbc module is linking to the same unixODBC using otool -L as shown above.

silverlightjashmin · 2024-02-07T07:11:12Z

i am using ubuntu 20.04 os , and isql working with same driver, but pyodbc is unable to connect

Himanshup21234 · 2024-04-18T14:59:04Z

This post helped me for the same issue:
#1165

samcofer · 2024-08-13T19:13:25Z

i am using ubuntu 20.04 os , and isql working with same driver, but pyodbc is unable to connect

@silverlightjashmin Were you ever able to resolve this issue?

silverlightjashmin · 2024-08-14T03:45:24Z

@samcofer yes, what i did was uninstall all the driver, restarted the ubuntu server and reinstalled all the driver again. and it worked for me

parnia-ai · 2024-10-14T07:07:57Z

I encountered the same error using ubuntu 22.04 . i realised there can be a conflict having both msodbcsql17 and msodbcsql18. so i uninstalled and removed every possible config or driver using following commands and then installed the msodbcsql17 and verified the installation:

sudo su
apt-get remove --purge msodbcsql17
apt-get remove --purge msodbcsql18
rm -rf /opt/microsoft/msodbcsql17/
rm -rf /opt/microsoft/msodbcsql18/
--------------
sudo apt-get autoremove
sudo apt-get clean
--------------
sudo apt-get install msodbcsql17

to verify the installation

odbcinst -q -d -n "ODBC Driver 17 for SQL Server"

hope this help

gordthompson closed this as not planned Won't fix, can't repro, duplicate, stale Dec 20, 2022

gordthompson reopened this Feb 10, 2023

carlashley mentioned this issue Oct 25, 2023

macOS Sonoma - pyodbc 5.0.0b2 crashes - zsh: bus error python3 #1284

Closed

cagrimunyas mentioned this issue Jan 27, 2024

MSodbcSQL18 is not supported on Macos 14 microsoft/homebrew-mssql-release#98

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.18.dylib' : file not found (0) (SQLDriverConnect)") #1116

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.18.dylib' : file not found (0) (SQLDriverConnect)") #1116

manamhr commented Nov 1, 2022

v-makouz commented Nov 1, 2022

manamhr commented Nov 1, 2022

manamhr commented Nov 1, 2022

v-makouz commented Nov 8, 2022

AraHaan commented Nov 30, 2022

v-chojas commented Nov 30, 2022

dilshatu commented Feb 10, 2023

v-makouz commented Feb 14, 2023

SebDigital commented Jun 5, 2023 •

edited

Loading

v-chojas commented Jun 5, 2023

SebDigital commented Jun 6, 2023 •

edited

Loading

v-chojas commented Jun 6, 2023

SebDigital commented Jun 8, 2023

v-chojas commented Jun 8, 2023

SebDigital commented Jun 8, 2023

orlandombaa commented Sep 4, 2023

silverlightjashmin commented Feb 6, 2024

v-chojas commented Feb 6, 2024

silverlightjashmin commented Feb 7, 2024

Himanshup21234 commented Apr 18, 2024

samcofer commented Aug 13, 2024

silverlightjashmin commented Aug 14, 2024

parnia-ai commented Oct 14, 2024

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.18.dylib' : file not found (0) (SQLDriverConnect)") #1116

Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/homebrew/lib/libmsodbcsql.18.dylib' : file not found (0) (SQLDriverConnect)") #1116

Comments

manamhr commented Nov 1, 2022

Environment

Issue

v-makouz commented Nov 1, 2022

manamhr commented Nov 1, 2022

manamhr commented Nov 1, 2022

v-makouz commented Nov 8, 2022

AraHaan commented Nov 30, 2022

v-chojas commented Nov 30, 2022

dilshatu commented Feb 10, 2023

v-makouz commented Feb 14, 2023

SebDigital commented Jun 5, 2023 • edited Loading

v-chojas commented Jun 5, 2023

SebDigital commented Jun 6, 2023 • edited Loading

odbcinst -j show:

unixODBC 2.3.11 DRIVERS............: /opt/homebrew/etc/odbcinst.ini SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources USER DATA SOURCES..: /Users/sebdigital/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8

v-chojas commented Jun 6, 2023

SebDigital commented Jun 8, 2023

v-chojas commented Jun 8, 2023

SebDigital commented Jun 8, 2023

orlandombaa commented Sep 4, 2023

silverlightjashmin commented Feb 6, 2024

v-chojas commented Feb 6, 2024

silverlightjashmin commented Feb 7, 2024

Himanshup21234 commented Apr 18, 2024

samcofer commented Aug 13, 2024

silverlightjashmin commented Aug 14, 2024

parnia-ai commented Oct 14, 2024

SebDigital commented Jun 5, 2023 •

edited

Loading

SebDigital commented Jun 6, 2023 •

edited

Loading

unixODBC 2.3.11
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/sebdigital/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8