hi
Can any one help me out , m facing a problem with fetchrow_array , when using in perl code .
If i specify limit in my select query with limit 100 m geting proper and expected result but for limit 200 m getting below error , i think i need to increase the ODBC buffer size but m not getting how to do .....

What operating system is the client running on? I believe you may be looking for the ResultBufferSize parameter of the DSN? It sets the size of the memory buffer for the large result sets in streaming mode. Note: This parameter was previously called MaxMemoryCache.

Jim Knicely

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.