connecting to mssql database

[sum abiut]

Hi,

i am having a very hard time figuring out how to connect to a mssql database. i've try following this guide but nothing seems to be working. please help

http://www.tivix.com/blog/getting-django-working-with-mssql-pyodbc/

https://pypi.python.org/pypi/django-pyodbc-azure

cheers,

[Daniel França]

What errors are you getting?

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5M37%2B9JRspvMEtUUOZVOp1SaUSuToGs0VdH%2B_DydPC8A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[sum abiut]

I am getting the error mes

django.db.utils.Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnect)')sage

On Wed, Aug 17, 2016 at 11:17 PM, Daniel França <daniel...@gmail.com> wrote:

What errors are you getting?

On Wed, 17 Aug 2016 at 14:15 sum abiut <sua...@gmail.com> wrote:

Hi,

i am having a very hard time figuring out how to connect to a mssql database. i've try following this guide but nothing seems to be working. please help

http://www.tivix.com/blog/getting-django-working-with-mssql-pyodbc/

https://pypi.python.org/pypi/django-pyodbc-azure

cheers,

--
You received this message because you are subscribed to the Google Groups "Django users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.

To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5M37%2B9JRspvMEtUUOZVOp1SaUSuToGs0VdH%2B_DydPC8A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Django users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.

To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CACPst9LGPZTHHcKDB0EVUpgrEdrBzTtMFxeCib4WScSEqWf5Mg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

-

[sum abiut]

now i have made changes to settings file

DATABASES = {
    'default': {
        'ENGINE': 'django_pyodbc',
        'NAME': xxx',
        'USER': 'xx',
        'PASSWORD': 'xx',
        'HOST': 'xxx',
        'PORT': '1433',

        'OPTIONS': {
            'host_is_server': True,
        }
    }
}

and i am getting the error :
File "/var/www/mssqlconnect/local/lib/python2.7/site-packages/django_pyodbc/base.py", line 96, in <module>
    raise ImproperlyConfigured("Django %d.%d is not supported." % DjangoVersion[:2])
django.core.exceptions.ImproperlyConfigured: Django 1.10 is not supported.

is this something has to do with version issue?

cheers

[sum abiut]

got it fixed, it was the version issue. i down grade from django 1.10 to 1.9.9 and it fixed. 

cheers