[办公软件] Python连接sqlserver

pyodbc.connect('DRIVER=%s;SERVER=%s;DATABASE=%s;UID=%s;PWD=%s' % (
  '{SQL Server}', server ip, database name, db user, db passowrd
  )
)

• 安装依赖
  

yum install -y gcc-c++ python-devel

• 安装unixODBC
  

yum install -y unixODBC unixODBC-devel

• 安装驱动
  

sudo su
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
exit
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y yum install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo yum install unixODBC-devel

• 连接
  

pyodbc.connect('DRIVER=%s;SERVER=%s;DATABASE=%s;UID=%s;PWD=%s' % (
  '{ODBC Driver 13 for SQL Server}', server ip, database name, db user, db passowrd
  )
)

DB_DRIVER = 'SQL Server'
DB_URI = 'mssql+pyodbc://%s:%s@%s:%s/%s?driver=%s' % (
  DB_USERNAME, DB_PASSWORD, DB_HOST, DB_PORT, DB_NAME, DB_DRIVER
)