Page 1 of 1
Error when trying to Update Salesforce in SSMS as linked server
Posted: Thu 14 Oct 2021 19:23
by kacorace
OLE DB provider "MSDASQL" for linked server "SALESFORCE_64" returned message "[Devart][ODBC][Salesforce]SQLite error
parser stack overflow".
Msg 7343, Level 16, State 4, Line 13
The OLE DB provider "MSDASQL" for linked server "SALESFORCE_64" could not UPDATE table "[SALESFORCE_64]...[Opportunity]".
Re: Error when trying to Update Salesforce in SSMS as linked server
Posted: Fri 22 Oct 2021 16:12
by MaximG
Hi there!
Thank you for contacting Devart and for your inquiry!
We received the text of the implemented request which you have sent earlier and we are already investigating it.
We will inform you as soon as we have the results!
Re: Error when trying to Update Salesforce in SSMS as linked server
Posted: Thu 28 Oct 2021 17:21
by ryanc30
I also have the same issue. Any advice?
The select works correctly. The update gives the error.
Select * From [DYNAMICS365]...[account]
where name = 'Margaret Bruce (RGC Import)'
update [DYNAMICS365]...[account]
set websiteurl = '
[email protected]'
where name = 'Margaret Bruce (RGC Import)'
OLE DB provider "MSDASQL" for linked server "DYNAMICS365" returned message "[Devart][ODBC][Dynamics 365]SQLite error
parser stack overflow".
Re: Error when trying to Update Salesforce in SSMS as linked server
Posted: Tue 02 Nov 2021 16:16
by MaximG
Its appearance is associated with the peculiarities of the SQL Server Management Studio and we will try to find the necessary solution. Currently for changing the value of the websiteurl field you can use the following request:
UPDATE OPENQUERY ([DYNAMICS365], 'SELECT accountid, name, websiteurl FROM account WHERE name = ''Margaret Bruce (RGC Import)''') SET websiteurl = '
[email protected]'