[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 User clu changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Tue Jun 17 13:46:35 + 2008 --- outdated issue, last respond over a year ago, no repro - set to 'invalid' - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 User clu changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Tue Jun 17 15:50:20 + 2008 --- = close do not hesitate to reopen if still exist in current version thx - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 User mechtilde changed the following: What|Old value |New value Keywords| |needmoreinfo, oooqa --- Additional comments from [EMAIL PROTECTED] Tue May 6 13:11:59 + 2008 --- If http://www.openoffice.org/issues/show_bug.cgi?id=88987 is a duplicate of this issue, That confirms it - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 --- Additional comments from [EMAIL PROTECTED] Tue Jun 12 06:25:05 + 2007 --- I suppose QUANTEL has own tracing/logging facilities within their driver ... I could probably build a dedicated version of our ODBC bridge which does some very rudimentary logging itself, to at least observe the statements we send (to falsify or verify whether it's indeed OOo which sends this flawed statement). But this might take a while 'til I find the time for this. You do not, by chance, have a developer at hand which can spend a little time debugging this with our help? - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 --- Additional comments from [EMAIL PROTECTED] Tue Jun 12 14:22:41 + 2007 --- Somehow QANTEL was able to see the output of the OOo SQL statement and compared that with their own... therefore it seems reasonable to assume they were able to capture the OOo request somehow... but perhaps that capture was on the server end and not on the client making the request? Unfortunately, I'm it (one man shop, IT admin, and other duties) I'd love to help get this figured out / solved... please let me know how I might help. Doug - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 10:18:22 + 2007 --- Hmm - normally I'd say we do not issue such a statement ourself. We use an ODBC API call (SQLTables) to retrieve the tables list (this is what the statement tries to do). So this sounds as if the ODBC driver is flawed, which might be triggered by some parameter we pass to it (which would explain why it doesn't happen with other applications). Could you switch on logging in the ODBC driver (in the Control Panel), and attach the log (zipped) to this issue? This would perhaps allow to determine in which context the call is made, which would allow us an educated guess where the problem lies. Side Note: More information about the database you use (something from Quantel, I assume) could be helpful, too. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 15:07:35 + 2007 --- I have turned on tracing (can find no reference to logging...) through the ODBC Data Source Administrator... but nothing shows up when I try to use OOo... I do get a log when using Excel... FYI - by manually creating a query formatted as QANTEL suggested (copy paste their SQL statement) and it did succeed in retrieving data... but, again, no trace log was created... ??? Would you like to Crossloop into my machine to have a try yourself? Doug - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 19:49:51 + 2007 --- (yes, indeed I meant tracing, not logging, sorry) Hmm. Tracing works fine for me here, there's not much you can do wrong with this (the more since access via Excel creates the trace file). I'm clueless for the moment ... - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 20:30:35 + 2007 --- I, too, am befuddled. How might we go about trying to confirm the driver is the issue? How was QANTEL able to observe the SQL query from OOo they posted in their email? Thoughts? - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 77388] invalid SQL statement gene rated by open office
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77388 Issue #|77388 Summary|invalid SQL statement generated by open office Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dughutch --- Additional comments from [EMAIL PROTECTED] Tue May 15 11:48:16 + 2007 --- Issue reading tables through an ODBC driver, submitted question to Qantel support who appears to have diagnosed the issue. Would appear to be a simple fix (I am not a coder...;) Details below --Initial email-- To: Qantel - Technical Support Department Subject: Qantel ODBC connection works with Excel but having issues with Open Office I'm writing to inquire about utilization of the ODBC driver. It is installed and works with Excel (via the Query Wizard) but when attempting to set up through Open Office, although it allows me to set up the connection, and tests as connecting successfully, I seem to have no access to the data... Any ideas, please? --Initial email-- --Qantel Response-- The issue stems from an invalid SQL statement generated by open office. The statement: SELECT TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, TABLE_TYPE, REMARKS FROM OA_TABLES WHERE TABLE_NAME LIKE '%' AND (TABLE_TYPE LIKE 'VIEW' OR TABLE_TYPE LIKE 'TABLE' OR TABLE_TYPE LIKE '%' ORDER BY TABLE_TYPE,TABLE_QUALIFIER,TABLE_OWNER) is used to request a table list. Note the incorrect placment of the ) character that should be framing the precedence of the AND and OR WHERE conditions. The query should be: SELECT TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, TABLE_TYPE, REMARKS FROM OA_TABLES WHERE TABLE_NAME LIKE '%' AND (TABLE_TYPE LIKE 'VIEW' OR TABLE_TYPE LIKE 'TABLE' OR TABLE_TYPE LIKE '%') ORDER BY TABLE_TYPE,TABLE_QUALIFIER,TABLE_OWNER Qantel Support. --Qantel Response-- - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
