title: JDBC/ODBC connection to Informix with Openoffice BASE on Windows 7. Will not show table lists
body: <p>I've attempted this with ODBC drivers, and JDBC drivers. I'll list both approaches separately.</p>
  
  <p>ODBC approach</p>
  
  <hr>
  
  <p>I'm using the ODBC driver found here: 
  <a href="http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2007-11-02+09%3A22%3A41.038818R&amp;S_TACT=&amp;S_CMP=" rel="nofollow">http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2007-11-02+09%3A22%3A41.038818R&amp;S_TACT=&amp;S_CMP=</a> </p>
  
  <p>It's the Informix Connect 32bit program. I've tried the 64bit version, stand alone it will connect, but the ODBC will not work with OpenOffice (32bit to 64bit issue). I've then decided to use the 32 bit version. </p>
  
  <p>After installing the ODBC driver, I used C:\Windows\SysWOW64\odbcad32.exe to setup the driver in windows 7, it connected successfully.</p>
  
  <p>Loading OpenOffice.org base I was able to use the ODBC to connect, but no tables are being listed. If I run a SQL query, I get this error: </p>
  
  <pre><code>SQL Status: HY106
  Error code: -11086
  
  [Informix][Informix ODBC Driver]Fetch type out of range.
  </code></pre>
  
  <p>JDBC approach</p>
  
  <hr>
  
  <p>I can't use design view, since no tables are listed. Abandoning this, I used the JDBC driver, found here: 
  <a href="http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-03-09+16%3A56%3A12.268164R&amp;S_TACT=&amp;S_CMP=" rel="nofollow">http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-03-09+16%3A56%3A12.268164R&amp;S_TACT=&amp;S_CMP=</a></p>
  
  <p>This was more successful, but I still can't get tables to list. Here's the errors I get when I run the OpenOffice.org BASE file:</p>
  
  <pre><code>WARNING
  SQL Status: 01I01
  
  Database has transactions
  
  ERROR
  SQL Status: 01I04
  Database selected
  </code></pre>
  
  <p>I don't understand how that would effect the JDBC so greatly. I can however execute SQL queries without a problem. I can't use design views. </p>
  
  <p>In the end, all I'm trying to do is have a useful GUI that I can build and debug queries with. If OpenOffice.org is a poor choice, I'm still open to other options. But the opensource prospects are ideal. </p>
  
  <p>Lastly, this isn't directly a programming question, is there a better forum I should be using?</p>
  
  <p>Thanks</p>