Error handling or missing dependency file?

[frayne]

Please would some kind soul help me out.

When I try to run my application on some P.Cs I get some error messages. These are to do with an access database that is incorporated into the application.
When I try to load the database form I get a Data err hit event. If I cancel and try to proceed I get error 91
I have used ********** and have added VB_DCOM_MDAC_Jet autosetup but to no avail.
If I add VB6 to these PCs everything runs O.K
So, is my problem an Error handling problem or am I missing a dependancy file?

I use an ADODB.Connection.

This is the code on my Database form which was produced using VB6 data form wizard.

Private Sub cmdAdd_Click()
Data1.Recordset.AddNew
End Sub

Private Sub cmdDelete_Click()
'this may produce an error if you delete the last
'record or the only record in the recordset
Data1.Recordset.Delete
Data1.Recordset.MoveNext
End Sub

Private Sub cmdRefresh_Click()
'this is really only needed for multi user apps
Data1.Refresh
End Sub

Private Sub cmdUpdate_Click()
txtFields(4).text = (miles(2).text * 1760) * 60 + (yards(3).text * 60)
Data1.UpdateRecord
Data1.Recordset.Bookmark = Data1.Recordset.LastModified

End Sub

Private Sub cmdClose_Click()
Unload Me
Me.MousePointer = vbDefault

End Sub

Private Sub Command1_Click()
Crystal1.Show

End Sub

Private Sub Data1_Error(DataErr As Integer, Response As Integer)
'This is where you would put error handling code
'If you want to ignore errors, comment out the next line
'If you want to trap them, add code here to handle them
MsgBox "Data error event hit err:" & Error$(DataErr)
Response = 0 'throw away the error
End Sub

Private Sub Data1_Reposition()
Screen.MousePointer = vbDefault
On Error Resume Next
'This will display the current record position
'for dynasets and snapshots
Data1.Caption = "Record: " & (Data1.Recordset.AbsolutePosition + 1)
'for the table object you must set the index property when
'the recordset gets created and use the following line
'Data1.Caption = "Record: " & (Data1.Recordset.RecordCount * (Data1.Recordset.PercentPosition * 0.01)) + 1
End Sub

Private Sub Data1_Validate(Action As Integer, Save As Integer)
'This is where you put validation code
'This event gets called when the following actions occur
Select Case Action
Case vbDataActionMoveFirst
Case vbDataActionMovePrevious
Case vbDataActionMoveNext
Case vbDataActionMoveLast
Case vbDataActionAddNew
Case vbDataActionUpdate
Case vbDataActionDelete
Case vbDataActionFind
Case vbDataActionBookmark
Case vbDataActionClose
End Select
Screen.MousePointer = vbHourglass
End Sub

Private Sub Form_Load()
Data1.RecordSource = ("Select * From distances Order By name, racepoint")

End Sub

[Static]

if u install VB and then it works.. then u are missing an ocx, dll, etc.. something

[frayne]

Thank you, so I'm on the right track, but how can I find out which one I'm missing? I have used P&D and Innoscipt and everything seems O.K
Rob

[MartinLiss]

Moved.

[randem]

frayne,

You still have to add your database into the installer package. No installer can figure out what additional files that you need if you are the one who determines that. In ********** just go to Add Files and add the database (and any other personal files that are needed). Also make sure your connection string is dynamic so that you can change the location to the installed loacation and not have it pointing to the development location.

Since you did not include any error message that you got... IT WOULD BE TOTAL GUESSING....

[frayne]

Hi Randem
My apologies for not making it clear. I do add the necessary database file. The program works on about 50% of P.C's.that its installed on. I've made scripts using PDW and **********. The error message occurs when the user tries to open the database form. (Data error event hit err-Application defined or object defined error) Here is my **********.
[Setup]
AppName=The Club Calculator
AppVerName=these files
AppPublisher=Rosewood Lofts
AppVersion=3.0.102
VersionInfoVersion=3.0.102
AllowNoIcons=no
DefaultGroupName=Racing Pigeon Utilities
DefaultDirName=C:\Clubcalc
AppCopyright=R J Frayne 2003
PrivilegesRequired=None
MinVersion=4.1,5.01
OutputBaseFilename=Calc160406

[Tasks]
Name: desktopicon; Description: Create a &desktop icon; GroupDescription: Additional Icons:

[Files]

;VB6 Runtime Files
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\msvbvm60.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\oleaut32.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\olepro32.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\asycfilt.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\stdole2.tlb; DestDir: {sys}; Flags: regtypelib
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\comcat.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression

;Files I've created
Source: f:\calcfinal\calcvb\club.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\clubcalc.doc; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\distances.mdb; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\email.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\fed.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\result.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\cc.exe; DestDir: {app}; Flags: ignoreversion

;Files Inno setup said are required to run application
Source: f:\calcfinal\calcvb\dao350.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\msado25.tlb; DestDir: {sys}; Flags: uninsneveruninstall regtypelib
Source: f:\calcfinal\calcvb\mscomct2.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\mscomctl.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile


[INI]

[Icons]
Name: {group}\The Club Calculator; Filename: {app}\cc.exe; WorkingDir: {app}
Name: {group}\Uninstall The Club Calculator; Filename: {uninstallexe}
Name: {userdesktop}\The Club Calculator; Filename: {app}\cc.exe; Tasks: desktopicon; WorkingDir: {app}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist
Filename: {app}\cc.exe; Description: Launch The Club Calculator; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

[randem]

frayne,

What does your connection string look like?

[frayne]

Dim sSQL As String
Dim oConn As ADODB.Connection
Dim oRst As ADODB.Recordset
Dim sResults As String

' The SQL statment to retrieve the desired record(s)
sSQL = "SELECT Sixtieths FROM Distances WHERE Name = '" & member.text & _
"' AND Racepoint = '" & racepoint.text & "'"

' Allocate memory for our connection object and use a connection string to open the database


Set oConn = New ADODB.Connection
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source =" & App.Path & "\distances.mdb"
' Allocate memory for the recordset
Set oRst = New ADODB.Recordset
With oRst
' Open the recordset using our SQL string and existing connection object
.Open sSQL, oConn

' Loop through the results (in case there's more than one) until EOF (End Of File)
Do Until .EOF
' Append the results to our results string
sResults = sResults & .Fields(0).Value & vbNewLine
' Move to the next record
.MoveNext
Loop

' Close the recordset
.Close
End With
' Free memory
Set oRst = Nothing

' Close the connection
oConn.Close
' Free memory
Set oConn = Nothing

' Display results to the user
'MsgBox "The " & .racepoint.Text & "(s) from " & member.Text & " is/are:" & vbNewLine & sResults
sixtieths.text = sResults

[randem]

Are you running on different OS's? If so you need to check App.Path to see if there is a backslash before you automatically add one in the Source.

What is the original error message before you get the error 91. You stated you get an error then try to continue...

[frayne]

(Data error event hit err-Application defined or object defined error)
As I stated earlier,the application wil work fine if I install VB6 on the offending machine. I would have thought that the auto_dcom_jet_mdac file from randem systems would have prevented this data error.
Rob

[randem]

I have never seen that error before but it sounds like a data error in your database or app handling not with the COM engines which the file you mentioned would have fixed. You are not handling an EVENT properly (or at all) that is why you get the error.

What version of ********** are you using? Please post your debug logs for the run of your script in question. You must be missing some dll/ocx.

Data Controls are EVIL!!!!

[frayne]

First, let me thank you for your patience.
This is the debug file.
Randem Systems, Inc. - ********** - Version 5.3 Build 1 - 19/04/2006 20:40:06


19/04/2006 20:40:07 - Dependency Information (.Dep File)

C:\Program Files\Randem Systems\**********\********** 5.3\VB6Dep.ini
MSVBVM60.DLL
OLEAUT32.DLL
OLEPRO32.DLL
ASYCFILT.DLL
STDOLE2.TLB
COMCAT.DLL


19/04/2006 20:40:07 - Dependency Information

C:\Program Files\Randem Systems\**********\********** 5.3\VB 6 Redist Files\VB_DCOM_MDAC_JET_AutoSetup.exe
kernel32.dll
user32.dll
oleaut32.dll
advapi32.dll
comctl32.dll

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\club.txt

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\clubcalc.doc

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\distances.mdb

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\email.txt

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\fed.txt

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\result.txt

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\dao350.dll
MSVCRT40.dll
KERNEL32.dll
USER32.dll
ADVAPI32.dll
OLEAUT32.dll
ole32.dll

19/04/2006 20:40:07 - Dependency Information

C:\Program Files\Common Files\System\ado\msado25.tlb

19/04/2006 20:40:07 - Registered - mscomct2.ocx - C:\WINDOWS\system32\ -
19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\mscomct2.ocx
KERNEL32.dll
USER32.dll
ole32.dll
ADVAPI32.dll
OLEAUT32.dll
GDI32.dll

19/04/2006 20:40:07 - Registered - mscomctl.ocx - C:\WINDOWS\system32\ -
19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\mscomctl.ocx
KERNEL32.dll
USER32.dll
ole32.dll
ADVAPI32.dll
OLEAUT32.dll
comdlg32.dll
GDI32.dll

19/04/2006 20:40:07 - Registered - comdlg32.ocx - C:\WINDOWS\system32\ -
19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\comdlg32.ocx
KERNEL32.dll
USER32.dll
ole32.dll
ADVAPI32.dll
OLEAUT32.dll
comdlg32.dll
GDI32.dll

19/04/2006 20:40:07 - Dependency Information

F:\CalCfinal\CalcVB\cc.exe
MSVBVM60.DLL

[randem]

Ok, now let's see the WHOLE Inno Setup Script that was generated without modifications.

[frayne]

[Setup]
AppName=Project1
AppVerName=Project1 3.0.104
AppPublisher=Rosewood Lofts
AppVersion=3.0.104
VersionInfoVersion=3.0.104
AllowNoIcons=no
DefaultGroupName=Fords R.P.C Club Calculator
DefaultDirName={pf}\Calculator
AppCopyright=R J Frayne. 2003
PrivilegesRequired=Admin
MinVersion=0,0
OutputBaseFilename=cc30104Release

[Tasks]
Name: desktopicon; Description: Create a &desktop icon; GroupDescription: Additional Icons:

[Files]
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\msvbvm60.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\oleaut32.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\olepro32.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\asycfilt.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\stdole2.tlb; DestDir: {sys}; Flags: regtypelib
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\comcat.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression
Source: f:\calcfinal\calcvb\club.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\clubcalc.doc; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\distances.mdb; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\email.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\fed.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\result.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\dao350.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: c:\program files\common files\system\ado\msado25.tlb; DestDir: {sys}; Flags: uninsneveruninstall regtypelib
Source: f:\calcfinal\calcvb\mscomct2.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\mscomctl.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\cc.exe; DestDir: {app}; Flags: ignoreversion

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

[Icons]
Name: {group}\Project1; Filename: {app}\cc.exe; WorkingDir: {app}
Name: {group}\Project1 on the Web; Filename: {app}\cc.url
Name: {group}\Uninstall Project1; Filename: {uninstallexe}
Name: {userdesktop}\Project1; Filename: {app}\cc.exe; Tasks: desktopicon; WorkingDir: {app}

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

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

[randem]

Where is the rest of it????? You know WHOLE as in COMPLETE, Everything...

[frayne]

; ********** Version 5.3 Build 1
; Randem Systems, Inc.
; Copyright 2003, 2004
; website: http://www.***********
; support: http://www.**********.com/cgi-bin/discus/discus.cgi

; Date: April 19, 2006

; VB Runtime Files Folder: C:\Program Files\Randem Systems\**********\********** 5.3\VB 6 Redist Files\
; Visual Basic Project File (.vbp): F:\CalCfinal\CalcVB\cc.vbp
; Inno Setup Script Output File (.iss): F:\CalCfinal\CalcVB\calc190406.iss

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

; Visual Basic For Applications - (MSVBVM60.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft DAO 3.5 Object Library - (dao350.dll)
; Microsoft ActiveX Data Objects 2.5 Library - (msado25.tlb)


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

; Microsoft Windows Common Controls-2 6.0 (SP6) - (mscomct2.ocx)
; Microsoft Windows Common Controls 6.0 (SP6) - (mscomctl.ocx)
; Microsoft Common Dialog Control 6.0 (SP6) - (comdlg32.ocx)


[Setup]
AppName=Project1
AppVerName=Project1 3.0.104
AppPublisher=Rosewood Lofts
AppVersion=3.0.104
VersionInfoVersion=3.0.104
AllowNoIcons=no
DefaultGroupName=Fords R.P.C Club Calculator
DefaultDirName={pf}\Calculator
AppCopyright=R J Frayne. 2003
PrivilegesRequired=Admin
MinVersion=0,0
OutputBaseFilename=cc30104Release

[Tasks]
Name: desktopicon; Description: Create a &desktop icon; GroupDescription: Additional Icons:

[Files]
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\msvbvm60.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\oleaut32.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\olepro32.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\asycfilt.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\stdole2.tlb; DestDir: {sys}; Flags: regtypelib
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\comcat.dll; DestDir: {sys}; Flags: sharedfile
Source: c:\program files\randem systems\**********\********** 5.3\vb 6 redist files\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags: deleteafterinstall ignoreversion nocompression
Source: f:\calcfinal\calcvb\club.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\clubcalc.doc; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\distances.mdb; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\email.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\fed.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\result.txt; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\dao350.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: c:\program files\common files\system\ado\msado25.tlb; DestDir: {sys}; Flags: uninsneveruninstall regtypelib
Source: f:\calcfinal\calcvb\mscomct2.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\mscomctl.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\cc.exe; DestDir: {app}; Flags: ignoreversion

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

[Icons]
Name: {group}\Project1; Filename: {app}\cc.exe; WorkingDir: {app}
Name: {group}\Project1 on the Web; Filename: {app}\cc.url
Name: {group}\Uninstall Project1; Filename: {uninstallexe}
Name: {userdesktop}\Project1; Filename: {app}\cc.exe; Tasks: desktopicon; WorkingDir: {app}

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

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

[randem]

Ok, You have everything that you need. Now attempt to install your app with the /Log parameter to generate an installation log and check it to see if all files are getting installed on the problem computer.

From Inno Setup Documentation:

/LOG

Causes Setup to create a log file in the user's TEMP directory detailing file installation and [Run] actions taken during the installation process. This can be a helpful debugging aid. For example, if you suspect a file isn't being replaced when you believe it should be (or vice versa), the log file will tell you if the file was really skipped, and why.

The log file is created with a unique name based on the current date. (It will not overwrite or append to existing files.)
The information contained in the log file is technical in nature and therefore not intended to be understandable by end users. Nor is it designed to be machine-parseable; the format of the file is subject to change without notice.

/LOG="filename"

Same as /LOG, except it allows you to specify a fixed path/filename to use for the log file. If a file with the specified name already exists it will be overwritten. If the file cannot be created, Setup will abort with an error message.

[randem]

And you still haven't answered the question: Are you installing on another OS? Are you having problems on just one OS or are all the OS's the same?

[frayne]

The program installed on a Windows ME last week but not on XP sp2.
Where do I put the /Log parameter in Inno Setup is it after the outputfilename?
Rob

[randem]

On installation, on the command line or shortcut.

Ex.

cc30104Release /LOG

BTW: What is your development machine's OS (where you created the installation)?

[frayne]

I've reinstalled application on my Windows XP sp2 and generated a log file.
The program obviously works O.K. I'll try this out on a PC that generated the error tomorrow. Will it be O.K if I get back to you about the same time. Thanks for all your help SO FAR
Rob

[frayne]

Hi Randem
I installed the application on 2 PCs both XP sp2 and logged both.
1 ran O.K, my own of course. the other came up with the Data error previously mentioned.
I've looked at both logs to note any differences, but other than there was aslight variation in the version of Comdlg32.ocx both were identical and both registered successfully.
I noticed both had the following line.
2006-04-20 19:42:38 User privileges: Administrative
would this have any affect on the installation.?
Rob

[randem]

You failed to mention what the differences in the Comdlg32.ocx were.... If there was a variation... How could they be identical????

[frayne]

This is part of the log of my PC
2006-04-20 20:39:04 Dest filename: C:\WINDOWS\system32\comdlg32.ocx
2006-04-20 20:39:04 Time stamp of our file: 2006-03-24 16:02:14.000
2006-04-20 20:39:04 Dest file exists.
2006-04-20 20:39:04 Time stamp of existing file: 2004-03-09 00:00:00.000
2006-04-20 20:39:04 Version of our file: 6.0.84.18
2006-04-20 20:39:04 Version of existing file: 6.1.97.82
2006-04-20 20:39:04 Existing file is a newer version. Skipping.
2006-04-20 20:39:04 Will register the file (a DLL/OCX) later.

This is part of the log of the failed P.C
2006-04-20 19:43:03 Dest filename: C:\WINDOWS\system32\comdlg32.ocx
2006-04-20 19:43:04 Time stamp of our file: 2006-03-24 16:02:14.000
2006-04-20 19:43:04 Dest file exists.
2006-04-20 19:43:04 Time stamp of existing file: 2001-03-13 14:49:28.000
2006-04-20 19:43:04 Version of our file: 6.0.84.18
2006-04-20 19:43:04 Version of existing file: 6.0.84.18
2006-04-20 19:43:04 Same version. Skipping.
2006-04-20 19:43:04 Will register the file (a DLL/OCX) later.

[frayne]

Apart from the VB6 runtime and my own files this is what ********** generated from PDW setup.lst

Source: f:\calcfinal\calcvb\package\support\mdac_typ.exe; DestDir: {app}; Flags: ignoreversion
Source: f:\calcfinal\calcvb\package\support\comdlg32.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\package\support\mscomctl.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\package\support\mscomct2.ocx; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: c:\program files\common files\system\ado\msado25.tlb; DestDir: {sys}; Flags: uninsneveruninstall sharedfile regtypelib
Source: f:\calcfinal\calcvb\package\support\vb5db.dll; DestDir: {sys}; Flags: sharedfile
Source: f:\calcfinal\calcvb\package\support\msrd2x35.dll; DestDir: {sys}; Flags: regserver restartreplace sharedfile
Source: f:\calcfinal\calcvb\package\support\msjint35.dll; DestDir: {sys}; Flags: restartreplace sharedfile
Source: f:\calcfinal\calcvb\package\support\msjter35.dll; DestDir: {sys}; Flags: restartreplace sharedfile
Source: f:\calcfinal\calcvb\package\support\dao350.dll; DestDir: {dao}; Flags: regserver restartreplace sharedfile

[randem]

Don't use ********** on your Setup.lst file you will just find the same files PDW did (which may be faulty). Use ********** on your VBP and see if there are any differences to the files it retrieves.

[frayne]

Below is a list of files in order that my applications data form load requires.
Could you tell me from my initial ********** are there any files here that I need to Add for my application to work on other P.Cs

OLE32.DLL
clbcatq.dll
compres.dll
version.dll

ADVAPI32.DLL
msi.dll

DAO360.DLL
msjet40.dll
mswstr10.dll
vbajet32.dll - expsrv.dll

MSJTES40.DLL
vbajet32.dll

MSVBVM60.DLL
vb5db.dll

[randem]

How can I be able to tell??? Did you run ********** on the VBP file? After running on the VBP file then the script should have everything that you need. Post the script after running ********** on the VBP, then I can possibly tell.

[frayne]

Randem
The ********** is already on the post above.And as I have stated the resulting application does not run on some P.Cs. My last post was the result of using Dependency Walker and noting the files that were required to open up the data form that gives the Data error on some other P.C's. and the question is: Comparing the ********** file to the actual DLLs that opened the data form on my P.C and should I add to the ********** file.
Rob

[randem]

Sorry,

You had mentioned the Setup.lst file. None of the files you listed should be added. They should only be added with MS service packs. You will need to put code in your app to find out exactly where you are getting the errors.

Look into using ******* to help you (check signature for app).

[frayne]

I will look into the code, Thanks for the help Randem
Rob

[frayne]

[frayne]

I formatted an old PC, installed XP Home and installed my application.
The error (Data err event hit error etc) came up when I clicked on a command button to open Data Form.
I installed the program Dependency Walker and ran a profile of the my applications EXE.
This was what it found at the point of error.
00:00:10.718: LoadLibraryA("VB5DB.DLL") called from "MSVBVM60.DLL" at address 0x6600473A.
00:00:10.734: LoadLibraryA("VB5DB.DLL") returned NULL. Error: The specified module could not be found (126).
I copied the missing VB5DB.DLL to the windows/system32 folder and everything working O.K

Rob

[randem]

That file is put there by a SP and is part of the OS. You do not need to deploy it. What OS are you deploying to?

[frayne]

I see now that the program will work on P.Cs that have applied the relevant Sps, but unfortunately not everyone does this upgrade.
I tested the program on a clean PC I've set up with a basic XP home with no SP1 or SP2. I needed to do this to find the missing dependency file.
Rob

[randem]

I needed to do this to find the missing dependency file.
Rob

No, You do not do it that way!!!! You should only test to see if you have done the installation correctly. Your process should be to test to see if they have the proper upgrades before you attempt installation then notify the user that they need to do something for the installation to continue.

Note: This should all be in your documentation under Minimum Requirements

[frayne]

Yes, I see your point Randem. I have to thank you for your endearing support of an Old novice.
Incidentally PDW tells me vb5db.dll is needed / ********** does not.
Rob

[randem]

You are welcome.

Yes PDW does tell you that it is needed. But it should not be deployed. ********** tells you that it removed it so that it will not be deployed.