To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87383
Issue #|87383
Summary|ODBC adds extra spaces to SQL query
Component|Database access
Version|OOo 2.3.1
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|jrtapper
------- Additional comments from [EMAIL PROTECTED] Mon Mar 24 19:46:38 +0000
2008 -------
This is similar to issue 58318 (which was not really resolved) in that when I am
trying to query an ODBC database (in my case it is a Progress database)
additional space characters are being inserted into the query and causing the
query to fail.
I can successfully connect to the database and get a listing of all of the
tables and fields, the problem begins when I try to create a query.
The SQL query I am trying to run is:
select * from p21.customer
Where p21 is the database name and customer is the table name. There are
several other databases, so I need to specify the database name.
When I send the query, the error I receive is:
"The data could not be loaded
[Openlink][ODBC][Progress Server] ** Table P21 does not exist or cannot be
accessed (962) "
When I look at the query in the "more, information" tab of the error, the query
looks like this:
select * from p21 . customer
Notice the extra spaces in the table designation. I have tried to edit the
spaces out (using the "edit in SQL view") and I have tried quoting the table
name (eg. "p21.customer") and I get the same result every time.
I am not a SQL expert, but I know that this query works with this ODBC driver
from within the MS Query application. I understand from my ODBC driver vendor
(OpenLink) that there is some question as to the interpretation of the standard.
If there is a possibility of changing the way OO handles this situation, I
would be very appreciative.
Thank you.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
