title: 64-bit DBeaver can't connect to ODBC source - "Parameter number out of range."
body: <p>I have a program on a server running Pervasive SQL.  I can connect to it via an ODBC connection running the Pervasive ODBC connector.  In the Windows ODBC Manager(s) I can create sources and connect in both 32-bit and 64-bit. (Test Connection is successful).</p>
  
  <p>In DBeaver 32-bit I can connect to this data source with no problem; but the latest version of DBeaver is 64-bit only. They no longer make a 32-bit version.  So... I need to get 64-bit working.</p>
  
  <p>When I create the connection in the 64-bit version of DBeaver, pointing to the 64-bit ODBC connection I created and tested earlier, I get the following error:</p>
  
  <p><code>[PSQL][ODBC Client Interface]Parameter number out of range.</code></p>
  
  <p>I have no idea how to make this connection work. Either there's a bug in 64-bit DBeaver or I'm doing something wrong.  It's <em>not</em> an architecture mismatch, as best I can tell.  When I create the 64-bit source in Windows, the Test connection is successful.  But 64-bit DBeaver refuses to connect to that 64-bit ODBC source.</p>
  
  <p><strong>UPDATE:</strong>
  @mirthiel 's answer is correct, except you have to add <em>three</em> driver files: <code>pvjdbc2.jar</code>, <code>pvjdbc2x.jar</code>, and <code>jpscs.jar</code></p>