Tag: pyodbc

  • 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',
            },
        }
    }