The server is 64 bit and client is 32 bit...  I tried the select * from table on the server and the query worked...
but I am puzzled why it does not work on the 32bit machine.  I had always thought that a 32bit machine could access up to 4GB.
So what is the limiting factor ?



On 8/31/2011 8:57 AM, Scott Ribe wrote:
On Aug 31, 2011, at 9:51 AM, Don wrote:

Both machines are 64bit.
Are all your server & client builds 64-bit? 

32M rows, unless the rows are <50 bytes each, you'll never be able to manipulate that selection in memory with a 32-bit app.