title: How to use SQLite ODBC Driver with UTF-8 encoding?
body: <p>I downloaded and installed the SQLite ODBC Driver from <a href="http://ch-werner.de/sqliteodbc/" rel="nofollow">http://ch-werner.de/sqliteodbc/</a>.
  I had three new ODBC Drivers in my List</p>
  
  <pre><code>SQLite (UTF-8) Driver
  SQLite ODBC Driver
  SQLite3 ODBC Driver
  </code></pre>
  
  <p>Using the SQLite3 ODBC Driver works just fine. But not with UTF-8.</p>
  
  <p>The SQLite ODBC (UTF-8) Driver which I assumed to work in this case just gives me the error message </p>
  
  <pre><code>Fehler beim Herstellen der Verbindung zur Datenquelle test
  
  
  IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  Fehler beim Herstellen der Verbindung zur Datenquelle: test
  </code></pre>
  
  <p>English translation:</p>
  
  <pre><code>Error connecting to data source test
  IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  Error connecting to data source test
  </code></pre>
  
  <p>What am I doing wrong?</p>