Hi,
I’ve successfully defined an x-node mapping schema to Tamino 4.4, pointing to a MSQLServer 2005 DB.
xs:schema...
…
<tsd:subTreeSQL datasource=“Microsoft SQL Server:SqlServer” table=“Table With Spaces” userid=“” password=“”>
tsd:primarykeyColumncol1</tsd:primarykeyColumn>
tsd:primarykeyColumncol2</tsd:primarykeyColumn>
</tsd:subTreeSQL>
…
</xs:schema>
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?
Best Regards,
Pablo Naveas.