title: does anyone know the format of an odbc connection string for vertica?
body: <p>I'm using the following:</p>
  
  <pre><code>DRIVER={Vertica ODBC Driver 4.1};
  SERVER=lnxtabdb01.xxxx.com;
  PORT=5433;
  DATABASE=vertica;
  USER=dbadmin;
  PASSWORD=vertica;
  OPTION=3;
  </code></pre>
  
  <p>i'm getting this error and I just wanted to make sure that my connection string was cool before I check other possible issues.</p>
  
  <p>error:</p>
  
  <pre><code>EnvironmentError: System.Data.Odbc.OdbcException (0x80131937): ERROR [28000] FATAL: no Vertica user name specified in startup packet
  </code></pre>
  
  <p>UPDATE:
  For now i'm just using a System Data Source Name in Windows Vista that I can use. But i'd still like to know if there's an odbc connection string so that i don't have to set that up on every machine that will be connecting to the Vertica DB in this fashion.</p>
  
  <p>well, I tried a postgresql connection string that looks like this:</p>
  
  <pre><code>Host=lnxtabdb01.xxxx.com;
  Port=5433;
  Database=vertica;
  User ID=dbadmin;
  Password=vertica;
  Pooling=true;
  OPTION=3;
  Min Pool Size=0;
  Max Pool Size=100;
  Connection Lifetime=0;
  </code></pre>
  
  <p>now i'm getting this:</p>
  
  <pre><code>EnvironmentError: System.Data.Odbc.OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  </code></pre>