Hi Rakhee,
Two possible reasons for this error :
A) ODBC driver is not installed
B) The driver requires a Data Source Name to be configured
You can refer these links for more explanation :
https://communities.actian.com/s/article/Data-source-name-not-found-and-no-default-driver-specified
https://stackoverflow.com/questions/17115632/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive
On Sunday, 7 October 2018 13:16:48 UTC+5:30, Rakhee Menon wrote:
>
> Hi everyone,
> I have a developed project in which I am trying to use sqlserver instead
> of the default sqlite database.
> While I do the changes I get the following error
>
> django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver
> Manager] Data source name not found and no default driver specified (0)
> (SQLDriverConnect)')
>
> Please help if anyone knows how to solve this issue or change default
> database to sqlserver
>
> Thanks in Advance
>
--
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 [email protected].
To post to this group, send email to [email protected].
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/9ffaefca-d7d3-4786-8f6b-bc3e45bbc85a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.