Django给出错误:异常类型:OperationalError [英] Django giving error: Exception Type: OperationalError

问题描述

异常值:

(com_error(-2147352567, 'Exception occurred.', 
 (0, 
  u'ADODB.Connection',
  u'Provider cannot be found. It may not be properly installed.', 
  u'C:\\Windows\\HELP\\ADO270.CHM', 1240655, -2146824582),
  None),
 u'Error opening connection: DATA SOURCE=172.16.26.51\\myinstance;Initial Catalog=dbName;UID=****;PWD=****;PROVIDER=sqlncli10;DataTypeCompatibility=80;MARS Connection=True')

我正在使用:

Django==1.5.5
django-mssql==1.4
pywin32==218

相同的项目，相同的设置，在一台机器上成功运行，但在另一台机器上没有运行.

Same project with same setup, runs on successfully on one machine but it doesn't run other machine.

我使用 PIP 来安装 Django 和 django-mssql.

I used PIP for installation of Django and django-mssql.

这里是回溯

File "C:\Python27\lib\site-packages\django\core\handlers\base.py" in get_response
  115.                         response = callback(request, *callback_args, **callback_kwargs)
File "C:\inetpub\wwwroot\newsite\dbexplorer\views.py" in viewVersionList
  18.     cursor = connection.cursor()
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py" in cursor
  324.             cursor = self.make_debug_cursor(self._cursor())
File "C:\Python27\lib\site-packages\sqlserver_ado\base.py" in _cursor
  241.             self.__connect()
File "C:\Python27\lib\site-packages\sqlserver_ado\base.py" in __connect
  196.             use_transactions=self.use_transactions,
File "C:\Python27\lib\site-packages\sqlserver_ado\dbapi.py" in connect
  151.         raise OperationalError(e, "Error opening connection: " + connection_string)

Exception Type: OperationalError at /dbexplorer/
Exception Value: (com_error(-2147352567, 'Exception occurred.', (0, u'ADODB.Connection', u'Provider cannot be found. It may not be properly installed.', u'C:\\Windows\\HELP\\ADO270.CHM', 1240655, -2146824582), None), u'Error opening connection: DATA SOURCE=172.16.26.51\\myinstance;Initial Catalog=dbexplorer;UID=****;PWD=****;PROVIDER=sqlncli10;DataTypeCompatibility=80;MARS Connection=True')

推荐答案

出现这个错误是因为我的一些机器没有安装 SQL Native 客户端.

This errors comes because some of my machine don't have SQL Native client installed.

您可以从 Microsoft® SQL Server® 2008 R2 下载SP2 功能包

您可以获得客户端的独立安装程序.根据您的架构下载安装程序.

You can get a stand alone installer for the client. Download installer according to your architecture.

选择其中之一:sqlncli_x86.msi/sqlncli_ia64.msi/sqlncli_amd64.msi

这篇关于Django给出错误:异常类型:OperationalError的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！