Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

[tdf-discuss] Re: A failed query to ODBC data source


Le 17/08/11 16:30, Terrence Enger a écrit :

Hi Terry,

The problem is the message "The data content could not be
loaded." when I include a particular field from a particular
table in the select list of a query.  The curious
specificity is that I can with success include char() of
that field in the select list, and I can include the field
in the where clause or the order-by clause.  If I create
another table and from the same SQL DDL and DML statements,
LibreOffice has no problem.  On the other hand, the problem
is again evident with a table which I create with (please
pardon jargon specific to the IBM i) CRTDUPOBJ.

Is your field perchance being flagged as an <OBJECT> ? As I recall,
neither OOo nor LibreOffice could handle ODBC Objects (e.g. BLOB, IMAGE
fields and other OBJECT type fields) via the SDBC-ODBC bridge. Using
string functions like char() might well work because the type would be
recast into one that the SDBC-ODBC bridge could handle. However, I do
remember there previously being problems with DB2 ODBC drivers.



It hurts to give up on a problem, but there is the
possiblity spending a lot of effort with the only result
being a more specific failure message, along the lines of
"You gotta upgrade your remote server to a supported version
of the O/S" or "Please lobby IBM to fix their ODBC driver".

Have you searched to see if anything is in the old OOo dba mailing list
archives on this topic ? I suppose you could always try canvassing
someone from IBM over at the Apache-OOo project, but they might just
tell you to use the JDBC driver instead.

I don't think there are many db2 users on this list, or even on the
users list.


Alex





-- 
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.