Randem Systems Support Board

Hi:
 
I had create a script that is for installed my apllication in a Windows Vista...The instalation work well but when I start the aplication I have this error:
 
The suplier microsoft.jet.oledb.4.0 it's not registered in the local computer
 
Any tip for resolve this?
 
Thanks

Without seeing the script, I would have no idea of where to start... All I can do is guess that you haven't installed the Jet engine...
 
Please show your script

Hi Randem:
Thanks for your reply...I'm sory,but i just can send you the script only next monday ok?I'm leave this 3 days out of the office...

Yes, post the script whenever you can. Did you use the Auto OS Updater from our site or something else to install the jet engine?

Yes I use your Auto OS updater

Does it run when you install your app?
How have you included it as an internal install or an external install?
Is your application on the internet as a download? I could run it to see...

Does it run when you install your app?
yes
 
How have you included it as an internal install or an external install?
Internal install I presume
 
Is your application on the internet as a download?  
No
}

OK, then it sounds like your connection string is an issue. Post your connection string when you get a chance.

Hi randem:
 
The script:
 
; 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.NET Project File
 
; Designed for Inno Setup Version: 5.2.3
; Installed Inno Setup Version: 5.2.3
 
; 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\Manuel Sacramento\Application Data\Randem Systems\innoscript\Release\
; {localappdata}  : C:\Documents and Settings\Manuel Sacramento\Local Settings\Application Data\Randem Systems\innoscript\Release\
; {cf}            : C:\Program Files\Common Files\Randem Systems
; {tmp}           : C:\Documents and Settings\Manuel Sacramento\Local Settings\Temp\
; {commonappdata} : C:\Documents and Settings\All Users\Application Data\Randem Systems\innoscript\Release\
; {pf}            : C:\Program Files\
 
; Date: Outubro 08, 2009
 
; Visual Basic .NET Project File (.vbproj):   F:\CONTAWIN\CONTAWIN\CONTAWIN\CONTAWIN.vbproj
;     Inno Setup Script Output File (.iss):   F:\InnoScript projectos\contawin Release.iss
;             Script Template Files (.tpl):   C:\Documents and Settings\Manuel Sacramento\Local Settings\Application Data\Randem Systems\innoscript\Release\Templates\Release.tpl
;                                         :   C:\Documents and Settings\Manuel Sacramento\Local Settings\Application Data\Randem Systems\innoscript\Release\Templates\DotNET.tpl
 
[Setup]
SetupLogging=Yes
AppId=Contawin  
 
;------------------------------------------------------------------------------------------------------------------------
; Taken from VBPROJ Project File Parameters Root Namespace, Root NameSpace Assembly Version and Company
;------------------------------------------------------------------------------------------------------------------------
 
AppName=Contawin 1.0.001
AppVerName=Contawin  
AppPublisher=Manuel Sacramento
 
;------------------------------------------------------------------------------------------------------------------------
 
AppVersion=1.0.001
VersionInfoVersion=1.0.001
AllowNoIcons=no
DefaultGroupName=CONTAWIN  
DefaultDirName={pf}\CONTAWIN  
AppCopyright=
PrivilegesRequired=None
MinVersion=0,6.0
Compression=lzma
OutputBaseFilename=ContawinRelease
 
[Tasks]
Name: desktopicon; Description: {cm:CreateDesktopIcon}; GroupDescription: {cm:AdditionalIcons}
Name: DotNetFrameWork; Description: Install .Net Framework; GroupDescription: Install .Net Framework:; Check: InstallDotNET20
Name: AutoOSUpdater; Description: Install Support for Database Operations; GroupDescription: Install Database Support:
 
[Files]
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\VB_DCOM_MDAC_JET_AutoSetup.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: AutoOSUpdater
Source: C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\DotNetFX\dotnetfx.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: DotNetFrameWork
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\BalancoReduzidoReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\ContaWin.mdb; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\Declaracao_iva.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DemonstracaoAlteracoesCapitalReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DemonstracaoAlteracoesCapitalReportN-1.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DRFluxosCaixaDirecto.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DRFluxosCaixaIndirecto.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DRFuncoesNormalReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DRFuncoesReduzidoReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DRNormalReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\DRReduzidoReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\ExtractosContaCCReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\ExtractosContaFlxReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\ExtractosContaReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\ListagemLancamentosReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaConferenciaReembolsosClientes.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaConferenciaReembolsosFornecedores.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaConferenciaReembolsosRegularizacoes.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaReembolsosClientes.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaReembolsosFornecedores.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaReembolsosRegularizacoes.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\MapaRetencao.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\Plano_Contas.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\Plano_Contas_detalhado.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\BalanceteAnaliticoReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\BalanceteCaixaReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\BalanceteClasse9Analitico.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\BalanceteRazaoReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\BalancoNormalReport.rpt; DestDir: {app}; Flags:  ignoreversion;  
Source: F:\CONTAWIN\CONTAWIN\CONTAWIN\bin\Debug\CONTAWIN.exe; DestDir: {app}; Flags:  ignoreversion restartreplace;  
Source: C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CrystalDecisions.CrystalReports.Engine.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CrystalDecisions.Shared.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\4.0\managed\dotnet2\CrystalDecisions.Windows.Forms.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Data.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Drawing.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Windows.Forms.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Xml.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Core.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Xml.Linq.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\Debugger\BCL\System.Data.DataSetExtensions.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\WINDOWS\$NtServicePackUninstall$\VERSION.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;
Source: C:\WINDOWS\$NtServicePackUninstall$\ntdll.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;
Source: C:\WINDOWS\$hf_mig$\KB933729\SP2QFE\RPCRT4.dll; DestDir: {sys}; Flags:  restartreplace sharedfile;  
 
[INI]
Filename: {app}\CONTAWIN.url; Section: InternetShortcut; Key: URL; String:  
 
[Icons]
Name: {group}\CONTAWIN ; Filename : {app}\CONTAWIN.exe; WorkingDir: {app}
Name: {group}{cm:ProgramOnTheWeb, CONTAWIN }; Filename: {app}\CONTAWIN.url; IconFilename: {app}\CONTAWIN.ico
Name: {group}{cm:UninstallProgram, CONTAWIN }; Filename: {uninstallexe}
Name: {commondesktop}\CONTAWIN ; Filename: {app}\CONTAWIN.exe; Tasks: desktopicon; WorkingDir: {app}
 
[Run]
Filename: {tmp}\dotnetfx.exe; Parameters: /q:a /c: install /l /q; WorkingDir: {tmp}; Flags: skipifdoesntexist runascurrentuser; Tasks: DotNetFrameWork
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist runascurrentuser; Tasks: AutoOSUpdater
Filename: {app}\CONTAWIN.exe; Description: {cm:LaunchProgram, CONTAWIN }; Flags: nowait postinstall skipifsilent; WorkingDir: {app}
 
[UninstallDelete]
Type: files; Name: {app}\CONTAWIN.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).
 
[Code]
// To implement these calls they should be used in the Run Section on the line that runs the dotnetfx.exe
// file. To use add to the line      Check: InstallDotNET20
// This will check to see if Version .NET 2.0 Framework needs to be installed and if true then it will run
// the entry on the line that call the routine, If false then it will not. Of course change it to the version that you have included
// in the script.
 
 
// Indicates whether .NET Framework 1.1 is installed.
function IsDotNET11Detected(): boolean;
var
    success: boolean;
    install: cardinal;
begin
    success := RegQueryDWordValue(HKLM, 'SOFTWARE\Microsoft\NET Framework Setup\NDP\v1.1.4322', 'Install', install);
    Result := success and (install = 1);
end;
 
//RETURNS OPPOSITE OF IsDotNet11Detected FUNCTION
function InstallDotNET11(): Boolean;
begin
  Result := (IsDotNET11Detected = false);
end;
 
 
 
// Indicates whether .NET Framework 2.0 is installed.
function IsDotNET20Detected(): boolean;
var
    success: boolean;
    install: cardinal;
begin
    success := RegQueryDWordValue(HKLM, 'SOFTWARE\Microsoft\NET Framework Setup\NDP\v2.0.50727', 'Install', install);
    Result := success and (install = 1);
end;
 
//RETURNS OPPOSITE OF IsDotNet20Detected FUNCTION
function InstallDotNET20(): Boolean;
begin
  Result := (IsDotNET20Detected = false);
end;
 
 
 
 
// Indicates whether .NET Framework 3.0 is installed.
function IsDotNET30Detected(): boolean;
var
    success: boolean;
    install: cardinal;
begin
    success := RegQueryDWordValue(HKLM, 'SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.0', 'Install', install);
    Result := success and (install = 1);
end;
 
//RETURNS OPPOSITE OF IsDotNet20Detected FUNCTION
function InstallDotNET30(): Boolean;
begin
  Result := (IsDotNET30Detected = false);
end;

Hi,
 
You are asking for trouble installing these files
 
Source: C:WINDOWS$NtServicePackUninstall$VERSION.dll; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:WINDOWS$NtServicePackUninstall$ntdll.dll; DestDir: {sys}; Flags: restartreplace sharedfile;  
 
As for the Automatic OS Updater; it is not automatically run unless the user selects it to run. If you want it to be checked by default you will need to change the line to:
 
Name: AutoOSUpdater; Description: Install Support for Database Operations; GroupDescription: Install Database Support:; Flags: checked
 
 
Also what is the date/time stamp on the Auto OS Updater exe file?
 
You seem to be using DAO for your reports which uses datagrids, correct?

Hi:
 
As for the Automatic OS Updater; it is not automatically run unless the user selects it to run
 
Answear:In fact the setup ask if the user want install the OS updater,but the option are checked by default
 
 
Also what is the date/time stamp on the Auto OS Updater exe file?  
 
Answear - In the modified setting of the file the date is 11-03-2008 - 32,5MB
 
You seem to be using DAO for your reports which uses datagrids, correct?
 
Answear - No...In this project I only use ADO
 
}

In your CR reports, they use DAO unless you specifically change them to ADO and write code for them. Was that the case?
 
Are you using datagrids?
 
Another thing, are you using a ODBC or DSN connection?

In your CR reports, they use DAO unless you specifically change them to ADO and write code for them. Was that the case?  
 
}Yes..My code are all to ADO...
 
Are you using datagrids?  
 
}Yes...Datagridview...
 
Another thing, are you using a ODBC or DSN connection?
}No......

Ok, now in Vista the Auto OS Updater does not actually install the MDAC or VB runtime files because Vista has the MDAC and VB runtime files installed already. However the OS Updater does install MDAC 2.0 and Jet 3.5. It seems you need Jet 4.0 which was already installed in Vista and was somehow corrupted it seems. Jet 4.0 for Vista may need to be re-installed. I don't know if there is a seperate installation for it so perhaps you may need to re-install a recent Vista SP to get it back.
 
Have you attempted to install the Jet engines separately prior to now?

In fact No...
 
Ok...What is your suggestion to do?
Re-Intall the recent Vista SP?
 
One more problem Randem it

I will check but we only have the merge modules up to 11.5. Check on the Business Objects website to see if they have released merge modules for CR 12.
 
As for the jet engine, search your HD for a file named Msjet40.dll then register it to see if that works. Your version should be 4.0.9635.0 for    Windows Vista

ok

Oh, Also if you are running a 64bit version of Vista; there is no jet engine for it.

UAU...this is a big problem...
The system that i want install the project it's a Windows Vista 64 bit...
 
In this case what is the solutions?

Randem can you in this link,about CR, if this is usefull for you...
 
http://resources.businessobjects.com/support/additional_downloads/runtime.asp#09 (http://resources.businessobjects.com/support/additional_downloads/runtime.asp#09)

Hi Randem:
 
Maybe some people could be the same problem that I have,and serching in the internet I had found the post bellow...I had try and now the problem is resolved...
 
 
If you try and open an access database on a 64bit os you will get the following error. System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. To prevent this open My Project -> compile -> advanced compiler options and set the target cpu to x86. There currently is not a 64bit version of the provider by selecting the x86 option you force the framework to use the 32 bit version.
 
 
It's was very good if you could integrate the new merge modules,of Crystal reports, for Visual Studio 2008 in the innoscript...
If you create a publish setup in the VS2008 you could incorporate in pr

Very good information. I did see something about forcing the framework to use 32bit Jet by changing XML in VS also. But I did not see anything about deploying that fix. It seems that the fix is for your development system and you may need to have the customer apply the same fix to get Jet to run on their system.
 
I will look into creating a new installation for CR VS 2008.
 
Here are some other things about Jet 4.0 for Vista 64
 
http://support.microsoft.com/kb/943509 (http://support.microsoft.com/kb/943509)
http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/22a7474c-b54d-4be0-928b-acc8b0a5a091/ (http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/22a7474c-b54d-4be0-928b-acc8b0a5a091/)

Yes...very good links too...
 
Thanks

sacremento,
 
CR 12 will be incorporated in the next release.

Hi Randem:
 
This was a great news...
Very good job Randem
 
Thanks a lot

Sacremento,
 
The new version was released...

Thanks Randem for the good work