Error while viewing CR10 Reports
Posted on 2004-10-11
I have made two sets of same reports using Cr10 in VB6.The one set of reports uses a DSN say ABC and the second set of reports using the second DSN say DEF.
I ask the user on the software startup that which companies accounts he wants to manage.Based on his choice I simply open the correct report . Both sets of reports have been hard coded the queries and the DSN in VB data environment.
The application works perfectly fines on my development PC i.e. it opens the right set of CR10 reports besed on the user choice but on the clients PC it gives this error .
Detalis: ADO Error Code: 0x80040e21
Source : Microsoft OLD DB Service Components
Descripton: Multiple-Step OLE DB operation generated errors.Click each OLE DB status value , if available.No work was done.
Then if we click the refresh button the report some times brings the data and shows it in CRVIEWER.and some times when the user clicks OK to the Error then it simply terminates whole VB application.
I don't understand this.As its working fine on my PC.
I have choosed the Database type to OLE DB (ADO) while seklecting the reports queries from Database expert.