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

    • How to Work in Power Query Using ODBC Driver

      1. Connect to an ODBC Source In Power BI Desktop, go to the Home tab and click on Get Data to connect to an ODBC source. From the list of available connections, select the DSN connection that you created in the ODBC Administration tool. You can learn ...

    • 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 ...

    • ODBC Driver For InterBase. Error:"Cannot load client library: <path libs>

      This error may indicate that the driver cannot locate the specified Client Library or that the library's bitness does not match the DSN's bitness. The Devart ODBC Driver for InterBase interacts with the server through the client library using a ...