I´ve several Crystal Reports documents that retrived a lot of data (+/- 40000 records each query).
If I use the querys in the query analizer everything went fine and there´s no problem. but when I use the query in the crystal report it give me always the same error:
"Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC SQL Server Driver] Timeout"
I already extended the ODBC Conected timeout to 0 and the ODBC DNS to 0 but the problem still presist.
Thus somone have any idea how can I resolve this problem?
try giving timeout = 0 in crystal report .
u can do this when u execute cr from cr designer. During the stage when it asks u username/passwd, there are some set of parameter on the next page.
if u see clearly , u can find an option of timeout.