When using MS SQL Server to connect to NetSuite account via ODBC using a linked server, and the company name set in the account has a dot (.), this causes the schema to change the dot (.) to an underscore (_). To get around this, when creating ODBC queries, user can either enclose the company name in brackets (ex. [COMPANY NAME, INC_] ) or use OPENQUERY instead.
The (_) may also cause the error 'The table either does not exist or the current user does not have permissions on that table' when trying to query a table view with an underscore in it's name.
No comments:
Post a Comment