Cannot open table ‘Case’ and’ Order’ in SSMS with ODBC Driver for Salesforce:

Cannot open table ‘Case’ and’ Order’ in SSMS with ODBC Driver for Salesforce:




Please also note another peculiarity when working with SQL Server Management Studio.
Regular queries executed in this tool will be processed by the SQL Server's own syntax parser.
After this analysis, the query actually executed by the provider may differ significantly from the original query.
For example, consider the "Order" table.
To successfully retrieve data from a table with a reserved word as its name, you need to execute the following query:
SELECT * FROM [Order].
When executing the query SELECT * FROM [SALESFORCE]...[Order] in SQL Server Management Studio,
the parser transforms it into SELECT * FROM Order, which is incorrect. This fact is the source of numerous errors.
To execute the query without changes (using the SQLExecDirect ODBC function) in SQL Server Management Studio,
you can use the OPENQUERY or EXEC operators:

SELECT * FROM OPENQUERY([SALESFORCE], 'SELECT Columnname1, Columnname2 FROM [Order] WHERE Columnname = ''your_value''')


    • Related Articles

    • SQL Complete tabs (SSMS)

      You may change settings for your tabs layout using these settings: In case you need to create custom tab names, please use this tab: You may find more information with tutorials in our documentation: ...

    • ODBC Driver for QuickBooks

      Currently, Devart ODBC Driver for QuickBooks supports only the QuickBooks Online platform however our team is working on the possibility of implementing the compatibility with other QuickBooks products.

    • Can I use the odbc driver in Power BI Online?

      However, I am encountering an issue with data updating in the cloud via Power BI Gateway. Despite the smooth operation in Power BI Desktop, the data does not seem to update as expected when using the cloud service. Do you have any documentation or ...

    • The odbc-driver uses a large number of calls API Zoho Credits

      Our driver uses the minimum possible amount of API credits for operations on Zoho data. The number of API credits consumed by each operation is determined by the Zoho API for specific tables, field types, etc. There are several reasons for the ...

    • Dump file for SSMS

      In order to generate and send us SSMS dump file- please follow the steps below: 1. Reproduce the issue. 2. Invoke Task Manager (Ctrl+Alt+Del). 3. Switch to the 'Details' tab in Task Manager. 4. Right-click the 'ssms.exe' process and select 'Create ...