PDA

View Full Version : Help on Resolving a Pervasive Error.

AJV
06-26-03, 10:15
When I try to execute a very large SQL statement I get the following error:

"SQL statement is too long. Maximum length is <nnn> characters."

Is there any configuration option in PCC or in ODBC Administrator to increase the maximum buffer of the SQL query.
jchapman
06-27-03, 15:39
At this time, It's not possible to stretch the max SQL statement size beyond 64K since these buffers are sized using a UINT16.

I know of no current plans to extend this limit. But if you contact our support folks and explain your requirements, they will forward your suggestions to the people who are planning future releases.
AJV
06-30-03, 03:49
Thnx jchapman... ;-)
Shawn Nelson
03-09-04, 11:30
I have a 37K OPENQUERY sql statement I'm running through SQL 2000 that fails when the number of OR conditionals is too high. The syntax is correct becuase it runs when a lessor number of OR conditions are chosen. Any suggestions? While the statement is below the documented 64K limit it still fails.

Thanks in advance.
Shawn
mirtheil
03-09-04, 16:24
Make sure you're running the latest HotFIx for 2000i. I remember hearing about a problem with 37 OR conditionals in a query.