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

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 once
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 RemoveThis @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 once
>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.