OpenOffice.org Base: Misreads "." in Database Names

Binary package hint: openoffice.org-base

This bug is recreated when using FreeTDS to connect to an SQL Server database with dots in its name.

In /etc/odbc.ini:
[some_definition]
Driver = FreeTDS
Description = ODBC connection via FreeTDS
Trace = No
Servername = some_TDS_definition
Database = dev.servername.com

The name of the hypothetical database is "dev.servername.com". Regarding this issue, efforts to contain the database name in square brackets [] and quotes "" invalidate the connection.

Using OpenOffice.org Base, we connect using the "some_definition" ODBC entry. The tables are loaded in under the following branches:

dev
-> servername
-> -> com.dbo.table1
-> -> com.dbo.table2

That is part one of the bug. Part 2 is if we try to right-click one of the tables and open them, it returns an error. Further investigation shows us the query that is used:

SELECT * FROM "dev"."servername"."com.dbo.table1"

The appropriate way to do this in SQL Server would be to write:

SELECT * FROM [dev.servername.com].[dbo].[table1]

Let me know if you need more information.