Connecting Django to IBM via DB2 ODBC Driver issue
<p>I'm making my first steps with Django (and Python) development and I'm still struggling with the tutorial. The back end database I'm using is DB2 (installed on Windows Sever 2008), I am connecting to it from my Windows 7 Professional machine using IBM DB2 ODBC Driver. The database name is POLLS, the ALIAS is POLLS and the System DSN Name is ... well, also POLLS.</p>

<p>This is the DATABASES section from the settings.py:</p>

<pre><code>DATABASES = {
    'default': {
        'ENGINE'    : 'ibm_db_django',
        'NAME'      : 'POLLS',
        'USER'      : '********',
        'PASSWORD'  : '********',
        'HOST'      : 'xxxxxxx',
        'PORT'      : '50000',
        'PCONNECT'  : True,
    }
}
</code></pre>

<p>The problem I have encountered when running the 'manage runserver' command with this configuration:</p>

<blockquote>
  <p>django.db.utils.ProgrammingError: [IBM][CLI Driver] SQL1042C  An
  unexpected system error occurred.  SQLSTATE=58004\r SQL CODE=-1042</p>
</blockquote>

<p>Running 'manage migrate' resulted in the same error.</p>

<p>Then after playing with the DB2 connection string I found that replacing 'NAME' by 'DBALIAS' </p>

<pre><code>DATABASES = {
    'default': {
        'ENGINE'    : 'ibm_db_django',
        'DBALIAS'   : 'POLLS',
        'USER'      : '********',
        'PASSWORD'  : '********',
        'HOST'      : 'xxxxxxx',
        'PORT'      : '50000',
        'AUTHENTICATION' : 'SERVER',
        'PCONNECT'  : True,
    }
}
</code></pre>

<p>allows me to run server without a problem, but an attempt to create tables with 'manage migrate' results in:</p>

<blockquote>
  <p>File
  "C:\Python34\lib\site-packages\ibm_db_django-1.0.9.2-py3.4.egg\ibm_db_django\base.py",
  line 212, in get_connection_params
      raise ImproperlyConfigured( "Please specify the valid database Name to connect to" )</p>
</blockquote>