You're a LIFESAVER!!! Thank you! I didn't even think what I wanted was possible. I have a docker container which is running SQL Server that I connected to my database in Azure Data Studio. But I couldn't figure out why I couldn't connect my Jupyter notebook(in VS Code) to the database... But when I ran the commands you suggested and added the driver file path and 'encrypted=no', everything worked out! encrypt = 'no', driver = '/opt/homebrew/lib/libmsodbcsql.18.dylib' sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3 sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl
Use pymssql instead. The syntax for executing parameterized statements is a little different, but it's an easy change to learn, and the installation for pymssql is often easier on Mac because it doesn't go through the MS ODBC drivers.
Sir, I am getting this error: pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 18 for SQL Server' : file not found (0) (SQLDriverConnect)") Do you have any suggestions?
sir i have a mac intel processor and i tried with verison 17 pyodbc , it shows this error, could you tell me what could be the reason? pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user
This type of error looks like your database credentials are wrong. Check your database username and password. Are you using cisdbss.pcc.edu for the server with IMDB as the database and 275student for both user and password?
Please don't say that. You better share what you did and we can help you to find a solution. This video was REALLY useful. I'm using a MacBook Pro (M3 Pro) and there was a small difference at the end, so I had to execute the following: sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3 sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl The error is gone now and I was able to connect to SQL Server on a remote server.
Me acabas de ayudar de una manera que no tienes idea, buenisimo tu video.
You're a LIFESAVER!!! Thank you! I didn't even think what I wanted was possible. I have a docker container which is running SQL Server that I connected to my database in Azure Data Studio. But I couldn't figure out why I couldn't connect my Jupyter notebook(in VS Code) to the database... But when I ran the commands you suggested and added the driver file path and 'encrypted=no', everything worked out!
encrypt = 'no',
driver = '/opt/homebrew/lib/libmsodbcsql.18.dylib'
sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3
sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl
can you please help me with this? I'm stuck in the same scenario
Hi Marc, I don''t find opt folder in /usr/local
Any idea why this might be the case. Also in my system it says openssl 1.1.1.w - is that okay?
Hi Marc, I'm still getting the same error. Do you have any other recommendations?
Use pymssql instead. The syntax for executing parameterized statements is a little different, but it's an easy change to learn, and the installation for pymssql is often easier on Mac because it doesn't go through the MS ODBC drivers.
@@marcgoodman4862 Thanks!! That worked for me!
Sir, I am getting this error: pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 18 for SQL Server' : file not found (0) (SQLDriverConnect)")
Do you have any suggestions?
Are you sure you installed version 18 of MSODBC? If you installed a different version, it wouldn't be able to find Driver 18.
@@marcgoodman4862 Sir: Not sure, I will re-install ODBC on Mac and try again. Thank you.
sir i have a mac intel processor and i tried with verison 17 pyodbc , it shows this error, could you tell me what could be the reason? pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user
This type of error looks like your database credentials are wrong. Check your database username and password. Are you using cisdbss.pcc.edu for the server with IMDB as the database and 275student for both user and password?
@@marcgoodman4862 no sir, it my private database. with credentials,
Useless and doesn't work
Please don't say that. You better share what you did and we can help you to find a solution. This video was REALLY useful.
I'm using a MacBook Pro (M3 Pro) and there was a small difference at the end, so I had to execute the following:
sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3
sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl
The error is gone now and I was able to connect to SQL Server on a remote server.