I’ve successfully defined an x-node mapping schema to Tamino 4.4, pointing to a MSQLServer 2005 DB.
<tsd:subTreeSQL datasource=“Microsoft SQL Server:SqlServer” table=“Table With Spaces” userid="" password="">
However, when it comes to make a query to a table which name contains white spaces, I’ve got the error:
‘Incorrect Syntax near …’ , where … is a substring of table’s name.
If I rename the table, deleting every white space on its name, and then I update the Xnode schema (no further changes…!), there is no problem at all and the query is successful.
Xnode does not support queries to a table with such a name?