Python-Django connect to MS SQL Server

Use django-pyodbc-azure:

pip install django-pyodbc
pip install django-pyodbc-azure

Microsoft recommend solution for Python connect to SQL Server: pyodbc

Settings.py:

DATABASES = 
    'default': {
        'NAME': 'guest',
        'ENGINE': 'sql_server.pyodbc',
        'HOST': '127.0.0.1',
        'USER': 'sa',
        'PASSWORD': 'brassaikao.idv.tw',
        'PORT': '1433',
        'OPTIONS': {
            'driver': 'ODBC Driver 17 for SQL Server',
        },
    }
}

留言

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.