_sqlsrv2.exe and Maximum # Queries

Josephus32

New Member
Hi - I am wondering if there is a maximum number of queries that can be thrown against a single sqlsrv2 process. I am pushing hundreds of select statments through a single ODBC/ADO connection (SQL92/Progress 9.1D) and it appears that when the 970th select statment is passed, the sqlsrv2.exe unwinds and writes a protrace file:

<protrace begin>

//=====================================================
PROGRESS stack trace as of Wed Feb 22 14:15:24 2006
//=====================================================

Exception code: C0000005 ACCESS_VIOLATION
Fault address: 0003764C 635BDBA8:00131378

Registers:
EAX:35373135
EBX:00000000
ECX:35373135
EDX:554A5350
ESI:35373135
EDI:62980870
CS:EIP:001B:0003764C
SS:ESP:0023:635BE36C EBP:627ED6F0
DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010206

Call Stack:

Address Frame
0003764C 635BE368 0000:00000000

004A7FF9 627ED6F0 tpe_print_sqlda_var+421C9
625F3C6C 625F3CCC 0000:00000000
627ED6F0 625F3C0C 0000:00000000
625F3CCC 625F3CFC 0000:00000000
625F3C0C 625F2A6C 0000:00000000
.
.
(...ad infinitim)

<protrace end>

I've searched through progress documentation, the KB at progress.com, etc. and found nothing related. Any help is appreciated!
 
Top