Randem Systems Support Board

Visual Basic - Problems and Solutions => Visual Basic 6 => Topic started by: Randem on October 03, 2009, 12:04:11 PM

Title: Problem Installing Database
Post by: Randem on October 03, 2009, 12:04:11 PM
Actually you are not missing any files, it was a combination of the things I told you prior. You have installation procedural issues

Installing files to the wrong locations
forcefully installing the wrong version of files

Here is what my installation looks like

; InnoScript Version 10.1  Build 0
; Randem Systems, Inc.
; Copyright (c) 2002 - 2009, Randem Systems, Inc.
; Website:  https://randemsystems.com (https://randemsystems.com)
; Support:  https://randemsystems.support (https://randemsystems.support)
; OS: Windows XP 5.1 build 2600 (Service Pack 3)

; Derived from VB VBP Project File

; Designed for Inno Setup Version: 5.3.4 (u)
; Installed Inno Setup Version: 5.3.4 (u)

; Local Machine Settings. Use these settings as a template for your installation folders

; {app}           : C:\Program Files\Randem Systems\InnoScript
; {appdata}       : C:\Documents and Settings\Ralph James_2\Application Data\Randem Systems\InnoScript\Release\
; {localappdata}  : C:\Documents and Settings\Ralph James_2\Local Settings\Application Data\Randem Systems\InnoScript\Release\
; {cf}            : C:\Program Files\Common Files\Randem Systems
; {tmp}           : C:\Documents and Settings\Ralph James_2\Local Settings\Temp\
; {commonappdata} : C:\Documents and Settings\All Users\Application Data\Randem Systems\InnoScript\Release\
; {pf}            : C:\Program Files\

; Date: October 03, 2009

;              VB Runtime Files Folder:   C:\Program Files\Randem Systems\InnoScript 10\VB 6 Redist Files\
;     Visual Basic Project File (.vbp):   E:\Temp\Jase\Myexe-9644\MyApp.vbp
; Inno Setup Script Output File (.iss):   E:\Temp\Jase\Myexe-9644\MyApp Release.iss
;         Script Template Files (.tpl):   C:\Documents and Settings\Ralph James_2\Local Settings\Application Data\Randem Systems\InnoScript\Release\Templates\Release.tpl

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

; Microsoft DAO 3.51 Object Library - (Dao350.dll)


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

; Microsoft Common Dialog Control 6.0 (SP6) - (COMDLG32.OCX)
; Microsoft Data Bound Grid Control 5.0 (SP3) - (DBGRID32.OCX)
; Microsoft Windows Common Controls 5.0 (SP2) - (comctl32.ocx)


[Setup]
SetupLogging=Yes
AppId=MyApp 

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

AppName=MyApp 1.3.9
AppVerName=MyApp 
AppPublisher=My Company

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

AppVersion=1.3.9
VersionInfoVersion=1.3.9
AllowNoIcons=no
DefaultGroupName=MyApp 
DefaultDirName={pf}\My Company\MyApp 1 
AppCopyright=(C), 2003-2008,
PrivilegesRequired=Admin
MinVersion=0,5.0
Compression=lzma
OutputBaseFilename=MyApp139Release

[Tasks]
Name: AutoOSUpdater; Description: Install Support for Database Operations; GroupDescription: Install Database Support:

[Files]
Source: E:\Server Data\Randem\Develop\Support\Scripts\Output\VB_DCOM_MDAC_JET_AutoSetup.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: AutoOSUpdater
Source: E:\Temp\Jase\Myexe-9644\x-ray.mdb; DestDir: {app}; Flags:  ignoreversion; 
Source: E:\Temp\Jase\Myexe-9644\ECONMIN.MDW; DestDir: {app}; Flags:  ignoreversion; 
Source: C:\Program Files\Common Files\Microsoft Shared\DAO\Dao350.dll; DestDir: {cf}\Microsoft Shared\DAO\; Flags:  regserver restartreplace sharedfile; 
Source: E:\Server Data\Randem\Develop\Deployable System Files\COMDLG32.OCX; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: E:\Server Data\Randem\Develop\Deployable System Files\DBGRID32.OCX; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: E:\Server Data\Randem\Develop\Deployable System Files\comctl32.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: E:\Temp\Jase\Myexe-9644\MyApp.exe; DestDir: {app}; Flags:  ignoreversion restartreplace; 

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

[Icons]
Name: {group}\MyApp ; Filename : {app}\MyApp.exe; WorkingDir: {app}
Name: {group}{cm:ProgramOnTheWeb, MyApp }; Filename: {app}\MyApp.url; IconFilename: {app}\MyApp.ico
Name: {group}{cm:UninstallProgram, MyApp }; Filename: {uninstallexe}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist runascurrentuser; Tasks: AutoOSUpdater
Filename: {app}\MyApp.exe; Description: {cm:LaunchProgram, MyApp }; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

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

[Registry]

[Comments]

Template Processing first character indicators usage.

         No Indicator      Attempt replacement if cannot replace then add the line
          Plus Sign      Force addition of template line into script (no attempted replacement).
  ;      Semi-colon      Add line as a comment only. (No attempted replacement).
  -      Minus Sign      Delete the line. (No attempted replacement).
  &      Ampersand      Comment the line. (No attempted replacement).
Title: Problem Installing Database
Post by: jase on October 03, 2009, 12:51:55 PM
What do I need to get my script working? I assume I am missing some files?
Title: Problem Installing Database
Post by: Randem on October 03, 2009, 11:05:38 AM
It's what we do...
Title: Problem Installing Database
Post by: jase on October 03, 2009, 02:31:27 AM
Working OK.
Title: Problem Installing Database
Post by: Randem on October 03, 2009, 02:08:39 AM
Try this MyApp (https://randemsystems.com/scripts/downloadit.php?filename=MyApp139Release.zip)
Title: Problem Installing Database
Post by: jase on October 03, 2009, 12:59:23 AM
Here is the app
 
Title: Problem Installing Database
Post by: Randem on October 03, 2009, 12:27:50 AM
Clean System... This is what we do here...
Title: Problem Installing Database
Post by: jase on October 03, 2009, 12:16:53 AM
Yes, the auto updater was run. Do you have a clean system? The error will only show on a system without VS6 already installed.
Title: Problem Installing Database
Post by: Randem on October 03, 2009, 12:06:22 AM
They are if the Auto OS Updater was run. Was it?
 
Could you zip the exe. I will recreate your installation to see what I see here.
Title: Problem Installing Database
Post by: jase on October 03, 2009, 12:03:48 AM
OK, tried deploying this one with no luck. I'm back to believing there is a missing file. Is there some way to check if the runtime files are registered correctly?
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 11:50:39 PM
Ok, use the updated version and make sure that it's from the same company. MS has one and I believe one other company has one by the same name also.
 
The one you are deploying may not be the one registered on your machine...
Title: Problem Installing Database
Post by: jase on October 02, 2009, 11:46:39 PM
Yes, to both questions. The dbgrid32.ocx in the system32 folder is a different version again...
 
5.1.98.12 11/13/2008
 
I seem to remember installing another vs6 2009 service pack from microsoft support this year.
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 10:31:02 PM
Are you developing in VB6? If so do you have VS SP6 installed? Your file is obviously older than the one I have and it may have a problem.
Title: Problem Installing Database
Post by: jase on October 02, 2009, 11:23:50 PM
dbgrid32.ocx 5.0.37.14
14/1/1997
 
(Message edited by jase on October 02, 2009)
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 11:21:04 PM
What version is your dbgrid32.ocx file (5.1.81.4 - 6/24/1998)?
Title: Problem Installing Database
Post by: jase on October 02, 2009, 11:13:12 PM
OK, here it is
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 11:06:22 PM
You need to ZIP it first...
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 11:02:43 PM
You never zipped and attached the file... Could you include the exe file also?
Title: Problem Installing Database
Post by: jase on October 02, 2009, 11:01:17 PM
I am aware of the first two problems. I agree it seems there is a missing file.. or perhaps wrong version?
 
Here is vbp file
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 10:26:59 PM
From a brief look, your app will not run in a limited users account. Vista will try visualization (please read https://randemsystems.support/innoscript-general-questions-report-bugs-problems-etc/making-your-application-vista-windows-7-windows-8-compliant/ (https://randemsystems.support/innoscript-general-questions-report-bugs-problems-etc/making-your-application-vista-windows-7-windows-8-compliant/))
 
You are installing the DAO file in the wrong location and will possibly cripple another application if it uses a high version of the file.
 
You are getting that error because a file needed is not registered. I can't tell what that is because I cannot see your vbp file. It is possible that you are missing other files.
Title: Problem Installing Database
Post by: jase on October 02, 2009, 10:17:57 PM
The mdb file will not load into the dbgrid control. I get an error - cannot load activex object... class id not registered...
 
The dbgrid.ocx will not load
 
(Message edited by jase on October 02, 2009)
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 10:15:12 PM
Please define Wont Run... That expression does not help explain the problem.
Title: Problem Installing Database
Post by: jase on October 02, 2009, 10:13:01 PM
Here is the script, shortened version without data and program files. Is there any rreason why a VB6 Access 97 program won't run on XP or vista?
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 09:05:54 PM
Can you post the script?
Title: Problem Installing Database
Post by: jase on October 02, 2009, 09:02:56 PM
I used the vbp file. Yes, I must be missing something...
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 07:44:05 PM
BTW: What method did you use to create the script?
 
Did you use the Setup.lst file or the VBP file?
 
It would be highly improbable to have exactly the same files...
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 07:41:08 PM
Jase... The vbp file is not source code...
 
Post your script...
Title: Problem Installing Database
Post by: jase on October 02, 2009, 07:39:10 PM
Starting a new project fixed the innoscript error. The project is commercial so I can't post it. Looking at the innoscript files, everything matches perfectly, but it still won't run using InnoSetup. Like I said, it runs perfectly using a different installation software.
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 06:32:45 PM
What version of InnoScript are you running?
if you have the universal VB runtime files how could any be missing?
Zip and Post your VBP file and your Exe file from your project and I will take a look.
Title: Problem Installing Database
Post by: jase on October 02, 2009, 06:23:36 PM
I am already using the universal vb runtime files. The problem is missing vb runtime files in the installation program. I am not sure exactly which ones, may have to go through the manual again. InnoScript could probably help here, but I keep getting an error when I run it - Error in Procedure CheckDepFile of Module Depdefinitions when Create Script is run.
 
(Message edited by jase on October 02, 2009)
Title: Problem Installing Database
Post by: Randem on October 02, 2009, 05:20:34 PM
Aloha Jase,

First thing that I see is that you are deploying files that you should not because they are OS version specific https://randemsystems.support/innoscript-general-questions-report-bugs-problems-etc/installation-problems/ (https://randemsystems.support/innoscript-general-questions-report-bugs-problems-etc/installation-problems/). Those files should be removed (and possibly others in your script) and replaced with the universal VB runtime files and the correct MDAC for your target OS. We have a Automatic OS Updater (https://randemsystems.com/os-updater-support) that can help you in that area

You could also run your VB project thru InnoScript (https://randemsystems.com/innoscript//) and it will do most of that for you.

I would need to see your script to know more...
Title: Problem Installing Database
Post by: jase on October 02, 2009, 02:39:15 PM
I am installing a VB6 database app (Access '97 Database). The install files are:
 
Myapp.exe App dir
Mydb.mdb App dir  
stdole2.tlb  
msvbvm60.dll
oleaut32.dll
olepro32.dll
asycfilt.dll
comcat.dll
comctl32.ocx
COMDLG32.OCX
DBGRID32.OCX
MFC40.DLL
MSCOMCTL.OCX
Dao350.dll
MSJET35.DLL
MSJINT35.DLL
MSJTER35.DLL
MSRD2X35.DLL
MSREPL35.DLL
EXPSRV.DLL
VB5DB.DLL
 
All to the Sys Dir using Conditional Installs. Installing using InnoSetup gives a runtine error cannot load activex object (All versions of Windows). I assume it is referring to the dbgrid.ocx control. Installing using a legacy (WinXP) setup app will run the program correctly, but  on vista I get an message saying program was not installed correctly. Reinstall using recommended settings?.
 
Is this  a problem with the way the files are being registered with InnoSetup or am I missing some installation files?
 
How can I get the install working with InnoSetup?