I just have read-only access to the MS SQL server database. I can't install anything on the Windows box. So all I can do is execute sql queries against it.
On Thu, Aug 8, 2013 at 9:19 AM, Michael Manfre <[email protected]> wrote: > 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. > > -- 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.
