Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce"

I have a query that I am using to pull information from ContentDocument. After doing some digging in this forum and reading through the documentation, I see that the maximum amount you can pull back from a Base64 Salesforce field is 20,000,000 bytes. So I have that set in the DBAmp configuration area, and I've set up my org to not allow documents larger than that maximum. But when I run my queries I get this error:

Cannot fetch a row from OLE DB provider "DBAmp.DBAmp" for linked server "Salesforce"

I was able to track it down to documents that are over 1,400,000 bytes. So I'm wondering if I have some other configuration wrong in DBAmp or my SQL instance.

SQL Server 2016 64 bit
DBAmp Version: 3.3.4.0.

Thanks.
1 person has
this problem
+1
Reply