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, larry....@gmail.com 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 django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
