Solved

vb6 and crystal reports xi deployment (references and components)

Posted on 2006-07-18
25
3,834 Views
Last Modified: 2013-12-25
When I use package and deployment wizard there is no crpe32.dll created in the Support folder.
On deployment I get "The dynamic link library crpe32.dll cannot be found in the specified path c:\winnt;.;c:\winnt\system32 ........."
If I  select "ignore" then "error while registering crystl32" (probably as exspected)

I have tried manual copy of crpe32.dll into the support folder but this does not alter the error.
So I am presumably missing (or adding) something in the reference/components section.
The application is old fashioned (no web access)
 
Anybody help?
Regard
Keith
0
Comment
Question by:keith66miners
  • 14
  • 11
25 Comments
 
LVL 4

Expert Comment

by:jomacinc
ID: 17172948
Crystal Reports can have many dependancies, crpe32.dll is most likely just the first in a long list of files you are missing.
I find it best to create a MSI setup to distribute an app that uses Crystal Reports.

Download and Install Visual Studio Installer (this is free):
http://msdn.microsoft.com/vstudio/downloads/tools/vsi11/default.aspx

Download the crystal reports merge modules (also free):
http://support.businessobjects.com/communityCS/FilesAndUpdates/crXI_rdc_merge_modules.zip.asp

Extract the merge modules to the VSI "BuildRes" directory then create your installer using VSI.
0
 

Author Comment

by:keith66miners
ID: 17175394
jomacinc

Just "slight problem" over "then create your installer using VSI"
Never having used this before....
I get a window displayed with "Task List 14 tasks"
details of taks are:-
one or more files in MSVBVM60.MSM                           have different versions.....
                             CrystalReports11_RDC_Runtime.msm        ditto
                                                               Reportengine.msm   ditto
                                                               Designtime.msm      ditto
                                                               License.msm           ditto
                              MSFLXGRD.MSM                                      ditto
neither merge module nor dependancy information could be found for{filename}

If I click the checkbox alongside one of these lines then it draws a line through the detail (as though it will be ignored)

Should I save this VBInstaller2 file in a shared directory and then run it as though it were a "setup.exe" file produced by PDW  ?

0
 

Author Comment

by:keith66miners
ID: 17175437
sorry jomacinc,
forgot to ask - what should be done about the different version notes or can they safely be ignored?  
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17179996
Those notes can usually be ignored.

Save the VSI solution to a folder somewhere and choose "build" from the "build" menu, this will produce a .msi file in an "output" sub-folder. You can then copy the .msi file to a shared directory and run it like setup.exe
0
 

Author Comment

by:keith66miners
ID: 17182953
jomacinc,
I was right to "up the points"!
When running the build I got task messages
"the property 'SourceFile' of 'u2dpost.dll' is invalid
same for 'u2fsepv.dll' and 'u2fxml.dll'
and then each of the files reported as invalid - when the build eventually finished got "Solution update failed".
Double click on the task gives a list of dll in Application folder with these three underlined in red.
Items then deleted and rebuild run
Eventually finishing with "Solution update succeededl"
I identified the "VBInstaller5\Outout\Disk_1\project1.msi" file created and copied it - but no other files to a shared directory.
This then accessed from target box and run...........until
"Error 1904 crystl32.ocx failed to register HRresult -2147024770" reported
The first time this happened I aborted
Running through the process again same error and continue get the same error for craxddrt.dll
again continued and further error for craxdrt.dll

Now the Crystal Reports msm files were added under "Project -->Add Merge Modules" in the VSI process - so what's going wrong???

0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17183203
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17183208
I think the bigger issue here is the message:

"the property 'SourceFile' of 'u2dpost.dll' is invalid same for 'u2fsepv.dll' and 'u2fxml.dl'"

These files were detected as dependancies but could not be located, you should try and find them and make sure they are included in the install.
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17183222
0
 

Author Comment

by:keith66miners
ID: 17185090
These u2*.dll files are part of Crystal Reports
Having got the merge modules as requested from Crystal - you would think that they'd be there!
On the system I'd previously had version 4 of Crystal and u2post.dll still existed in \winnt\crystal (but the others don't)

So as I don't believe \winnt\crystal has anything to do with Crystal Reports XI (please contradict if yoy know otherwise!) - I have deleted contents of \winnt\crystal (all u2*.dll files)
But build process returns same errors

So should I review the project components and references?
Any hints of what there should NOT be - greatly appreciated
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17190088
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17190156
The old versions of crystal where never very good at uninstalling, crystal had a batch file to clean up after versions 5, 6 & 7 but I could not find one for version 4. It may be ok to use the one from version 5.

http://support.businessobjects.com/communitycs/FilesAndUpdates/uscr5_32.exe.asp
0
 

Author Comment

by:keith66miners
ID: 17193499
jomacinc,
OK slight error - a file was version 4.(6) but the main file was version8.
I have been onto businessobject support site and manually removed all the files it talks about (eg crystl32.ocx, p2sodbc).
And then I removed version xi (via cd first - but that didn't take it all out - so via control panel)
Then installed from scratch (which produced an error at the end of "Wrong Disk - please insert CR11_MLBENT_1 into drive).
Applied service pack 2 and latest merge files.
Running the build task in Visual Studio now gives even more files that 'sourcefile' is invalid!!!! (eg crdb_ado.dll, querybuilder.dll, u25dts.dll, u2dpost.dll etc)

Now I do have some of these files on the system in
program files\common files \Business Objects\3.0\bin

is there a search path required to be setup so that the build can find them?

What is going wrong?
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:keith66miners
ID: 17194373
Occured after I'd left for the day...
Another point - if u2dpost.dll is no longer available - is there a wayof removing it from my VB project as that is where the dependancy arises?
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17197204
You cant remove the file from your VB project as such, but you can remove it form the install solution.

When you say you "removed all the files it talks about (eg crystl32.ocx, p2sodbc)" did you just delete them, or unregister them first (should have been unregistered).
0
 

Author Comment

by:keith66miners
ID: 17199013
jomacic,
"how to manually uninstall crystal version xx" specifically states to :-
1. delete the following directories .............
2. delete the following registry keys ..........

I have done what they asked in the order specified - are you telling me they've got it wrong?
or is unregister something different?
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17205645
Removing the registry keys is what I was checking about:

also running: "regsvr32.exe /u crystl32.ocx"
0
 

Author Comment

by:keith66miners
ID: 17214205
that is a new process to me (as you probably gather from the following!)

I have run "regedit" from the DOS prompt - identified the relevant keys and deleted them

So do I still need to run the regsvr32 process (and is that from start & run) or DOS prompt?
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17214667
From a DOS prompt or Run dialog - either is fine.
0
 

Author Comment

by:keith66miners
ID: 17222583
Well I ran the regsvr32 process - but of courtse it failed as the files were already deleted!

I have uninstalled crystal reports xi and installed it again (didn't get the error about CR11_MLBENT_1 this time)
 Got up to date fixes amd msm's and rerun "build" - still getting 'the property of sourcefile for file xxxxx invalid"  

There is a question you didn't answer from 27th:-

Now I do have some of these files on the system in
program files\common files \Business Objects\3.0\bin

is there a search path required to be setup so that the build can find them?

0
 
LVL 4

Accepted Solution

by:
jomacinc earned 500 total points
ID: 17222679
All the merge modules should be in the VSI buildres folder:

"C:\Program Files\Microsoft Visual Studio\Common\Tools\VSInst\BuildRes\"

You can add additional paths but they only apply to the location of merge modules.
To add paths, go to menu "Project" >> "..Properties" and add them on the tab "Merge Module Search Path"
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17222686
Also, if the files are on your system, and you can find them - add them to your project manually.
0
 

Author Comment

by:keith66miners
ID: 17224209
Nearly there?
FYI I have removed the Crystal11_net*msm from the search path - it though up an error ".......being edited"!!!!!!

I have now got "Solution update succeeded" with no tasks.

Unfortunately I have retired from the customer site to "lick my wounds" - so I'm not in a position to try the actual deployment until 8th August
Can I leave the call open until then please?

Meanwhile thanks for all your help
Regards
Keith


0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17228935
I expect the 8th is fine, it has taken a long time to get here, but this is often the case with crystal installs, they either work first time or give you a never ending amount of trouble.

Regards, Jomac.
0
 

Author Comment

by:keith66miners
ID: 17285842
Very close!
I can now deploy, without any errors occuring during the process.
FYI - the trick that worked was the setting of the path in Project properties to include the Crystal merge modules - using project merge did not work - it left some tasks.

I can access the data from the target box, but I cannot print!
I get what appears to be a vb message
Run time error -2147206460(80043ac4)
Invalid directory

The vb source code established the report name as "c:\crwsource\xxx.rpt".
On the server box (peer to peer) the directory c:\crwsource is shared; on the target box
network directory "crwsource on Miners-boss (F:)"
Happy to raise this as a separate question if you think it's appropriate
0
 
LVL 4

Expert Comment

by:jomacinc
ID: 17285951
Glad you have made it this far...

I expect you will need to access the file with a path like:

\\ServerName\ShareName

But yes, I think the "Invalid Directory" error is best raised as a seperate issue.

Many regards, Jomac.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now