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 [email protected] 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
