[ad_1]
first, I should say to you that I use ubuntu on wsl2 in a windows 10, then I installed sql server on windows 10.
then used blow commands to install pyodb:
sudo apt install python3-pyodbc
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version
#Ubuntu 20.04
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install -y unixodbc-dev
after, I create tesrt.py
and put the following code on it:
import pyodbc
conn = pyodbc.connect('Driver={ODBC Driver 17 for SQL Server};'
'SERVER=HQ-PC-059KAISQL;'
'USER=sa;'
'PASSWORD=pass;'
'Trusted_Connection=yes')
I ran this app, at the end I gave this error:
pyodbc.OperationalError: (‘HYT00’, ‘[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)’)
I don’t have any idea but I connected to that with sqlcmd:
Sqlcmd -S HQ-PC-059KAISQL -U sa -P pass
thank you <3
[ad_2]