wtf666
asked on
Error while viewing CR10 Reports
Hi all.
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 .
************
Logon failed.
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.
Regerds
Ade
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 .
************
Logon failed.
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.
Regerds
Ade
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
which dll :$ mlmcc ??
also the setup of my code gives an error while registring the MDAC on clients machine so I ignore it and finish installation but I afaik if thats the reason ?
For these reports I am using nearly No Code.So the problem must be either a dll or MDAC.
Can you please some more light on this.
regards,
Ade
also the setup of my code gives an error while registring the MDAC on clients machine so I ignore it and finish installation but I afaik if thats the reason ?
For these reports I am using nearly No Code.So the problem must be either a dll or MDAC.
Can you please some more light on this.
regards,
Ade
ASKER
I thought if installing whole CR10 on clients PC for checking either it is because of something missing on the clients PC which I have not added?
Since you are using CR10, Crystal has merge modules to help ensure all dlls are distribuited
http://support.businessobjects.com/communityCS/FilesAndUpdates/cr10_rdc_merge_modules.zip.asp
mlmcc
http://support.businessobjects.com/communityCS/FilesAndUpdates/cr10_rdc_merge_modules.zip.asp
mlmcc
ASKER
i made all reports whn i had Cr9 installed on my system then i installed Cr10 later.
My Vb project reports were made in Cr9.when I uninstalled Cr9 then the reports were not opening shows that they were not updated to Cr10 automatically.
So i guess I should go with Cr9 for this project and download cr9 merge modules.
what to do after I download these merge modules ???
i downloaded the merge modules for Cr10 but the downloaded file was corrupt.Now i am downloading Cr9 merge modules.
Would Installing the Cr9 on clients PC remove this error I was receiving ?? or the only way is merge modules.
-Ade
My Vb project reports were made in Cr9.when I uninstalled Cr9 then the reports were not opening shows that they were not updated to Cr10 automatically.
So i guess I should go with Cr9 for this project and download cr9 merge modules.
what to do after I download these merge modules ???
i downloaded the merge modules for Cr10 but the downloaded file was corrupt.Now i am downloading Cr9 merge modules.
Would Installing the Cr9 on clients PC remove this error I was receiving ?? or the only way is merge modules.
-Ade
Installing CR9 should but you would have to leave it there and they in theory could modify your reports.
It would be better to build an installation package using the merge modules. I think the instructions are included with the modules.
mlmcc
It would be better to build an installation package using the merge modules. I think the instructions are included with the modules.
mlmcc
ASKER
mlmcc
i downloaded and tried both cr9 and cr10 merge modules but it says not a valid archive file and try downloading again.I guess i have some virus on my computer which is corrupting it or may be some other reason.
So the temporary option left is installing th CR9 on clients PC.I checked doing this on my PC and it works fine.I don't know how can a user modify the reports >? the reports are only in executable format through my Vb application not in the DSR or DCA format.
I am accepting your answer
Thanks & Regards
-Ade
i downloaded and tried both cr9 and cr10 merge modules but it says not a valid archive file and try downloading again.I guess i have some virus on my computer which is corrupting it or may be some other reason.
So the temporary option left is installing th CR9 on clients PC.I checked doing this on my PC and it works fine.I don't know how can a user modify the reports >? the reports are only in executable format through my Vb application not in the DSR or DCA format.
I am accepting your answer
Thanks & Regards
-Ade
ASKER
I installed the Cr9 on clients PC but it did not solve the problem :( and same error was comming.
Now I am again downloading Cr9 Merge modules to deploy them with the program setup.
should this work ?
-Ade
Now I am again downloading Cr9 Merge modules to deploy them with the program setup.
should this work ?
-Ade
ASKER
I am wondering why installing the Cr9 did not solve this problem on clients PC ? this should have solved the prblem if it was a dll missing problem.Also i simply installed the Cr9 and before that I removed the Crystal folder from the common files dir.
I did not reinstalled the Vb application after installing Cr9. does ths make any difference ? to reinstall the application after installing Cr9.Do i need to clean up some registry values too ?
I my development PC wen i installed the Cr10 while i had Cr9 reports in my application.I had to remove all entries from the registry and then un-install the cr10 and reinstall the cr9 to work in my cr9 appluication.In this process I was missing one thing i.e. not deleting the crystal decisiopn bin folder from the common files.This was giving ,me qvery executer error.This is just for reference cuz I am confused as what I am doing wrong in above senario.
Plase help
Regards.
-Ade
I did not reinstalled the Vb application after installing Cr9. does ths make any difference ? to reinstall the application after installing Cr9.Do i need to clean up some registry values too ?
I my development PC wen i installed the Cr10 while i had Cr9 reports in my application.I had to remove all entries from the registry and then un-install the cr10 and reinstall the cr9 to work in my cr9 appluication.In this process I was missing one thing i.e. not deleting the crystal decisiopn bin folder from the common files.This was giving ,me qvery executer error.This is just for reference cuz I am confused as what I am doing wrong in above senario.
Plase help
Regards.
-Ade
On the client PC did you do a full or complete install?
mlmcc
mlmcc
ASKER
mlmcc:
I installed the C9 on client PC. what you mean be a complete or full install i don't get it.
I selected the typical install and waited till every things gets installed on his PC.
The install was same as i installed it on my development PC .... is it fine ?
-Ade
I installed the C9 on client PC. what you mean be a complete or full install i don't get it.
I selected the typical install and waited till every things gets installed on his PC.
The install was same as i installed it on my development PC .... is it fine ?
-Ade
If that is how you installed on your PC it should be fine.
There are several features of Crystal that don't install on a TYPICAL installation. I thought one of them might be what you needed but if you installed using TYPICAL on the development machine that should be what you need.
>>what you mean be a complete or full install i don't get it.
At least when I have installed CR8 at one point during the installation I get a screen which asks Complete (gets everything), Typical or Custom (allows you to pick and choose).
mlmcc
There are several features of Crystal that don't install on a TYPICAL installation. I thought one of them might be what you needed but if you installed using TYPICAL on the development machine that should be what you need.
>>what you mean be a complete or full install i don't get it.
At least when I have installed CR8 at one point during the installation I get a screen which asks Complete (gets everything), Typical or Custom (allows you to pick and choose).
mlmcc
ASKER
I have included the Cr9 merge modules msm files in my projct setup made througg install shield.Have not yet tried it on clients PC as i don't know if this is the reason or its MDAC causing error.
How can i find out that which dll is missing on clients computer which is causing this error or is this MDAC error . I have installed MDAC 2.8 on my dev PC and should i try installing this on clients PC as well seperately ?
Thanks alot
-Ade
How can i find out that which dll is missing on clients computer which is causing this error or is this MDAC error . I have installed MDAC 2.8 on my dev PC and should i try installing this on clients PC as well seperately ?
Thanks alot
-Ade
This dependency walker will identify the require dlls then you can check which ae missing
http://www.dependencywalker.com/
mlmcc
http://www.dependencywalker.com/
mlmcc
ASKER
great!!! ... Going through it...
I really appreciate & admire your help alot in CR section.
-Ade
I really appreciate & admire your help alot in CR section.
-Ade
ASKER
isn't it tough to learn and use this new software for the problem i am facing.I am thinking of increasing the points?
-Ade
-Ade
ASKER
I used Install shield Express project assistant and for dependencies i used its installation designer.I first scanned my vbp project file through visual basic project Scan wizard option then additionaly just to be on the safe side I used the wizard which detects all dll's being loaded and all dependency being found while running my application on development PC.I also included CR RDC merge module packages in setup.All msm.
This worked & Solved the problem
Thanks & Regards
-Ade
This worked & Solved the problem
Thanks & Regards
-Ade
ASKER
New problem ::
The reports are just working fine but the user has reported me a new problem.
PROBLEM::
while viewing one report which fetches data from DB based on parameters he selects, the report fetches the data correctly but its scroll bar is gone very slow. i.e. when he pulls the scroll bar down or up with his mouse its very slow. How come this happend and i have seen this same problem in my Development PC.
any suggestions... more then welcome.
-Ade
The reports are just working fine but the user has reported me a new problem.
PROBLEM::
while viewing one report which fetches data from DB based on parameters he selects, the report fetches the data correctly but its scroll bar is gone very slow. i.e. when he pulls the scroll bar down or up with his mouse its very slow. How come this happend and i have seen this same problem in my Development PC.
any suggestions... more then welcome.
-Ade
I haven't experienced anything like that. I'll look for an answer
mlmcc
mlmcc
mlmcc