[Libreoffice-bugs] [Bug 117800] [FreeTDS][SQL Server]Incorrect syntax near 'Database-Name'.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117800

--- Comment #13 from Vegard Vesterheim <vegardv at uninett.no> ---
I am now using Libreoffice version 6.0.7.3

Using ngrep to capture some network packets when running query from within
Libreoffice gives the following:

  ... "Cable" FROM "TM_DB"."dbo"."Mytable" AS "
  ... Incorrect syntax near 'TM_DB'

Running a similar query directly with isql returns a similar error message:

   SQL> select "cable" from "TM_DB"."dbo"."mytable";
[37000][FreeTDS][SQL Server]Incorrect syntax near 'TM_DB'.

Removing the quotes from the query works fine in isql:
select "cable" from "TM_DB"."dbo"."mytable";

   SQL> select cable from TM_DB.dbo.mytable;

So, it seems the problem is related to the handling of quoting in SQL
statements.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201102/c718add5/attachment.htm>