Setup

To use the ODBC driver on HFSQL, configure the ODBC driver:

1. Start the ODBC data administrator (ODBCAD32.EXE) on your computer. To do so, select "Start .. Run" from Windows and type "ODBCAD32.EXE".
2. Select the "User database" tab.
3. Click the "Add" button.
4. Select the "HyperFileSQL" driver.
5. Click "Finish".
6. Enter the name of the HFSQL data source. This name will be used to identify the HFSQL database in the external programs.
7. Click the "Details" button.
8. Click "Browse" to select the WDD file corresponding to the analysis.
9. In the list of analyses, select the requested analysis and the directory of the data files ("Browse" button). All the HFSQL data files corresponding to the selected analysis are grouped in this directory.
   Caution: a file directory must be selected for each analysis.
10. Confirm ("OK" button).

Using the ODBC driver on HFSQL from your Java program

1. Define the driver used. For example, with the following line of code:
   
   // Use the JDBC driver of Microsoft
   Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
   // Use the JDBC driver of Sun
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
2. Define the URL on the system ODBC connection ("hfodbc" for example):
   
   String jURL = "jdbc:odbc:hfodbc";
   // Connection
   Connection Contact = DriverManager.getConnection(jURL, "<user>", "<pass>");
3. Interrogate the HFSQL database in SQL. For example:
   
   // Creates a query
   Statement jQuery = Contact.createStatement();
   // Run the query and retrieve ...
   ResultSet Result = jQuery.executeQuery("SELECT * FROM CUSTOMER");
   int jColumn = 5;
   int jRow = 3;
   ResultSetMetaData jMetaData= Result.getMetaData();
   for (int i=0;i<jRow;i++)
   Result.next();
   System.out.println("Column name: " + jMetaData.getColumnLabel(jColumn));
   System.out.println("Value: " + Result.getString(jColumn));
   Result.close();
   jQuery.close();
   Contact.close();