Issue 12742 - data source view - The data content could not be loaded
Summary: data source view - The data content could not be loaded
Status: CLOSED DUPLICATE of issue 21300
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: Sun Solaris
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-27 18:42 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-03-27 18:42:57 UTC 
After setting up a Sybase data source, I go to View - Data Sources and expand
the view for tables and it lists the known objects which appears to be correct.
If I try to expand one of the tables I get the error:

The data content could not be loaded.

"gmsdev"."dbo"."budget" not found.

I looked at the SQL that got sent to the Sybase server, and it actually
contains the quote marks and appears to be causing the failure.

I included jconn2.jar in the class path and have the JDBC driver class set
to com.sybase.jdbc2.jdbc.SybDriver.
Comment 1 Frank Schönheit 2003-07-25 19:20:23 UTC 
changing sub component
(http://www.openoffice.org/issues/describecomponents.cgi?component=database%20access)
and default owner
Comment 2 marc.neumann 2003-11-12 14:55:11 UTC 
hi,

We (OOo database access) quote all parts of a table name ( catalog,
schema, tablename ) if quoting is allowed by the datasource metadata.
If the database doesn't understand the quoting it's not iur fault.
Maybe you can get a new driver the database vendor which fix this
behaviour.

So, sorry but we can't fix this issue, however thank you for
supporting the community.

Bye Marc
Comment 3 marc.neumann 2003-11-12 15:46:58 UTC 
reopen
Comment 4 marc.neumann 2003-11-12 15:47:24 UTC 
duplicate to issue 21300

*** This issue has been marked as a duplicate of 21300 ***
Comment 5 marc.neumann 2003-11-12 15:47:39 UTC 
close
Comment 6 hans_werner67 2004-02-02 12:18:15 UTC 
change subcomponent to 'none'