title: SQLite installation problems
body: <p>I downloaded the binaries for windos for sqlite and extracted them. There were three files</p>
  
  <ol>
  <li><p>a shell</p></li>
  <li><p>dll</p></li>
  <li><p>analyzer</p></li>
  </ol>
  
  <p>when I try to run to create a database and a  table from the <code>sqlite</code> shell i get....</p>
  
  <pre><code>  SQLite version 3.7.8 2011-09-19 14:49:19
    Enter ".help" for instructions
    Enter SQL statements terminated with a ";"
    sqlite&gt; sqlite3 test.db
    ...&gt; create table tbl1(one varchar(10), two smallint);
    Error: near "sqlite3": syntax error
    sqlite&gt;
  </code></pre>
  
  <p>when I try to run to create a database and a  table from the <strong>command line(Vista)</strong> shell I get....</p>
  
  <pre><code>Microsoft Windows [Version 6.0.6000]
  Copyright (c) 2006 Microsoft Corporation.  All rights reserved.
  
  C:\Users\codenamejupiterx&gt;sqlite3 test.db
  'sqlite3' is not recognized as an internal or external command,
  operable program or batch file.
  
  C:\Users\codenamejupiterx&gt;
  </code></pre>
  
  <p>does anyone have any ideas?????</p>