Any particular reason you want to completely avoid the ORM? My main project that uses django-mssql started off with a lot of raw queries (including stored procedure calls) to work with the legacy business database. It was a maintenance headache and one of the main reasons I added support to django-mssql to allow using resultsets generated by stored procedures with Django's raw command [1].
To work directly with mssql from linux, you'll probably want to use pyodbc [2]. If running Django on windows, you can either use pyodbc or install django-mssql and execute raw queries. [1] http://django-mssql.readthedocs.org/en/latest/usage.html#rawstoredproceduremanager [2] https://code.google.com/p/pyodbc/ Regards, Michael Manfre On Wednesday, August 7, 2013 1:42:48 PM UTC-4, [email protected] wrote: > > I have a django app that connects to a MySQL server in the usual way. > I've noe been asked to add some new functionality that requires that I > pull data from a MS SQL server database running on a Windows box. I > don't want to use the django ORM with the db, just access it directly > with some sql in my python code. What's the best way to accomplish > this? > -- 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 http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
