FAILED TO OPEN ROW SET Crystal report

Question

I use .NET 2003 and SQL server 2000 , and I created a windows applications to export report to excel sheet

It worked well on windows server 2000

when migrating to windoiws server 2003 and to SQL server 2005 , on the step of exporting it give error failed to open row set when close the message the report be created ,how to stop displaying this message or fix this problem

Best regards

Answer 1

When running an application to export  crystal report I got the follwoing error

Unhandled Exception: CrystalDecisions.CrystalReports.Engine.InternalException: E
rror in File C:\DOCUME~1\ali\LOCALS~1\Temp\1\temp_8b7deeee-5769-4457-8c1f-f21fa8
c49cb5.rpt:
Failed to open a rowset.    at ☻.☻N(String ♠-, EngineExceptionErrorID ♠0)
   at ☻.☻I(Int16 ♠!, Int32 ♠")
   at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestCo
ntext reqContext)
   at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
   at CMP_BL_INC_W.Module1.Main()

 

any suggestion to fix that , Also I verified the database and no errors appeared, I use .NET 2003 and crystal report 9