--------------------------------------------------------------------
// Sample code for using an HFSQL database by ODBC
namespace ConsoleApplicationTestODBC
{
class Sample
{
public static void Main()
{
try
{
// Connection by using a DSN
// MyODBCDatabase is an ODBC data source defined with odbcad32
// OdbcConnection nwindConn = new OdbcConnection("DSN=MyODBCDatabase");
// Connection by passing the connections parameters directly
// ANA=<Full path of the analysis>
// DIR=<Directory of the files>
OdbcConnection MyConnection =
new OdbcConnection("Driver={HyperFileSQL};ANA=c:\test\\MyAnalysis.wdd;DIR=c:\test\\;");
// Open the connection
MyConnection.Open();
// Query that must be run on the database
OdbcCommand MyQuery = new OdbcCommand("SELECT * FROM MyFile", MyConnection);

// Execute query
OdbcDataReader MyData = MyQuery.ExecuteReader();
// Browse the result of the query
while (MyData.Read())
{
Console.WriteLine("\t{0}\t{1}", MyData.GetInt32(0), MyDatas.GetString(1));
}
MyData.Close();
MyConnection.Close();
}
catch(OdbcException eExcpt)
{
// Display the errors
Console.WriteLine("Source = " + eExcpt.Source);
Console.WriteLine("Message = " + eExcpt.Message);
}
// pause before exiting
Console.ReadLine();
}
}
}
--------------------------------------------------------------------