Vous n'êtes pas identifié(e).
Bonsoir,
Je dois utiliser MS SQL avec django.
J'ai donc choisi d'utiliser DJANGO-MSSQL
http://code.google.com/p/django-mssql/
Je respecte tous les exigences pour utiliser cette bibliothèque :
Django version 1.2 (r13276
<http://code.djangoproject.com/changeset/13276>) or newer => j'utilise
la version 1.2.4.
Windows and SQL Server => j'utilise Windows 7 et SQL Server 2005 Express
This backend should work with Python 2.3 and up => j'utilise Python 2.6
PyWin32 <http://sourceforge.net/project/showfiles.php?group_id=78018> is
required => je l'ai installé
J'ai aussi copié le contenu du dossier sqlserver_ado dans
c:\django\db\backend
Quand je veux lancer le serveur, j'ai ce message d'erreur :
[quote]
django.core.exceptions.ImproperlyConfigured:
'django.db.backends.sqlserver_ado' isn't an available database backend.
Try using django.db.backends.XXX, where XXX is one of:
'dummy', 'mysql', 'oracle', 'postgresql', 'postgresql_psycopg2',
'sqlite3'
Error was: No module named sqlserver_ado.base
[/quote]
Voici le code que j'ai mis dans settings.py :
DATABASES = {
'default': {
'NAME': 'neuro',
'ENGINE': 'django.db.backends.sqlserver_ado',
'HOST': '',
'USER': '',
'PASSWORD': '',
'OPTIONS' : {
'provider': 'SQLOLEDB',
'use_mars': True,
},
}
}
Voici le traceback complet :
[quote]
Traceback (most recent call last):
File "manage.py", line 11, in <module>
execute_manager(settings)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\management\__init__.py",
line 438, in execute_manager
utility.execute()
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\management\__init__.py",
line 379, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\management\base.py",
line 191, in run_from_argv
self.execute(*args, **options.__dict__)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\management\base.py",
line 209, in execute
translation.activate('en-us')
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translation\__init__.py",
line 66, in activate
return real_activate(language)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\functional.py",
line 55, in _curried
return _curried_func(*(args+moreargs), **dict(kwargs, **morekwargs))
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translation\__init__.py",
line 36, in delayed_loader
return getattr(trans, real_name)(*args, **kwargs)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translation\trans_real.py",
line 193, in activate
_active[currentThread()] = translation(language)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translation\trans_real.py",
line 176, in translation
default_translation = _fetch(settings.LANGUAGE_CODE)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translation\trans_real.py",
line 159, in _fetch
app = import_module(appname)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\importlib.py",
line 35, in import_module
__import__(name)
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\contrib\admin\__init__.py",
line 1, in <module>
from django.contrib.admin.helpers import ACTION_CHECKBOX_NAME
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\contrib\admin\helpers.py",
line 1, in <module>
from django import forms
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\forms\__init__.py",
line 17, in <module>
from models import *
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\forms\models.py",
line 6, in <module>
from django.db import connections
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\db\__init__.py",
line 77, in <module>
connection = connections[DEFAULT_DB_ALIAS]
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\db\utils.py",
line 92, in __getitem__
backend = load_backend(db['ENGINE'])
File
"C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\db\utils.py",
line 50, in load_backend
raise ImproperlyConfigured(error_msg)
django.core.exceptions.ImproperlyConfigured:
'django.db.backends.sqlserver_ado' isn't an available database backend.
Try using django.db.backends.XXX, where XXX is one of:
'dummy', 'mysql', 'oracle', 'postgresql', 'postgresql_psycopg2',
'sqlite3'
Error was: No module named sqlserver_ado.base
Process finished with exit code 1
[/quote]
Auriez-vous déjà rencontrer ce problème ? si oui, savez-vous comment le
résoudre ?
Merci d'avance à ceux qui voudront m'aider.
Hors ligne
Salut,
Je n'ai personnellement jamais utilisé mssql, ce que je peux te dire si ça
peux t'aider, c'est qu'on voit bien dans l'exception retournée que django ne
retrouver pas le répertoire de module de ton backend "sqlserver_ado".
C'est donc clairement un problème d'installation du module du backend, vérifie
que tu a bien mis ce répertoire de module dans l'emplacement correct (backends
et non pas backend), que tu utilises fais ça dans la bonne installation de
Django que tu utilises et etc..
Le dimanche 20 février 2011 20:43:38, David Dubois a écrit :
> Bonsoir,
>
> Je dois utiliser MS SQL avec django.
>
> J'ai donc choisi d'utiliser DJANGO-MSSQL
> http://code.google.com/p/django-mssql/
>
> Je respecte tous les exigences pour utiliser cette bibliothèque :
>
> Django version 1.2 (r13276
> <http://code.djangoproject.com/changeset/13276>) or newer => j'utilise
> la version 1.2.4.
>
> Windows and SQL Server => j'utilise Windows 7 et SQL Server 2005 Express
>
> This backend should work with Python 2.3 and up => j'utilise Python 2.6
>
> PyWin32 <http://sourceforge.net/project/showfiles.php?group_id=78018> is
> required => je l'ai installé
>
> J'ai aussi copié le contenu du dossier sqlserver_ado dans
> c:\django\db\backend
>
> Quand je veux lancer le serveur, j'ai ce message d'erreur :
>
> [quote]
>
> django.core.exceptions.ImproperlyConfigured:
> 'django.db.backends.sqlserver_ado' isn't an available database backend.
> Try using django.db.backends.XXX, where XXX is one of:
> 'dummy', 'mysql', 'oracle', 'postgresql', 'postgresql_psycopg2',
> 'sqlite3'
> Error was: No module named sqlserver_ado.base
>
> [/quote]
>
> Voici le code que j'ai mis dans settings.py :
>
>
> DATABASES = {
> 'default': {
> 'NAME': 'neuro',
> 'ENGINE': 'django.db.backends.sqlserver_ado',
> 'HOST': '',
> 'USER': '',
> 'PASSWORD': '',
> 'OPTIONS' : {
> 'provider': 'SQLOLEDB',
> 'use_mars': True,
> },
> }
> }
>
>
> Voici le traceback complet :
>
> [quote]
> Traceback (most recent call last):
> File "manage.py", line 11, in <module>
> execute_manager(settings)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\managemen
> t\__init__.py", line 438, in execute_manager
> utility.execute()
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\managemen
> t\__init__.py", line 379, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\managemen
> t\base.py", line 191, in run_from_argv
> self.execute(*args, **options.__dict__)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\core\managemen
> t\base.py", line 209, in execute
> translation.activate('en-us')
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translat
> ion\__init__.py", line 66, in activate
> return real_activate(language)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\function
> al.py", line 55, in _curried
> return _curried_func(*(args+moreargs), **dict(kwargs, **morekwargs))
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translat
> ion\__init__.py", line 36, in delayed_loader
> return getattr(trans, real_name)(*args, **kwargs)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translat
> ion\trans_real.py", line 193, in activate
> _active[currentThread()] = translation(language)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translat
> ion\trans_real.py", line 176, in translation
> default_translation = _fetch(settings.LANGUAGE_CODE)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\translat
> ion\trans_real.py", line 159, in _fetch
> app = import_module(appname)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\utils\importli
> b.py", line 35, in import_module
> __import__(name)
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\contrib\admin\
> __init__.py", line 1, in <module>
> from django.contrib.admin.helpers import ACTION_CHECKBOX_NAME
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\contrib\admin\
> helpers.py", line 1, in <module>
> from django import forms
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\forms\__init__
> .py", line 17, in <module>
> from models import *
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\forms\models.p
> y", line 6, in <module>
> from django.db import connections
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\db\__init__.py
> ", line 77, in <module>
> connection = connections[DEFAULT_DB_ALIAS]
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\db\utils.py",
> line 92, in __getitem__
> backend = load_backend(db['ENGINE'])
> File
> "C:\Python26\lib\site-packages\django-1.2.4-py2.6.egg\django\db\utils.py",
> line 50, in load_backend
> raise ImproperlyConfigured(error_msg)
> django.core.exceptions.ImproperlyConfigured:
> 'django.db.backends.sqlserver_ado' isn't an available database backend.
> Try using django.db.backends.XXX, where XXX is one of:
> 'dummy', 'mysql', 'oracle', 'postgresql', 'postgresql_psycopg2',
> 'sqlite3'
> Error was: No module named sqlserver_ado.base
>
> Process finished with exit code 1
> [/quote]
>
> Auriez-vous déjà rencontrer ce problème ? si oui, savez-vous comment le
> résoudre ?
>
> Merci d'avance à ceux qui voudront m'aider.
Hors ligne