Crystal Report executes slowly on vb.net app using OLE DB
Posted on 2006-11-15
I'm working with vb.net and created crystal report, using ole db provider. Data source for this report is stored procedure built in sql server 2005. Executing report takes about 30 sec, but stored procedure executes in one sec in Database Engine Query (result of procedure is set of 1600 records). When i switch report datasorce to ODBC, report executes in 3 seconds. It doesn't seem to me normall, but that is fact.
If someone know what is problem, please help me. I prefere ole db and would use it, it's newer than odbc.