django-pyodbc怎么连SQL Server 2008?
本帖最后由 pycollin 于 2013-03-10 22:56:35 编辑 django-pyodbc连SQL Server 2008配置:
DATABASES = {
'default': {
'ENGINE': 'sql_server.pyodbc' ,
'NAME': 'test',
'USER': 'user',
'PASSWORD': 'login',
'HOST': '192.168.2.100',
'PORT': '',
}
}
DATABASE_OPTIONS= {
'driver': 'SQL Server Native Client 10.0',
'MARS_Connection': True,
}
django-pyodbc连SQL Server 2008报如下错误,请高人帮忙解决
Traceback (most recent call last):
File "F:\web\blog\manage.py", line 11, in <module>
execute_manager(settings)
File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line
459, in execute_manager
utility.execute()
File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line
382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line
261, in fetch_command
klass = load_command_class(app_name, subcommand)
File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line
69, in load_command_class
module = import_module('%s.management.commands.%s' % (app_name, name))
File "C:\Python27\lib\site-packages\django\utils\importlib.py", line 35, in im
port_module
__import__(name)
File "C:\Python27\lib\site-packages\django\core\management\commands\inspectdb.
py", line 5, in <module>
from django.db import connections, DEFAULT_DB_ALIAS
File "C:\Python27\lib\site-packages\django\db\__init__.py", line 40, in <modul
e>
backend = load_backend(connection.settings_dict['ENGINE'])
File "C:\Python27\lib\site-packages\django\db\__init__.py", line 34, in __geta
ttr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "C:\Python27\lib\site-packages\django\db\utils.py", line 93, in __getitem
__
conn = backend.DatabaseWrapper(db, alias)
File "C:\Python27\lib\site-packages\sql_server\pyodbc\base.py", line 133, in _
_init__
self.ops = DatabaseOperations(self)
File "C:\Python27\lib\site-packages\sql_server\pyodbc\operations.py", line 10,
in __init__
super(DatabaseOperations, self).__init__()
TypeError: __init__() takes exactly 2 arguments (1 given)
[解决办法]
现在不支持sql2008,只支持mysql、sqlite3、postgresql,我用的就是mysql
[解决办法]
看错误信息应该是django-pyodbc比较老旧,不兼容较新的django。试试django-mssql...