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