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?
@eduardomarcelogutierrezsot9577
Жыл бұрын
Me acabas de ayudar de una manera que no tienes idea, buenisimo tu video.
@moramoy1
Жыл бұрын
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?
@marcgoodman4862
Жыл бұрын
Are you sure you installed version 18 of MSODBC? If you installed a different version, it wouldn't be able to find Driver 18.
@moramoy1
Жыл бұрын
@@marcgoodman4862 Sir: Not sure, I will re-install ODBC on Mac and try again. Thank you.
@RahulThiruthinmelPremnavas
3 ай бұрын
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
@marcgoodman4862
3 ай бұрын
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?
@RahulThiruthinmelPremnavas
3 ай бұрын
@@marcgoodman4862 no sir, it my private database. with credentials,
@user-kp4fo1bj8o
2 жыл бұрын
Hi Marc, I'm still getting the same error. Do you have any other recommendations?
@marcgoodman4862
2 жыл бұрын
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.
@user-kp4fo1bj8o
2 жыл бұрын
@@marcgoodman4862 Thanks!! That worked for me!
@daleksupreme922
Жыл бұрын
Useless and doesn't work
@Ylliwx3
10 ай бұрын
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.
@elliepenkova3853
4 ай бұрын
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
@siyasuryawanshi1
2 ай бұрын
can you please help me with this? I'm stuck in the same scenario
Пікірлер: 15