Internal Query processor Error

Hi All,

When I try to Pass a Large Query to SQL Server from my font end
Application - Using ADO - I get error message:

Error: Internal Query processor Error: The Query processor ran out of stack
space during query optimization.

What may be the problem for the above error message and How can I resolve
that.

Note: My query will be large: Becuse My Application Interacts with another
application and Gets some value - That values need to pass to SQL Server and
that values has to use in IN( ) condition to retrieve records from one
table.

Thanks in Advance for any Suggestion or Help
Prabhat


.

Relevant Pages

  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: Mysterious Port of SQL Server not shown by netstat
    ... My query analyzer failed to connect to my sql server when I said ... The error message was SQL Server does not exist or ... TCP/IP and Named Pipes. ... So how can the second computer query my machine unless TCP/IP was ...
    (microsoft.public.sqlserver.programming)
  • Re: Finding a line number
    ... How can I find out what line in the query is causing ... the error message and be taken to the troublesome line. ... Unfortunately, though, SQL Server's reporting of line numbers is often ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Background Web Queries flaws!
    ... There is no way to trap errors on a background query. ... There is no way to control the timeout setting. ... The basic problem is that IE spits an error message before returning control ... > hard coded a 5 minute limit into the web query system. ...
    (microsoft.public.excel.programming)
  • Re: Update Query only works first time
    ... I don't know either -- but that is what you error message says -- perhaps you are not using an updateable recordset or records were locked by something else like a form or query ... Microsoft Access MVP 2006 ... It works the first time, but then there is a very long error message with several reasons why it does not work. ...
    (microsoft.public.access.queries)