设置django-mssql问题 [英] Setting up django-mssql issues

问题描述

我在Win Server 2008 R2上设置了django-mssql的一些问题。我已经安装了所有东西，但是django-mssql的wiki表示设置文件类似于：

I'm having some issues setting up django-mssql on Win Server 2008 R2. I have everything installed, however, the wiki for django-mssql says to setup the settings file similar to:

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

当我运行从我的网站目录：

When I run from my site directory:

 python manage.py syncdb

我收到一条错误，指出它不是可用的数据库后端。当我安装django-mssql它似乎在这里安装后端 \site-packages\django_mssql-1.0.1-py2.7.egg\sqlserver_ado 这需要复制到 site-packages\django\db\backends ？

I get an error stating it isn't an available database backend. When I installed django-mssql it seemed to install the backend here \site-packages\django_mssql-1.0.1-py2.7.egg\sqlserver_ado does this need to be copied to site-packages\django\db\backends?

如果我将设置设置为：

DATABASES = {
'default': {
    'NAME': 'my_database',
    'ENGINE': 'django_mssql-1.0.1-py2.7.egg.sqlserver_ado',
    'HOST': 'dbserver\\ss2008',
    'USER': '',
    'PASSWORD': '',
    'OPTIONS' : {
        'provider': 'SQLOLEDB',
        'use_mars': True,
    },
   }
}

我在设置此后端时缺少什么？这是我第一次使用django，但在文档中没有看到设置不同的后端，而django-mssql维基或问题似乎也没有任何东西。

Am I missing something when setting up this backend? This is my first time using django, but I didn't see anything in the documentation for setting up a different backend, and the django-mssql wiki or issues doesn't seem to have anything either.

另外，如果有其他文档可以帮助，请让我知道。

Also, if there is other documentation somewhere that can help please let me know.

编辑：django应用程序在Ubuntu服务器上运行。 / p>

The django app is running on Ubuntu server.

推荐答案

您将需要确保您可以从您的python shell导入sqlserver_ado。

You will want to make sure that you can import "sqlserver_ado" from your python shell.

将文件夹sqlserver_ado放在PATH的某处，我把我的\site-packages\

Put the folder sqlserver_ado somewhere on your PATH, I put mine in \site-packages\

看看 README.txt 。

引擎确实要设置为sqlserver_ado，类似于设置示例页面上的设置。

The engine does want to be set to "sqlserver_ado" similar to how the settings are done on the settings sample page.

这篇关于设置django-mssql问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！