crystal report exits on access MS-SQl server 2000 and 2005 with O

Setup details:
Crystal report : 8.5
Ms-Sql server 2000 and 2005
Crystal report uses MSSQL ODBC driver to get the data from database and
displays in crystal report. When i have large number of data the crystal
report exits after 1 hour. In the temp folder of windows file is created onc
e
it crosses 2 GB crystal reports exits.
Why i'am posting this issue here is the same size data i try to access from
sybase/oracle it works fine. So i thought it would be related to ODBC driver
.
Can somebody help me on this.You are really sending that much data across the network? I
would really, really, really look at changing that. Whether
in works in some scenarios or not seems beside the point.
But...if you want to check your MDAC version, you can
download the component checker from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Mon, 11 Sep 2006 23:39:01 -0700, Sanjeev Kumar <Sanjeev
Kumar@.discussions.microsoft.com> wrote:

>Setup details:
>Crystal report : 8.5
>Ms-Sql server 2000 and 2005
>Crystal report uses MSSQL ODBC driver to get the data from database and
>displays in crystal report. When i have large number of data the crystal
>report exits after 1 hour. In the temp folder of windows file is created on
ce
>it crosses 2 GB crystal reports exits.
>Why i'am posting this issue here is the same size data i try to access from
>sybase/oracle it works fine. So i thought it would be related to ODBC drive
r.
>Can somebody help me on this.