Friday, May 6, 2016

Re: Connecting to an established MS SQL database

On Thu, May 5, 2016 at 3:26 PM, David McDonald <parkyerbike@gmail.com> wrote:
> Hello, I am very new to Django and have an idea for an application at work.
>
> We have an already established MS SQL database, that I have a read only user
> for.
>
> Is there any way I can connect to this database and retrieve data from it,
> once I have retrieved it, I would like to connect to another MS SQL database
> and perform some actions on the data so this new database may be queried via
> a website.
>
> Is the above even possible?

There are django-mssql and django_pyodbc but I was never able to get
either of those to work for me. I ended up using odbc - I couldn't use
the ORM, but I still was able to connect to the MSSQL DB from my
django app using raw queries.

--
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-users@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/CACwCsY4tVDjusgu6saKWH3f7E2DhuPZ%2BwdXe8Gc4Ncsmx102%2Bg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment