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

Getting Error: "Not enough memory. Unable to allocate buffer for row" when attempting a simple query

Getting error when running a basic query
select * from OPENQUERY(salesforce,'select * from AccountFeed')
results in:
"OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error: Error: Not enough memory. Unable to allocate buffer for row.".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "AccountFeed" from OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE".

Can query other tables fine.

DBAMP version: 2.13.6
No CLR Enabled
SQL Version: Microsoft SQL Server 2005 - 9.00.4262.00 (Intel X86) Aug 13 2009 17:08:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Other Linked Servers: Yes (11 total)

sf_vasQuery results in: insert into VASSnaps(TotalAvail, LargestBlock, MultiPage, CLR_Multi, CLR_VRes, CLR_VCmt) Values(49444,3584,20464,0,0,0)
1 person has
this problem
+1
Reply