id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
24872	dbshell don't read parameters correctly with sql_server.pyodbc (django-pyodbc-azure)	netamego	nobody	"The next connection:

{{{

    'BBDDSQL': {
        'NAME': 'MyDatabase',
        'ENGINE': 'sql_server.pyodbc',
        'HOST': 'freetds_dsn_BBDD',
        'USER': 'sa',
        'PASSWORD': 'MyPassword',
        'PORT': '49247',
        'OPTIONS': {
                'driver': 'FreeTDS',
                'dns':'MyDns',
                'MARS_Connection': True,
        },
    }
}}}


works like a charm inside Django views but fails with the next command:

python manage.py dbshell --database=BBDDSQL

with error:


{{{
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
}}}

Command:

isql -v MyDns sa MyPassword

works perfect so I have enabled

{{{
[ODBC]
Trace=Yes
TraceFile=/tmp/odbc_u.log
}}}

in odbcinst.ini file and run 

{{{
python manage.py dbshell --database=BBDDSQL
}}}

What I see in /tmp/odbc_u.log trace file is:

{{{

                        Server Name = [sa][length = 2 (SQL_NTS)]
                        User Name = [MyPassword][length = 9 (SQL_NTS)]
                        Authentication = [NULL]

}}}



So dbshell is not reading correctly parameters from settings.py when use sql_server.pyodbc engine.

This error is in Django 1.7 and 1.8.


Thanks.

"	Uncategorized	closed	Core (Management commands)	1.8	Normal	needsinfo	dbshell,sql_server.pyodbc		Unreviewed	0	0	0	0	0	0