环境:mssql2008、python2.7.3、django1.45
django-mssql终于对mssql2008支持的不错了,具体配置过程如下:
'default': {
'ENGINE': 'django.db.backends.sqlserver_ado', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
'NAME': 'isell',
# Or path to database file if using sqlite3.
'USER': 'sa',
# Not used with sqlite3.
'PASSWORD': 'sa',
# Not used with sqlite3.
'HOST': 'id',
# Set to empty string for localhost. Not used with sqlite3.
'PORT': '',
# Set to empty string for default. Not used with sqlite3.
}
1、安装 django-mssql-1.2
2、将 django-mssql-1.2 安装包下的sqlserver_ado 拷贝到 \Python27\Lib\site-packages\django\db\backends 目录下
3、配置方法如下,id为机器名
DATABASES = {
}