I've written an ext-stored-procs to interface SQL SRV 6.5 with Crystal
Reports For VC++ (ver 18.104.22.168). I use it to produce HTML and graphical
reports from my queries. You call it providing it with the name of a
crystal report file containing info on the report, the output filename,
and the type of file u want to produce (HTML, CSV etc.).
I always worked fine till I started to use it in a while cycle. It's
called about 60 times within the same batch (Standard Transact-Sql
launched from ISQL/W), It executes fine 40-50 times, produces the
required reports but then hangs: the "DB-Library Process Dead -
Connection Broken" messages appears, and sometimes even the SQLsrv
I used the standard ODS interface (Microsoft Open Data Services (ODS)
) to build the extended stored proc. Cut'n'pasted examples' code and
integrated with code of my own ( connection to the CR DLL) to biuld the
Is it a bug or is it my fault?????
It seems like something gets too stressed... and crash...
Thankx in advance...