Crystal Reports 4 deployment

[PeterBorroloola]

Apologies if anyone has read this on XtremeVBTalk, I'm not getting any bites there.

I know Crystal 4 is completely out of date, but it still suits my purposes, reporting from a VB6 Access front-end for a small remote community health clinic. I can't justify buying the latest developer CR version.

I'm trying to put together a single setup for all runtime files required by several such db front-ends I've developed for work (see http://www.xtremevbtalk.com/showthread.php?p=1239579).

Using ********** (thanks Randem), and Flyguy's advice, I've managed to get everything working on a new machine apart from the CR4 dependencies. During the install, an error appears saying:

"C:\windows\system32\crystl32.ocx"
"Unable to register the DLL/OCX: RegSvr32 failed with exit code 0x3"

From what I can gather, this means 'unable to find path' (to crystl32.ocx). But I checked, and the file is in the sys directory.

The relevant part of the inno script is as follows:

[Files]
Source: c:\vbdeps\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression;
Source: "c:\vbdeps\comdlg32.ocx"; DestDir: "{sys}"; Flags: restartreplace sharedfile regserver
Source: "c:\vbdeps\crystl32.ocx"; DestDir: "{sys}"; Flags: restartreplace sharedfile regserver
Source: "c:\vbdeps\mscomct2.ocx"; DestDir: "{sys}"; Flags: restartreplace sharedfile regserver
Source: "c:\vbdeps\tabctl32.ocx"; DestDir: "{sys}"; Flags: restartreplace sharedfile regserver

Does anyone if crystl32.ocx requires other dependencies before it can load properly on a clean machine? Possibilities include crpe32.dll, co2c40en.dll, msvcrt20.dll and u2ddisk.dll, u2dmapi.dll, u2fcr.dll, u2fdif.dll, u2fhtml.dll, u2frec.dll, u2frtf.dll, u2fsepv.dll, u2ftext.dll, u2fwks.dll, u2fwordw.dll, u2fxls.dll. Although I've tried running an Inno script, loading all these files as well, and crystl32.ocx still will not register

Or is there some other reason the crystl32.ocx won't register? I've tried registering it manually after the install (regsvr32 "c:\windows\system32\crystl32.ocx"), an error appears saying "LoadLibrary("c:\windows\system32\crystl32.ocx") failed - The specified module could not be found." But again, the file is in the sys directory.

My own machine and the work machines are all XP SP2. Any help much appreciated, Peter

[randem]

********** should have found any dependencies that cryst32.ocx used. You can also use Depende.exe to look at the file and check for a crystl32.dep file on your computer. It would have dependencies for the .ocx file. If thos file is placed in the same folder as the .ocx file, ********** will use it's contents also in the script.

BTW: Post your whole script. Nothing can be determined from a small portion of it.

[PeterBorroloola]

Randem, thanks for replying. I checked crystl32.dep, the ocx uses comcat.dll and crpe32.dll. Comcat doesn't use any other files, but crpe32.dll uses:

Uses1=IMPLODE.DLL
Uses2=PG32.DLL
Uses3=CO2C40EN.DLL
Uses4=CRXLAT32.DLL
; database dlls
Uses5=P2BBND.DLL
Uses6=P2BDAO.DLL
Uses7=P2CTDAO.DLL
Uses8=P2IRDAO.DLL
Uses9=P2SODBC.DLL
; export destination dlls
Uses10=U2DDISK.DLL
Uses11=U2DMAPI.DLL
; export format dlls
Uses12=U2FCR.DLL
Uses13=U2FDIF.DLL
Uses14=U2FHTML.DLL
Uses15=U2FREC.DLL
Uses16=U2FRTF.DLL
Uses17=U2FSEPV.DLL
Uses18=U2FTEXT.DLL
Uses19=U2FWKS.DLL
Uses20=U2FWORDW.DLL
Uses21=U2FXLS.DLL

I ran ********** again (and tailored it in InnoSetup, to remove all references to the actual application, because I just want this to be a runtimes installer). The script goes like this:

; ********** Version 7.0 Build 0
; Randem Systems, Inc.
; Copyright 2003-2007
; website: http://www.***********
; support: http://www.**********.com/cgi-bin/discus/discus.cgi

; Date: July 17, 2007

; VB Runtime Files Folder: C:\vbdeps\
; Visual Basic Project File (.vbp): C:\Documents and Settings\Peter\My Documents\Borroloola VB\Antenate\Antenate.vbp
; Inno Setup Script Output File (.iss): C:\Documents and Settings\Peter\My Documents\Borroloola VB\VB Runtimes Release.iss

; ------------------------
; References
; ------------------------

; Visual Basic runtime objects and procedures - (MSVBVM60.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft ActiveX Data Objects 2.7 Library - (msado15.dll)
; Microsoft Excel 8.0 Object Library - (EXCEL8.OLB)
; Microsoft Jet and Replication Objects 2.6 Library - (msjro.dll)
; Microsoft Shell Controls And Automation - (SHELL32.dll)


; --------------------------
; Components
; --------------------------

; Microsoft Tabbed Dialog Control 6.0 (SP6) - (TABCTL32.OCX)
; Microsoft Common Dialog Control 6.0 (SP6) - (COMDLG32.OCX)


[Setup]

;-----------------------------------------------------------------------------------------------------
; Taken from VBP Project File Parameters AppName, AppName AppVersion and Company
;-----------------------------------------------------------------------------------------------------

AppName=VB Runtimes
AppVerName=VB Runtimes 1.0
AppPublisher=Peter Nihill

;-----------------------------------------------------------------------------------------------------

;AppVersion=1.0.0
;VersionInfoVersion=1.0.0
;AllowNoIcons=no
;DefaultGroupName=Antenate database
;DefaultDirName={code:GetAppFolder}\Antenate database
;AppCopyright=
PrivilegesRequired=Admin
MinVersion=4.0,4.0
Compression=lzma
OutputBaseFilename=VBRuntimes
;Just creating a runtime installer, not installing an app
CreateAppDir=no

[Tasks]
Name: AutoOSUpdater; Description: Install MDAC's for Database Operations; GroupDescription: Install MDAC's:

[Files]
Source: c:\vbdeps\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression;
Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags: regserver sharedfile;
Source: c:\vbdeps\tabctl32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\mscomct2.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\crpe32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\co2c40en.dll; DestDir: {sys}; Flags: sharedfile;

[INI]

[Icons]

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater

[UninstallDelete]

[Registry]



I tried running this setup, same problem as in the first post; could not register crystl32.ocx.

Any other ideas on this one? Thanks for any help, Peter

[randem]

You need to create the script with the exe and vbp then comment out the exe if you want to do something like that. Run ********** again against the VBP then post that script. We will cut it down from there.

[PeterBorroloola]

Randem, thanks for all your help. The plain vanilla ********** script from the vbp is as follows: (PS ********** couldn't find Excel8.old or msjro.dll, but I don't think either of those should be really necessary?)

; ********** Version 7.0 Build 0
; Randem Systems, Inc.
; Copyright 2003-2007
; website: http://www.***********
; support: http://www.**********.com/cgi-bin/discus/discus.cgi

; Date: July 17, 2007

; VB Runtime Files Folder: C:\vbdeps\
; Visual Basic Project File (.vbp): C:\Documents and Settings\Peter\My Documents\Borroloola VB\Antenate\Antenate.vbp
; Inno Setup Script Output File (.iss): C:\Documents and Settings\Peter\My Documents\Borroloola VB\VB Runtimes2 Release.iss

; ------------------------
; References
; ------------------------

; Visual Basic runtime objects and procedures - (MSVBVM60.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft ActiveX Data Objects 2.7 Library - (msado15.dll)
; Microsoft Excel 8.0 Object Library - (EXCEL8.OLB)
; Microsoft Jet and Replication Objects 2.6 Library - (msjro.dll)
; Microsoft Shell Controls And Automation - (SHELL32.dll)


; --------------------------
; Components
; --------------------------

; Microsoft Tabbed Dialog Control 6.0 (SP6) - (TABCTL32.OCX)
; Microsoft Common Dialog Control 6.0 (SP6) - (COMDLG32.OCX)


[Setup]

;-----------------------------------------------------------------------------------------------------
; Taken from VBP Project File Parameters AppName, AppName AppVersion and Company
;-----------------------------------------------------------------------------------------------------

AppName=Antenate
AppVerName=Antenate 1.0.0
AppPublisher=

;-----------------------------------------------------------------------------------------------------

AppVersion=1.0.0
VersionInfoVersion=1.0.0
AllowNoIcons=no
DefaultGroupName=Antenate database
DefaultDirName={code:GetAppFolder}\Antenate database
AppCopyright=
PrivilegesRequired=Admin
MinVersion=4.0,4.0
Compression=lzma
OutputBaseFilename=Antenate100Release

[Tasks]
Name: AutoOSUpdater; Description: Install MDAC's for Database Operations; GroupDescription: Install MDAC's:

[Files]
Source: c:\vbdeps\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression;
Source: excel8.olb; DestDir: {sys}; Flags: sharedfile regtypelib;
Source: msjro.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags: regserver sharedfile;
Source: c:\vbdeps\tabctl32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\documents and settings\peter\my documents\borroloola vb\antenate\antenate.exe; DestDir: {app}; Flags: ignoreversion;
Source: c:\vbdeps\crpe32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\co2c40en.dll; DestDir: {sys}; Flags: sharedfile;

[INI]
Filename: {app}\Antenate.url; Section: InternetShortcut; Key: URL; String:

[Icons]
Name: {group}\Antenate; Filename: {app}\Antenate.exe; WorkingDir: {app}
Name: {group}\Antenate on the Web; Filename: {app}\Antenate.url
Name: {group}\Uninstall Antenate; Filename: {uninstallexe}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: {app}\Antenate.exe; Description: Launch Antenate; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

[UninstallDelete]
Type: files; Name: {app}\Antenate.url

[Registry]
Root: HKCU; Subkey: Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers; ValueType: string; ValueName: {app}\Antenate.exe; ValueData: RUNASADMIN
Root: HKLM; Subkey: Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers; ValueType: string; ValueName: {app}\Antenate.exe; ValueData: WINXPSP2

[randem]

These files should be removed

Source: excel8.olb; DestDir: {sys}; Flags: sharedfile regtypelib;

Your users will need to have excel installed to use your app so that file will already be there.

Source: msjro.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile;

This should be deployed with the SP for Jet Replication. It is included with the latest version of the AutoOSUpdater.

Did you search your computer for the dep files that go with the Crystal Report ocx files. They need to be in the same location as the folder you are getting these files from in your script.

I noticed you don't have any references to Crystal Reports in your app. Are you creating these objects dynamically?

[randem]

BTW: It couldn't find those files because you are running in SAFE mode. From the ********** Documentation...

If running in safe mode and you have moved the files from the system folder to another folder. Place
the path of that folder into the path area so that they can be found there.

After running ********** and creating your script, you may find some files that are not found.

This can be remedied in ways that may mean combining several different options then re-running **********.

1. Use unsafe mode.
2. Insert missing folder paths in your Search Path Area.
3. Remove the bad file names from the dependency files (.dep).
4. Place the file names in the UnSafe.fil file.

[PeterBorroloola]

Randem, I have commented out excel8.olb and msjro.dll in all the scripts I've tried already.

All the crystl32.ocx dependencies are in the same location as the other files needed for the script, except for (from the list in my previous post)
IMPLODE.DLL and PG32.DLL. Just tried the script again with those files there, ********** did not include them and the ocx still didn't register.

I noticed you don't have any references to Crystal Reports in your app. Are you creating these objects dynamically?

I'm a long-time VB coder, but a very part-time one. How can you tell from the script there are no references to CR in the app, and how do mean create the objects dynamically? I added the CR4 'component' to a form, named it crpReports, put formatted reports in the same dir as the app, and call them with code like this:

crpReports.Destination = 0
crpReports.ReportFileName = App.Path & "\postnates.rpt"
crpReports.PrintReport

Without crystl32.ocx registered, the apps won't even start, so it must be considered an integral part of the app.

thanks again, Peter

[randem]

Still is the crystl32.dep file in the same folder as crystl32.ocx? If not put it there as well as any other CR .dep files and re-run **********. Now in your app you did not got to Project->References and add the CR references you are using? Your app should not work with CR at all if you did not do that.

[PeterBorroloola]

Randem, just saw your #7 post. All the dependencies for crystl32.ocx are now in the same dir as the other files ("c:\vbdeps"). As I said in my last post, I tried ********** again, and it did not include any of those dependencies.

It should not make any difference running in Unsafe Mode if all the required files are already in the one cache? I just tried ********** again in Unsafe Mode, the only difference is it found msjro.dll and excel8.olb in my sys folder.

thanks, Peter

[randem]

is it possible to zip and get to me your vbp, exe and those files from your vbdeps folder?

[PeterBorroloola]

I put the crystl32.dep in the same directory as the other files, ran ********** and it found all the deps but ... the install still wouldn't register the ocx.

There isn't a reference to CR in the VB project, but I haven't had any trouble with this before. The couple of times I've done installs, usually using the P&DW, it's all gone OK. I tried adding a reference, but CR is not in the 'available' list, and I could not add it via any of the dlls - got an error saying 'Can't add a reference to the specified file'.

I've got a slow connection, but I can try sending you the vbp, exe and deps. What's the easiest? Just attach it to a message here?

thanks again, Peter

[randem]

It depends on the size of the file. I would imagine that it would be too big.

[randem]

Did you add a CR ocx to a form in your project and that is where the reference crpReports comes from? How did you come to reference that object?

[PeterBorroloola]

Everything NOT including the OSUpdater (which I got from your site a few days ago) zips to 4.27MB. btw, the ********** with crystl32.dep in the vbdeps folder looks like this:

; ********** Version 7.0 Build 0
; Randem Systems, Inc.
; Copyright 2003-2007
; website: http://www.***********
; support: http://www.**********.com/cgi-bin/discus/discus.cgi

; Date: July 17, 2007

; VB Runtime Files Folder: C:\vbdeps\
; Visual Basic Project File (.vbp): C:\Documents and Settings\Peter\My Documents\Borroloola VB\Antenate\Antenate.vbp
; Inno Setup Script Output File (.iss): C:\Documents and Settings\Peter\My Documents\Borroloola VB\VB Runtimes6 Release.iss

; ------------------------
; References
; ------------------------

; Visual Basic runtime objects and procedures - (MSVBVM60.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft ActiveX Data Objects 2.7 Library - (msado15.dll)
; Microsoft Excel 8.0 Object Library - (EXCEL8.OLB)
; Microsoft Jet and Replication Objects 2.6 Library - (msjro.dll)
; Microsoft Shell Controls And Automation - (SHELL32.dll)


; --------------------------
; Components
; --------------------------

; Microsoft Tabbed Dialog Control 6.0 (SP6) - (TABCTL32.OCX)
; Microsoft Common Dialog Control 6.0 (SP6) - (COMDLG32.OCX)


[Setup]

;-----------------------------------------------------------------------------------------------------
; Taken from VBP Project File Parameters AppName, AppName AppVersion and Company
;-----------------------------------------------------------------------------------------------------

AppName=Antenate
AppVerName=Antenate 1.0.0
AppPublisher=Peter Nihill

;-----------------------------------------------------------------------------------------------------

AppVersion=1.0.0
VersionInfoVersion=1.0.0
AllowNoIcons=no
DefaultGroupName=Antenate
DefaultDirName=Antenate
AppCopyright=
PrivilegesRequired=Admin
MinVersion=4.0,4.0
Compression=lzma
OutputBaseFilename=VB Runtimes6Release

[Tasks]
Name: AutoOSUpdater; Description: Install MDAC's for Database Operations; GroupDescription: Install MDAC's:

[Files]
Source: c:\vbdeps\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression;
;Source: excel8.olb; DestDir: {sys}; Flags: sharedfile regtypelib;
;Source: msjro.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags: regserver sharedfile;
Source: c:\vbdeps\tabctl32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\documents and settings\peter\my documents\borroloola vb\antenate\antenate.exe; DestDir: {app}; Flags: ignoreversion;
Source: c:\vbdeps\pg32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\co2c40en.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\crxlat32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2bbnd.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2bdao.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2ctdao.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2irdao.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2sodbc.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2ddisk.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2dmapi.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fcr.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fdif.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fhtml.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2frec.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2frtf.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fsepv.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2ftext.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fwks.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fwordw.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fxls.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\crpe32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\lead50n.dll; DestDir: {sys}; Flags: sharedfile;

[INI]
Filename: {app}\Antenate.url; Section: InternetShortcut; Key: URL; String:

[Icons]
Name: {group}\Antenate; Filename: {app}\Antenate.exe; WorkingDir: {app}
Name: {group}\Antenate on the Web; Filename: {app}\Antenate.url
Name: {group}\Uninstall Antenate; Filename: {uninstallexe}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: {app}\Antenate.exe; Description: Launch Antenate; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

[UninstallDelete]
Type: files; Name: {app}\Antenate.url

[Registry]
Root: HKCU; Subkey: Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers; ValueType: string; ValueName: {app}\Antenate.exe; ValueData: RUNASADMIN
Root: HKLM; Subkey: Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers; ValueType: string; ValueName: {app}\Antenate.exe; ValueData: WINXPSP2



thanks again, Peter

[randem]

OK,

Change this line

Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags: regserver sharedfile;

to this

Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;

And attempt an install

[randem]

Well just send the vbp and the exe file for now.

[PeterBorroloola]

Did you add a CR ocx to a form in your project and that is where the reference crpReports comes from? How did you come to reference that object?

Yes and yes. I referenced it via the 'Components' dialog, 'Controls' tab.

thanks, Peter

[randem]

I am surprised because it did not show up in ********** in your components list. The only way I know of that happening is the file is not registered on your system you created the script on.

Get me those two files so I can take a look.

[PeterBorroloola]

I think this attached ... hope so

Antenate.zip

[randem]

Hmmm, on my system the CR control shows up in the Components list that ********** puts out. You must not have that files registered on your system.

[randem]

Did you do what I asked in post #16?

[PeterBorroloola]

OK, minor confession - I uninstalled CR from this machine, because the install would not try to register the CR ocx if it was already registered.

BUT ... I reinstalled CR, ran ********** again (crystl32.ocx then showed up in the components section), uninstalled CR again, restarted the machine and, hey presto, the install still wouldn't register the ocx.

thanks for all your help on this, Peter

[randem]

Also your app doesn't seem to use a database, why do you need the MDAC's? Do your operations with Excel require it?

[PeterBorroloola]

In the latest script, the one put together WITH CR installed on the machine, the restartreplace flag is in the crystl32.ocx line:

Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;

thanks, Peter

[randem]

What OS are you running? Why not test your installs on a Virtual PC from Microsoft. It's free and you can blow it away and start with a clean PC the next run (as long as you have save the initial load).

[randem]

Yes that line has changed because the file was registered and so ********** knew what to do with it.

[PeterBorroloola]

The app does use a database, Antenate.mdb. The whole thing is really just a front-end for the db. The excel call is just to read some data from the db into a spreadsheet.

thanks, Peter

[PeterBorroloola]

I'm using XP Pro SP2, as are the machines at work. I'll have a look at VirtualPC. Worst comes to worst, I can just leave a copy of CR4 at work, and they can install that seperately.

thanks again, Peter

[randem]

Also you made another change. You changed

DefaultDirName={code:GetAppFolder}\Antenate database

to

DefaultDirName=Antenate

Why? You should really make changes like that unless you really know why it is coded like it is.

[randem]

Did you try a re-install with the line change?

[PeterBorroloola]

I didn't change the dirname line, not sure how that happened.

I did try a reinstall with the restartreplace flag in the crystl32.ocx line, that's what ********** outputed the last run (the one with CR registered on the machine). The install could still not register the ocx.

I have to go out for an hour, thanks for all your help Randem, hopefully I can get this sorted, Peter

[randem]

Ok, Sometimes that happens lately with some updates that MS deployed and some registry settings. That is why it is a very good idea to do a install on a clean machine (Virutal PC) This problem might just go away just like that. I am thinking it will. I have seen it before.

[randem]

BTW: Remove the DefaultDirName info from the parameter screen and select Template Script from the main menu then re-run ********** and the original code will be put back into the script.

[PeterBorroloola]

Randem, did what you said in the last post, the install still could not register crystl32.ocx

Script goes like this:

; ********** Version 7.0 Build 0
; Randem Systems, Inc.
; Copyright 2003-2007
; website: http://www.***********
; support: http://www.**********.com/cgi-bin/discus/discus.cgi

; Date: July 17, 2007

; VB Runtime Files Folder: C:\vbdeps\
; Visual Basic Project File (.vbp): C:\Documents and Settings\Peter\My Documents\Borroloola VB\Antenate\Antenate.vbp
; Inno Setup Script Output File (.iss): C:\Documents and Settings\Peter\My Documents\Borroloola VB\VB Runtimes8 Release.iss
; Script Template Files (.tpl): C:\Program Files\Randem Systems\**********\********** 7.0\Templates\Release.tpl
; : C:\Program Files\Randem Systems\**********\********** 7.0\Templates\VBRuntime.tpl
; : C:\Program Files\Randem Systems\**********\********** 7.0\Templates\Vista.tpl

; ------------------------
; References
; ------------------------

; Visual Basic runtime objects and procedures - (MSVBVM60.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft ActiveX Data Objects 2.7 Library - (msado15.dll)
; Microsoft Excel 8.0 Object Library - (EXCEL8.OLB)
; Microsoft Jet and Replication Objects 2.6 Library - (msjro.dll)
; Microsoft Shell Controls And Automation - (SHELL32.dll)


; --------------------------
; Components
; --------------------------

; Crystal Report Control 4.6 - (crystl32.ocx)
; Microsoft Tabbed Dialog Control 6.0 (SP6) - (TABCTL32.OCX)
; Microsoft Common Dialog Control 6.0 (SP6) - (COMDLG32.OCX)


[Setup]

;-----------------------------------------------------------------------------------------------------
; Taken from VBP Project File Parameters AppName, AppName AppVersion and Company
;-----------------------------------------------------------------------------------------------------

AppName=Antenate
AppVerName=Antenate 1.0.0
AppPublisher=Peter Nihill

;-----------------------------------------------------------------------------------------------------

AppVersion=1.0.0
VersionInfoVersion=1.0.0
AllowNoIcons=no
DefaultGroupName=Antenate database
DefaultDirName={code:GetAppFolder}\Antenate database
AppCopyright=
PrivilegesRequired=Admin
MinVersion=4.0,4.0
Compression=lzma
OutputBaseFilename=Antenate100Release

[Tasks]
Name: AutoOSUpdater; Description: Install MDAC's for Database Operations; GroupDescription: Install MDAC's:

[Files]
;Source: e:\server data\randem\develop\vb 5 redist files\MSVBVM50.DLL; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: regserver restartreplace sharedfile uninsneveruninstall
;Source: e:\server data\randem\develop\vb 6 redist files\msvbvm60.dll; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: regserver restartreplace sharedfile uninsneveruninstall
;Source: e:\server data\randem\develop\vb 6 redist files\oleaut32.dll; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: regserver restartreplace sharedfile uninsneveruninstall
;Source: e:\server data\randem\develop\vb 6 redist files\olepro32.dll; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: regserver restartreplace sharedfile uninsneveruninstall
;Source: e:\server data\randem\develop\vb 6 redist files\asycfilt.dll; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: sharedfile uninsneveruninstall
;Source: e:\server data\randem\develop\vb 6 redist files\stdole2.tlb; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: uninsneveruninstall sharedfile regtypelib
;Source: e:\server data\randem\develop\vb 6 redist files\comcat.dll; DestDir: {sys}; MinVersion: 4.0,4.0; OnlyBelowVersion: 0,6.0; Flags: regserver restartreplace sharedfile uninsneveruninstall
Source: c:\vbdeps\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression;
;Source: excel8.olb; DestDir: {sys}; Flags: sharedfile regtypelib;
;Source: msjro.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\crystl32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\tabctl32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\vbdeps\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: c:\documents and settings\peter\my documents\borroloola vb\antenate\antenate.exe; DestDir: {app}; Flags: ignoreversion;
Source: c:\vbdeps\pg32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\co2c40en.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\crxlat32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2bbnd.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2bdao.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2ctdao.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2irdao.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\p2sodbc.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2ddisk.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2dmapi.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fcr.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fdif.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fhtml.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2frec.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2frtf.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fsepv.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2ftext.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fwks.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fwordw.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\u2fxls.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\crpe32.dll; DestDir: {sys}; Flags: sharedfile;
Source: c:\vbdeps\lead50n.dll; DestDir: {sys}; Flags: sharedfile;

[INI]
Filename: {app}\Antenate.url; Section: InternetShortcut; Key: URL; String:

[Icons]
Name: {group}\Antenate; Filename: {app}\Antenate.exe; WorkingDir: {app}
Name: {group}\Antenate on the Web; Filename: {app}\Antenate.url
Name: {group}\Uninstall Antenate; Filename: {uninstallexe}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: {app}\Antenate.exe; Description: Launch Antenate; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

[UninstallDelete]
Type: files; Name: {app}\Antenate.url

[Registry]
Root: HKCU; Subkey: Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers; ValueType: string; ValueName: {app}\Antenate.exe; ValueData: RUNASADMIN
Root: HKLM; Subkey: Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers; ValueType: string; ValueName: {app}\Antenate.exe; ValueData: WINXPSP2

[Code]

function GetAppFolder(Param: String): String;
begin
if InstallOnThisVersion('0,6', '0,0') = irInstall then
Result := 'C:\Users\Public\' + ExpandConstant('{username}')
else
Result := ExpandConstant('{pf}');
end;

[randem]

Ok the script is getting better. You will have to attempt the install on a clean pc for the reasons I already have stated. If you could download and install Virtual PC then install XP on it, update it and then zip it. This way you will always have a clean install to return to. Run the install on that VM and I will bet the problem doesn't exist anymore.

[PeterBorroloola]

OK, that will take a while with my connection. I'll get back to you. Thanks again for all your help Randem

Peter

[randem]

So, how is the Virtual Machine install going?

[PeterBorroloola]

Randem, hope you're still there, I've been away for a few days.

I installed Virtual PC and put XP Pro, VB, CR4, InnoSetup and ********** on it. Ran the script, uninstalled CR4, ran the install and same problem - the install could not register crystl32.ocx.

I can't send you a copy of the script, because I can't work out how to network/share between the virtual and the real PCs. I think I'm about ready to give up anyways.

Randem, can I use the 'Run' section of the Inno script to install the CR4 setup? It should be legal, as CR4 is freely distributed with VB5 and VB6.

thanks, Peter

[randem]

The trick to the network share is to change the Virtual PC to have an IP address in the same segment as your host Machine. Then you can use the Shared Folders to transfer data between the two.

For the Virtual PC all you need on it is the OS. You just want to install your app on it to see if it works. Don't install all those other things on it for you defeat the "Clean Install" Environment. You do realize that all you want to run on the VM is the installation package, correct?

As far as the CR4 Setup, NO! Unless all you are installing is the runtime files for CR4.