[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 Alex Thurgood changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |INSUFFICIENTDATA --- Comment #18 from Alex Thurgood --- Per comment 17, closing as RESOLVED INSUFFICIENTDATA -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #17 from pekka.kor...@gmail.com --- I just spent a couple of hours trying to install MS SQL Server 2016 on a slow-as-molasses laptop and it was a no-go. I'm thinking that since this issue doesn't seem to bother anyone else we can just close this. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #16 from Lionel Elie Mamane --- (In reply to pekka.korkki from comment #15) > BTW, where do I find the advanced setting for anonymous parameters? I > glanced around but didn't find it yet. Edit / database / advanced settings / special settings / "replace named parameters with '?'" -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #15 from pekka.kor...@gmail.com --- I am still following this, but I haven't had the time to build a proper test environment and get the details. I ran a quick test at work with a newish (if not the latest) LibreOffice 5 on a Win7 64-bit against MS SQL Server 2008. The driver was ADODB something, as in not the Native Client or ODBC. The bug was still there. I ran the query with both the syntaxes documented in this bug ("col2" = :x vs. "col2" = ?). I'm hoping that I'll have the time to look into this during the weekend. BTW, where do I find the advanced setting for anonymous parameters? I glanced around but didn't find it yet. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #14 from Alex Thurgood --- Per comment 13, this is needinfo, but it seems that the OP is no longer following, as there has been no input from him/her since July 2015. @pekka : could you answer Lionel's questions in comment 13 please -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #13 from Lionel Elie Mamane --- This looks like the ADO driver (and/or the database itself) does not support named parameters. To use anonymous parameters instead, change the corresponding "advanced setting". What ADO driver to what database is used? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #12 from Julien Nabet --- (In reply to Lionel Elie Mamane from comment #11) > (In reply to Julien Nabet from comment #10) > > Lionel: Are these 3 points ok or some changes are needed or may help to have > > something homogeneous? > > Err... Could you give me a pointer to the exact code lines you are referring > to? Sorry, I forgot to tell I had put a comment before comment 10, so it's http://opengrok.libreoffice.org/search?q=substituteParameterNames&project=core&defs=&refs=&path=&hist (the different calls to substituteParameterNames) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #11 from Lionel Elie Mamane --- (In reply to Julien Nabet from comment #10) > Lionel: Are these 3 points ok or some changes are needed or may help to have > something homogeneous? Err... Could you give me a pointer to the exact code lines you are referring to? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 Julien Nabet changed: What|Removed |Added CC||lio...@mamane.lu --- Comment #10 from Julien Nabet --- treatment of parameters also differ in the other 4 DBs than ADO: 1) Use of std::unique_ptr in odbc not for others (why?) 2) delete pNode for all DBs except ODBC (why?) 3) For jdbc test m_bParameterSubstitution odbc, test isParameterSubstitutionEnabled (but this is an inline function which returns m_bParameterSubstitution) Firebird, no specific equivalent test common, test "xConnection.is()" (what does this mean?) Lionel: Are these 3 points ok or some changes are needed or may help to have something homogeneous? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #9 from Julien Nabet --- Just some thoughts: I noticed ADO part uses method OPreparedStatement::replaceParameterNodeName see http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/ado/APreparedStatement.cxx#458 JDBC, ODBC, Firebird, commontools use substituteParameterNames method defined here http://opengrok.libreoffice.org/xref/core/connectivity/source/parse/sqlnode.cxx#1493 See http://opengrok.libreoffice.org/search?q=substituteParameterNames&project=core&defs=&refs=&path=&hist= I thought first about trying to remove replaceParameterNodeName and replace it by substituteParameterNames but the treatment seems slightly different, eg "parame" name. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #8 from pekka.kor...@gmail.com --- (In reply to Julien Nabet from comment #7) > According to https://support.microsoft.com/en-us/kb/181734, the syntax seems > to be: > SELECT "col1" FROM "tbl1" WHERE "col2" = ? Thanks for the suggestion, but the change in syntax doesn't change the error messages (just tested it, same configuration as before). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #7 from Julien Nabet --- According to https://support.microsoft.com/en-us/kb/181734, the syntax seems to be: SELECT "col1" FROM "tbl1" WHERE "col2" = ? But perhaps I missed something since I don't know ADO. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 --- Comment #6 from pekka.kor...@gmail.com --- Did the test, still same results. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 68417] Parameterized query with ADO driver fails in query editor
https://bugs.documentfoundation.org/show_bug.cgi?id=68417 tommy27 changed: What|Removed |Added CC||ba...@quipo.it Summary|Other: Parameterized query |Parameterized query with |with ADO driver fails in|ADO driver fails in query |query editor|editor --- Comment #5 from tommy27 --- when you have some time give a try to LibO 5.0.0.5 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs