Moin Tim Young,
Tim Young wrote:
We develop a database engine for Windows called ElevateDB, and one of our
customers contacted us regarding using OpenOffice with the ODBC driver
that
we provide for the ElevateDB. The problem is that we can get
OpenOffice to
connect, list tables, etc. just fine, but viewing the tables in the
grid via
the Open right-click menu results in less-than-accurate results.
Sometimes
there are blank rows, and sometimes there are missing rows, etc., but not
with all tables. Some tables display just fine. There really isn't any
rhyme or reason to it.
What I am looking for is access to the developer(s) that is/are
responsible
for the ODBC connectivity and how it relates to the grid view of
tables in
OpenOffice.
You found him ;-)
First of all OOo 2.3.1 is old. Did you try OOo 2.4?
I need to find out what OpenOffice expects in terms of the
SQLFetchScroll calls to the ODBC driver, because right now our driver is
obviously not responding in a way that OpenOffice expects it to.
However,
our driver is written *exactly* to the ODBC 3.x spec for the
SQLFetchScroll
behavior, and works just fine with VB in terms of scrollable,
bi-directional
cursors (it supports first, last, next, prior, relative, and bookmarks).
For example, one thing that I've found is that OpenOffice ignores the
fact
that our driver tells it that it doesn't support absolute fetches, yet it
goes ahead and calls SQLFetchScroll with SQL_FETCH_ABSOLUTE as the
FetchOrientation.
Yes, I see that we don't check the CA_ATTRIBUTES1 for CA_ABOSULTE.
On the other site it is difficult to implement absolute on your side?
I've tried looking at the OpenOffice source code to figure out what is
going
on, but I can't find the applicable grid code as it relates to the
navigation and population of the rows.
The drivers is located in connectivity/source/drivers/odbc and the grid
is filled from a rowset in dbaccess/source/core/api/RowSetBase.cxx which
itself uses a cache to read the data.
May it also possible for you to implement the necessary changes in the
ODBC driver in OOo. That would be really great.
Best regards,
Ocke
Thanks,
Tim Young
Elevate Software
www.elevatesoft.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
