sql server 2008 - django connection.cursor.execute() returns None -
in python shell (python 2.7, django 1.6, windows 8), i'm trying execute simple query against 1 of table in sql server 2008 (engine=django_mssql): connection.cursor.execute("select * mymodel_mytable") the result none. connection working since simple : mymodel.objects.get(pk=1) returns expected row. if same in shell (ubuntu, engine=django_pyodbc), returns expected pyodbc_cursor object on can fetch rows. where wrong? please, help! regards, patrick edit: databases dict in settings is: databases = { 'default': { 'engine': "sqlserver_ado", 'host': "myhost,myport", 'user': "myuser", 'password': "mypass", 'name': "mydb", 'options': { 'provider': "sqlncli10", 'extra_params': "datatypecompatibility=80;mars connection=true;" }, 'command_time