Wednesday, February 27, 2019

Effect of dot (.) in Company Name for ODBC Schema in SQL Server. Error: The table either does not exist or the current user does not have permissions on that table

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