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_timeout': 7200,     } } 


Comments

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -