I am trying to create a django app using my backend db as MSSQL. I am trying to use this as the db engine. I used the settings as mentioned in the installation as follows:
DATABASES = {
'default': {
'NAME': 'texascompletes',
'ENGINE': 'sqlserver_ado',
'HOST': 'dbserver\\ss2008',
'USER': '',
'PASSWORD': '', # Set to empty string for default.
}
}
But i am getting the following error:
django.core.exceptions.ImproperlyConfigured: 'sqlserver_ado' isn't an available database backend.
Try using django.db.backends.XXX, where XXX is one of:
'dummy', 'mysql', 'oracle', 'postgresql_psycopg2', 'sqlite3'
Error was: No module named sqlserver_ado.base
I have followed this post and also installed the version that i use in my windows machine but the error still persists. What should i further look at to solve this issue?