I have had success using ODBC with Word and Access.

But I have not been able to make it work with OpenOffice (1.1).  Is another ODBC driver needed for this, or is there a setting I am overlooking?  I can see the ODBC Data Source, but cannot seem to completely connect.  When opening the Customers table of data, I get an error message that "invalid descriptor index, SQL status 07009."

Additional info is: "You tried to set a parameter at position 1 but there is/are only 0 parameter(s) allowed. One reason may be that the property "ParameterNameSubstitution" is not set to TRUE in the data source."

I cannot find any ODBC settings for this property.

When I look at Tools, Options, DataSources, Connections, I have about 15 ODBC connections listed in the pool, but the Sesame ODBD is not there.  Do I need to add it to this pool, and if Yes, how to do that?  I used ODBC and selected 60 seconds to enable Sesame pooling, but Sesame still does not show up here.

Or does OpenOffice use another technology to link to Sesame, like JDBC, ADO, Adabas D, or something else?

I also get the same error message if I try to use a Saved Query that includes all fields. 
(SQL = SELECT * FROM "Customers" "Customers"

If I add a single field to the query in addition to accepting all fields, I get different error messages:
SQL Status 42000, and ErrorCode 1015.  More information: "[Lantica, Inc][Sesame ODBC Driver]Expected lexical element not found: FROM"
(SQL=SELECT "Customers".*, "Customers"."Company" FROM "Customers" "Customers")

If I only select one field, I can retrieve all of the records, but when trying to merge get message that "DataSource cannot be found", even though I can step through the records in the Query window.  (SQL=
SELECT "Company" FROM "Customers" "Customers" WHERE ( ( "Company" IS NOT NULL ) ) ORDER BY "Company" DESC)

When making the queries, at least I can see the fields when I use the Query Designer.