Settings

Django-mssql supports Django 1.1 and earlier style settings in addition to Django 1.2 multi-db settings.

Example Settings

DATABASES = {
    'default': {
        'NAME': 'my_database',
        'ENGINE': 'sqlserver_ado',
        'HOST': 'dbserver\\ss2008',
        'USER': '',
        'PASSWORD': '',
        'OPTIONS' : {
            'provider': 'SQLOLEDB',
            'use_mars': True,
        },
    }
}

The following standard settings are recognized by this backend:

`HOST`	The machine to connect to, as a name or IP address; You may specify a database instance. If empty, 127.0.0.1 will be used.
`PORT`	The port to connect to, if not using the standard SQL Server port.
`NAME`	The SQL database name.
`USER`	Leave blank to use a trusted connection (SSPI), otherwise a valid database user.
`PASSWORD`	If proving a database user, the password for that user.

Additional django-mssql specific OPTIONS:

`use_mars`	Set to `True` to enable "Mutliple Active Recordsets".
`extra_params`	A string that will be appended to the end of the generated connection string. Use this to pass through any additional connection string options.
`provider`	The SQL provider to use when connecting to the database. Default is "SQLOLEDB".

Notes

You will almost certainly want to set use_mars=True in your settings.py to allow you to iterate over query results while issuing new queries per-record.

If your code gives you Cannot create new connection because in manual or distributed transaction mode errors, then MARS needs to be on.

► Sign in to add a comment