[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