Hi Bruce,
On 24.11.08 12:54, Bruce Denney wrote:
I have been unable to properly use the Sage 50 ODBC drivers with Open Office,
this has been an issue for many years.
I have managed to get someone in Sage (Darron Cockram) to have a look at the
problem and he seems to think, the issue lies in Open Office.
<QUOTE>I finally had a chance to investigate this a bit further at the end of
last week and I can report that the problem lies with Open Office and
not the ODBC driver.
I built a debug version of the ODBC driver DLL, set some break points in
the code and attempted to execute the query SELECT * FROM COMPANY. Even
though the error message was given none of the break points were hit,
not even those in the ParseSQL functions. This rang some alarm bells so
I ran process monitor to see what was going on and Open Office was not
loading or using the ODBC driver DLL when the error message was given.
Turning on the 'Execute SQL Directly' option in Open Office and
re-running the tests showed that the break points in the code were hit,
that the DLL did get loaded, and more importantly that no error was
given with the expected results being returned.
The conclusion that we can draw from this is that whatever the problem
is it must be within Open Office as the ODBC driver is not being loaded
or used when the error message is given. Fortunately the fix would
appear to be simply to turn on the 'Execute SQL Directly' option in Open
Office which I believe the customer has already discovered.
Any questions just let me know.</QUOTE>
I can confirm that executing the SQL directly does work this is the way I have
been working around this for the last few years, however, cutting and pasting
from MS Query to Base is not really a solution, it is a work around.
I would really love to be able to use the Base Query Wizard and it to work
properly and I am sure that you guys want that as well.
I have seen a few other posts that seem to have similar issues with other ODBC
sources, I am wondering if there is a more generic problem here and that
perhaps solving this issue might solve some elsewhere.
Would anyone like to have a go at this for me?
If you need ODBC drivers and sample data please ask.
Yes, could you please submit an issue and append the sample data and
driver (or a link) to that issue and assign it to msc, that would be
great. Thanks.
Best regards,
Ocke
PS: May be you could mention which OOo version you are using ;-)
---------------------------------------------------------------------
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]
