CRPE32.DLL can not load and ActiveX component can't create object error.

[evassilia]

Hi Everyone,

Here's my problem:

I have created a Visual Basic 6 program for one of my clients. I created a setup.exe using the package and deployment wizard. When I copied and executed the setup.exe file and installed my program on the clients machine everything works ok except for when I try to open up a link which is suppose to call one of the Crystal reports at the following line:

Dim objStatus
Set objStatus = CreateObject("PrintRep.clsPrintRep")

I get the Runtime error 429 ActiveX component can't create object.

So I figured ok maybe it has to do with some dependency of the Crystl32.ocx and I started to check all of its dependencies. I ran into crpe32.dll and noticed that the version on my developing machine was higher then the version on the clients machine. Without thinking twice I deleted the crpe32.dll on the clients machine and copied over the crpe32.dll from the developers machine in hopes of registering it through regsvr32.... And all hell broke loose I can not register the crpe32.dll no matter what and I dont have the Crystal Reports 10 CD to repair it...

I'm all out of options and freaking out a little bit.

Any suggestions, insight or help would be greatly appreaciated.

Thank you.

Regards,

Irena.

[evassilia]

so no one really knows anything about this i take it.

thanks.

[brucevde]

crpe32.DLL is not an ActiveX DLL, there is no reason to register it. Check the crpe32.dep file for its dependancies.

[evassilia]

OH ok, thanks alot the reason I thought that I had to register it is because I can't register my Crystl32.ocx .

I'll check the dependencies for the crpe32.dep file now. Thanks for the help.

[RobDog888]

You are missing dependancy files for CR.
What version of crystal?

[evassilia]

Crystal Reports version 10.

[evassilia]

I have checked the following dependency files and they are all in C:\Windows\system32\:

ADVAPI32.DLL
COMCTL32.DLL
COMDLG32.DLL
CRPE32.DLL
GDI32.DLL
IMPLODE.DLL
MFC32.DLL
MSVCRT.DLL
MSVCRT20.DLL
OLE32.DLL
OLEAUT32.DLL
OLEDLG.DLL
OLEPRO32.DLL
USER32.DLL
VERSION.DLL

... what am i missing?

Thanks.

[RobDog888]

Doesnt 10 use Merge Modles?

With previous versions the dependancies were dependant upon your code and references.

[evassilia]

Yes I think it does use merge modules... the vb6 project doesnt reference any crystal report dll's or ocx's though. And I know this project has been installed on another clients computer so it cant be because I have no references in the vb6 project...

This is a big problem now...

[RobDog888]

But if this is a new setup project then you need to include or distribute the merge modules too. The merge modules include the dependancy files.

[evassilia]

Oh ok, how do i find where these merge modules are located???

Thanks.

[evassilia]

could it be something else other then the Crystal Report dlls or ocxs????

[RobDog888]

Depends on what code you are runing but if you are not distributing all the dependancy files that are needed for your code then its possible its a missing CR dependancy file(s).

Do you have any error handling in your app?

[evassilia]

I think i've discovered that the activex error has nothing to do with crystal reports, i put in the following code:

Set objSplash = CreateObject("Splash.clsSplash")

It seems as though I cant create any activex objects period?

Please help.

Thanks.

[evassilia]

Yes I do have error handling and when it goes into the ErrorHandler it gives me the ActiveX component cant create object modErrorHandler module..

And I think it actually gives me an error inside the errorhandler at the following line:

Set objError = CreateObject("ErrorHandler.clsErrorHandler")

Thanks.

[si_the_geek]

Set objSplash = CreateObject("Splash.clsSplash")

It seems as though I cant create any activex objects period?

Have you actually installed, and thus registered, the object "Splash" (which I presume is a DLL)?

[randem]

It's ALWAYS the simplest answer that elude everyone... You have not deployed all the ocx/dll/exe files that you need...

PDW can't help you if and will not create a good setup if there is no .dep file for the file systems you deploy... PERIOD!!!

[evassilia]

In my vb project I dont have any Crystal Reports Reference, these are my references as follows:

Visual Basic For Applications
Visual Basic runtime objects and procedures
Visual Basic objects and procedures
OLE Automation
Microsoft Scripting Runtime
stsTools
Accpac Session Manager 1.0
Microsoft ActiveX Data Objects 2.8 Library
Microsoft Excel 12.0 Object Library
Accpac COM API Object 1.0

Components:

Microsoft Masked Edit Control 6.0 (SP3)
Microsoft Tabbed Dialog Control 6.0 (SP6)
Microsoft Windows Common Controls 6.0 (SP6)
Microsoft Windows Common Controls-2 6.0 (SP6)
vbAccelerator Image List Control (VB6 version)
vbAccelerator VB6 Explorer Bar Control

I dont have any specific reference for the Crystal reports or the Status screen...

Could it be the Microsoft ActiveX Data Objects 2.8 Library is out of date on the clients machine?

Thanks for the help.

[si_the_geek]

I'll try asking this again... Are you installing the "Splash" and "ErrorHandler" objects? (which I guess are both DLL's)

You will get the errors unless they are installed.

[evassilia]

Hi Everyone,

On my developers machine inside C:\Program Files\Common Files\Business Objects\

I have two folders one is 3.0 and another one is 2.7.

It seems as though 2.7 has all the Crystal Report objects and many more.

On my clients machine I dont have the 2.7 folder... might anyone know how I can get my hands on it?

Thanks.

[evassilia]

Does 2.7 reference Microsoft ActiveX Data Objects 2.8 Library???

And no I dont have those objects because I have no idea what the DLL name is for any of those objects, I didnt write the program I just modified it.

Thanks.

Regards,

Irena

[evassilia]

sorry if im all over the place that's because I'm lost when it comes to DLL's.

[evassilia]

msado15.dll is the activex data object 2.8 which is the same version on the clients computer... so it can't be that.

[RobDog888]

It's ALWAYS the simplest answer that elude everyone... You have not deployed all the ocx/dll/exe files that you need...

PDW can't help you if and will not create a good setup if there is no .dep file for the file systems you deploy... PERIOD!!!

No, everyone in this thread has stated hes missing dependancy files. Perhaps reading the posts is what is eluding you?

[RobDog888]

It seemsthat you havent really determined which line of code is the problem so its hard to say what component(s) you are missing.

You have stated that the error may be with at least 3 different calls and some are CR related and some are not. You need to determine all dependancies based upon your references and late bound code. Without seeing hte entire app we can not just tell you which is missing.

[evassilia]

I have eliminated the runtime error 429 by finding the exact DLL's which were needed for the program (they are custom dll's).

However now I get the Runtime error 91...

still confused..

[evassilia]

This is my code, please note the code works because this program has been installed on another clients computer without any issues so it has nothing do with the code.

Sub LaunchReport(vstrReportName As String, vintParamTotal As Integer)

'{{EA
On Error GoTo ErrorHandler
'}}EA

Dim str As String
Dim strPath As String

Dim rs As New ADODB.Recordset
Dim cnn As New ADODB.Connection

Dim objPrint As Object

Dim strValues(1 To 2) As Variant

Dim objStatus As Object
Set objStatus = CreateObject("Status.clsStatus")

Call objStatus.LoadStatusScreen(pstrProjectTitle, "Rendering Report...")

DoEvents

strValues(1) = 2005

strPath = modMain.strVerifyReportPath(vstrReportName)
MsgBox strPath
If strPath = pcstrBlank Then GoTo ErrorHandler
Set objPrint = CreateObject("PrintRep.clsPrintRep")
Call objPrint.PrintReport(2, strPath, ptypRepSettings.pstrDatabase_DSN, ptypRepSettings.pstrDatabase_UserName, ptypRepSettings.pstrDatabase_Password, pcbolFoundWithinReportIniFile_False, strValues, vintParamTotal, False, 2)
Set objPrint = Nothing

'{{EA
ErrorHandler_Exit:
Call objStatus.UnLoadStatusScreen
Screen.MousePointer = 0
Exit Sub
ErrorHandler:
Call modErrorHandler.ErrorTrap(Err.Number, Err.Description, Err.Source, "LaunchReport", "modMain")
GoTo ErrorHandler_Exit
'}}EA

End Sub

[evassilia]

Runtime error 91 is caused at the following lines:

Set objStatus = CreateObject("Status.clsStatus")

Set objPrint = CreateObject("PrintRep.clsPrintRep")

[RobDog888]

This will help you determine the exact line of your error.

Sub LaunchReport(vstrReportName As String, vintParamTotal As Integer)

'{{EA
On Error GoTo ErrorHandler
'}}EA

Dim str As String
Dim strPath As String

Dim rs As New ADODB.Recordset
Dim cnn As New ADODB.Connection

Dim objPrint As Object

Dim strValues(1 To 2) As Variant

Dim objStatus As Object
100 Set objStatus = CreateObject("Status.clsStatus")

110 Call objStatus.LoadStatusScreen(pstrProjectTitle, "Rendering Report...")

DoEvents

strValues(1) = 2005

120 strPath = modMain.strVerifyReportPath(vstrReportName)
MsgBox strPath
130 If strPath = pcstrBlank Then GoTo ErrorHandler
140 Set objPrint = CreateObject("PrintRep.clsPrintRep")
150 Call objPrint.PrintReport(2, strPath, ptypRepSettings.pstrDatabase_DSN, ptypRepSettings.pstrDatabase_UserName, ptypRepSettings.pstrDatabase_Password,  pcbolFoundWithinReportIniFile_False, strValues, vintParamTotal, False, 2)
Set objPrint = Nothing

'{{EA
ErrorHandler_Exit:
    Call objStatus.UnLoadStatusScreen
    Screen.MousePointer = 0
    Exit Sub
ErrorHandler:
    MsgBox "Error Line Number: " & Erl
    Call modErrorHandler.ErrorTrap(Err.Number, Err.Description, Err.Source, "LaunchReport", "modMain")
    GoTo ErrorHandler_Exit
'}}EA

End Sub

[evassilia]

I did determine the error at the exact lines as I've mensioned in the above post:

Set objStatus = CreateObject("Status.clsStatus")

Set objPrint = CreateObject("PrintRep.clsPrintRep")

Not the number no, I'm not sure how to display lines in VB6.

Regards,

Irena

[RobDog888]

Um, but I just showed you how to determine the line. Look at the code example

So you are saying the error 91 is at line 100?

[evassilia]

oh lol yes it's at 100

[evassilia]

well boys thanks for the help but I've figured it out. I remembered that sometimes when you register your dll's and ocx's through Reg.bat some of the dll's loose their license and to fix that problem all you have to do is simply register them manually through start-run... I love it when it's such small errors that cause you so much time to figure out.. lol!

[randem]

No, everyone in this thread has stated hes missing dependancy files. Perhaps reading the posts is what is eluding you?

Perhaps not responding to post that are not referring to you would be a better help to the OP...