INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...A lot of the information I've found at this site would've taken me forever if I'd have attempted to research it on my own. Thanks again."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Project and Data Management > Data Management Programming Tools > Informix solutions Forum

Parser stack gets full. Querying informix db using odbc connection.

Read More Threads Like This One

magarwal1908 (Programmer)

14 Mar 12 6:59

I made an ODBS connection to an informix database. While doing the load test for the db, it gives an error "not enough space for parser stacks" after ~12K insert queries. The control flow is: 1. SQLConnect 2. SQLAllocStmt 3. SQLSetStmtAttr 4. SQLBindParameter 5. SQLPrepare 6. SQLExecute 7. SQLFreeStmt 8. Repeat step 2 to 8

Therefore, a new statement handle is allocated for each query while all the queries are performed over the same connection. The exact error statement is:

37000:[Informix][Informix ODBC Driver]General error.Not enough space for parser stacks

Is it a known error? I am not able to locate any memory leak also. Increasing size of stack may end up causing the same problem after a larger number of 'insert' queries. Any suggestion?

Parser stack gets full even when I comment the statement SQLExecute and repeat rest of the steps as described above.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Informix solutions