SQLDMO not found

Started by Randem, April 14, 2011, 09:40:06 PM

Previous topic - Next topic

Randem

BO FixPack 3.5 - Business Objects Fixpack 3.5
 
Ok, then you should place those lines in the Unsafe File list so that they do not get deployed. When you deploy your app you can always add the fixpack 3.5 if you need it.
 
Crystal Reports 11.5 Release 2 already has Fixpack 3.6 included so there should be no reason to deploy it separately.

bibin98

Hi randem, sorry I just reply youe message...
 
> Are you attempting to install the BO FixPack 3.5 here?  
I don;t understand what is BO FixPack? InnoScript automatically write that line

Randem

Are you attempting to install the BO FixPack 3.5 here?  
 
Source: C:Program FilesBusiness ObjectsCommon3.5binCRTOWORDS_EN.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binUFMANAGER.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binQUERYBUILDER.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCHARTUI.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRANALYZER.DLL; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRDB_DICTIONARY.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRXF_PDF.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRXF_RTF.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRXF_WORDW.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRXF_XLS.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binU2FXML.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRDEPLOY.REG; DestDir: {app}; Flags: ignoreversion;
Source: C:Program FilesBusiness ObjectsCommon3.5binPARAMETERDESIGNER.DLL; DestDir: {sys}; Flags: regserver restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binCRLOV.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:Program FilesBusiness ObjectsCommon3.5binXERCES-C_2_1_0.DLL; DestDir: {sys}; Flags: restartreplace sharedfile;

Randem

It can be added. What happens when you add it? If InnoScript does not find any files in the folder you place in the search tab it will remove it for there is no reason to search there.

bibin98

OK thanks 4 the advice.... I mean that I want to create installer that compatible with x32 or x64 environment, so I put VB_VC_DCOM_MDAC_JET_AutoSetup.exe in my project. I think there is some bugs in InnoScript in Search Tab, I want to add C:Program FilesMicrosoft SQL Server80ToolsBinn but it cannot be added (I think that it's not the last folder cause the last folder is C:Program FilesMicrosoft SQL Server80ToolsBinnResource)

Randem

Ok, one thing you should deselect VB_VC_DCOM_MDAC_JET_AutoSetup.exe from the installation and let InnoScript automatically put in the smaller versions of the needed components (MDAC/JET). Just deselect the Auto OS Updater then re-run InnoScript.
 
You have a 32 bit application, why would you want to try to install it in a 64 bit software location?

bibin98

; InnoScript Version 10.5  Build 5
; Randem Systems, Inc.
; Copyright (c) 2002 - 2011, Randem Systems, Inc.
; Website:  https://randemsystems.com
; 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.4.0 (a)
; Installed Inno Setup Version: 5.4.0 (a)
 
; Date: April 15, 2011
 
; 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\Administrator\Application Data\Randem Systems\InnoScript\
; {localappdata}  : C:\Documents and Settings\Administrator\Local Settings\Application Data\Randem Systems\InnoScript\
; {cf}            : C:\Program Files\Common Files\Randem Systems
; {tmp}           : C:\Documents and Settings\Administrator\Local Settings\Temp\
; {commonappdata} : C:\Documents and Settings\All Users\Application Data\Randem Systems\InnoScript\Release\
; {pf}            : C:\Program Files\
 
;              VB Runtime Files Folder:   C:\Program Files\Randem Systems\InnoScript\InnoScript 10\VB 6 Redist Files\
;     Visual Basic Project File (.vbp):   D:\Project VB\Silvia Cell\PrSilviaCell.vbp
; Inno Setup Script Output File (.iss):   D:\Project VB\Silvia Cell\Scripts\PrSilviaCell 1.0.0 Release.iss
;:   C:\Documents and Settings\Administrator\Local Settings\Application Data\Randem Systems\InnoScript\Release\Templates\ComponentOne.tpl
;:   C:\Documents and Settings\Administrator\Local Settings\Application Data\Randem Systems\InnoScript\Release\Templates\Release.tpl
;:   D:\Project VB\Silvia Cell\installer\Templates\SilviaCell.tpl
;:   C:\Documents and Settings\Administrator\Local Settings\Application Data\Randem Systems\InnoScript\Release\Templates\AutoOSUpdater.tpl
;:   C:\Documents and Settings\Administrator\Local Settings\Application Data\Randem Systems\InnoScript\Release\Templates\Crystal Reports.tpl
;:   C:\Documents and Settings\Administrator\Local Settings\Application Data\Randem Systems\InnoScript\Release\Templates\Sqldmo.tpl
 
; ------------------------
;        References
; ------------------------
 
; Microsoft ActiveX Data Objects 2.7 Library - (msado27.tlb)
; Microsoft Data Binding Collection VB 6.0 (SP4) - (msbind.dll)
; Microsoft SQLDMO Object Library - (sqldmo.dll)
; Microsoft Data Formatting Object Library 6.0 (SP6) - (MSSTDFMT.DLL)
; Crystal Reports ActiveX Designer Design and Runtime Library 11.5 - (craxddrt.dll)
; Microsoft Scripting Runtime - (scrrun.dll)
 
 
; --------------------------
;        Components
; --------------------------
 
; ComponentOne True DBDate 8.0 - (tidate8.ocx)
; Data Dynamics ActiveBar 2.0 - (Actbar2.ocx)
; ActiveSplash 1.0 Type Library - (actsplash.ocx)
; ComponentOne True DBNumber 8.0 - (tinumb8.ocx)
; Crystal ActiveX Report Viewer Library 11.5 - (CRViewer.dll)
; Microsoft Windows Common Controls 6.0 (SP6) - (MSCOMCTL.OCX)
; ComponentOne True DBGrid Pro 8.0 (OLEDB) - (todg8.ocx)
; Microsoft Common Dialog Control 6.0 (SP6) - (Comdlg32.ocx)
; ComponentOne True DBList Pro 8.0 (OLEDB) - (todl8.ocx)
; FindButton by Bibin - (FindButton.ocx)
 
 
[Setup]
SetupLogging=Yes
AppId=Silvia Cell 2011  
 
;------------------------------------------------------------------------------------------------------------------------
; Taken from VBP/VBG Project File Parameters AppName, AppName AppVersion and Company
;------------------------------------------------------------------------------------------------------------------------
 
AppName=Silvia Cell 2011 1.0.0
AppVerName=Silvia Cell 2011  
AppPublisher=Performance Edition Dec 2009
 
;------------------------------------------------------------------------------------------------------------------------
 
AppVersion=1.0.0
VersionInfoVersion=1.0.0
AllowNoIcons=yes
DefaultGroupName=Performance Edition Dec 2009\PrSilviaCell  
DefaultDirName={pf}\PrSilviaCell 1  
PrivilegesRequired=None
MinVersion=0,5.01
OnlyBelowVersion=0,6.0
Compression=lzma
OutputBaseFilename=SilviaCell0100000Release
 
[Tasks]
Name: Desktopicon; Description: {cm:CreateDesktopIcon}; GroupDescription: {cm:AdditionalIcons}
Name: AutoOSUpdater; Description: Install Database Support Updater; GroupDescription: Database Support:
Name: SQLDMOInstallation; Description: Install SQLDMO for SQL Server; GroupDescription: Database Support:; Check: IsSQLDMOInstalled;
Name: ScriptingRuntime; Description: Install Microsoft's Scripting Runtime; GroupDescription: Install Scripting Runtime:
Name: CRInstallation; Description: Install Crystal Reports Runtime Files; GroupDescription: Install CR Runtime Files:
 
[Files]
Source: C:\Program Files\Randem Systems\InnoScript\InnoScript 10\VB_VC_DCOM_MDAC_JET_AutoSetup.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; AfterInstall: InstallAutoOSUpdater('{tmp}\VB_VC_DCOM_MDAC_JET_AutoSetup.exe','/NORESTART /VERYSILENT'); Tasks: AutoOSUpdater;
Source: C:\Program Files\Randem Systems\InnoScript\InnoScript 10\scripten.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; MinVersion: 0,5.0; OnlyBelowVersion: 0,5.02; Tasks: ScriptingRuntime
Source: C:\Program Files\Randem Systems\InnoScript\InnoScript 10\CRXI_5_RDC_Redistribution.msi; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: CRInstallation
Source: D:\Project VB\Silvia Cell\toolbar.tb2; DestDir: {app}; Flags:  ignoreversion;  
Source: D:\Project VB\Silvia Cell\1.jpg; DestDir: {app}; Flags:  ignoreversion;  
Source: D:\Project VB\Silvia Cell\2.jpg; DestDir: {app}; Flags:  ignoreversion;  
Source: D:\Project VB\Silvia Cell\3.jpg; DestDir: {app}; Flags:  ignoreversion;  
Source: D:\Project VB\Silvia Cell\Background.jpg; DestDir: {app}; Flags:  ignoreversion;  
Source: D:\Project VB\Silvia Cell\Config.lic; DestDir: {app}; Flags:  ignoreversion;  
Source: D:\Project VB\Silvia Cell\scell.spl; DestDir: {app}; Flags:  ignoreversion;  
Source: C:\WINDOWS\system32\tidate8.ocx; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:\Program Files\Common Files\Data Dynamics\ActiveBar2\Actbar2.ocx; DestDir: {cf}\Data Dynamics\ActiveBar2\; Flags:  regserver restartreplace sharedfile;  
Source: C:\WINDOWS\system32\actsplash.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\WINDOWS\system32\tinumb8.ocx; DestDir: {sys}; Flags: restartreplace sharedfile;
Source: C:\WINDOWS\system32\MSCOMCTL.OCX; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\WINDOWS\system32\todg8.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\WINDOWS\system32\Comdlg32.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\WINDOWS\system32\todl8.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\WINDOWS\system32\FindButton.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: D:\Project VB\Silvia Cell\SilviaCell.exe; DestDir: {app}; Flags:  ignoreversion restartreplace;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRTOWORDS_EN.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\UFMANAGER.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\QUERYBUILDER.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CHARTUI.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRANALYZER.DLL; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRDB_DICTIONARY.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRXF_PDF.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRXF_RTF.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRXF_WORDW.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRXF_XLS.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\U2FXML.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRDEPLOY.REG; DestDir: {app}; Flags:  ignoreversion;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\PARAMETERDESIGNER.DLL; DestDir: {sys}; Flags:  regserver restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\CRLOV.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
Source: C:\Program Files\Business Objects\Common\3.5\bin\XERCES-C_2_1_0.DLL; DestDir: {sys}; Flags:  restartreplace sharedfile;  
;
; Source locations may need to be modified to your SQL Server installation location in order to find the SQL Server files below.
; These files should not be deployed if the SQL Server Client has already been installed on the target system.
;
Source: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.DLL; DestDir: {cf}\SqlServer\Binn\; Flags:  regserver restartreplace sharedfile; Tasks: SQLDMOInstallation;  
Source: C:\Program Files\Microsoft SQL Server\80\Tools\*.*; DestDir: {cf}\SqlServer\; Flags: ignoreversion recursesubdirs; Tasks: SQLDMOInstallation;  
 
[INI]
Filename: {app}\SilviaCell.url; Section: InternetShortcut; Key: URL; String:  
 
[Icons]
Name: {group}\PrSilviaCell ; Filename : {app}\SilviaCell.exe; WorkingDir: {app}; IconFilename: {app}\PrSilviaCell.ico;
Name: {group}{cm:ProgramOnTheWeb, PrSilviaCell }; Filename: {app}\SilviaCell.url; IconFilename: {app}\PrSilviaCell.ico;
Name: {group}{cm:UninstallProgram, PrSilviaCell }; Filename: {uninstallexe};
Name: {commondesktop}\PrSilviaCell ; Filename: {app}\SilviaCell.exe; Tasks: Desktopicon ; WorkingDir: {app}; IconFilename: {app}\PrSilviaCell.ico;
 
[Run]
Filename: {tmp}\scripten.exe; Parameters: /quiet /passive; MinVersion: 0,5.0; OnlyBelowVersion: 0,5.02; WorkingDir: {tmp}; Flags: skipifdoesntexist runascurrentuser; Tasks: ScriptingRuntime
Filename: msiexec.exe; Parameters: /package CRXI_5_RDC_Redistribution.msi /passive /promptrestart /l* {sd}\CRXI_5_RDC_Redistribution.msi.txt; WorkingDir: {tmp}; Flags: skipifdoesntexist runascurrentuser; Tasks: CRInstallation
; Register the Crystal Reports Merge Module components that need to be registered in place where the Merge Modules installed them
Filename: regsvr32.exe; Parameters: /s {code:GetCLSIDFldr|!F62B9FA4-455F-4FE3-8A2D-205E4F0BCAFB@\11.5}{code:LogFileName|crviewer.dll}; WorkingDir: {code:GetCLSIDFldr|!F62B9FA4-455F-4FE3-8A2D-205E4F0BCAFB@\11.5}\; StatusMsg: Registering Crystal ActiveX Report Viewer Library 11.5; Tasks: CRInstallation; Flags: runascurrentuser
Filename: regsvr32.exe; Parameters: /s {code:GetCLSIDFldr|!4FB2D832-C996-4EB1-BE0D-4DE953CF25F0@\11.5.0.313}{code:LogFileName|craxddrt.dll}; WorkingDir: {code:GetCLSIDFldr|!4FB2D832-C996-4EB1-BE0D-4DE953CF25F0@\11.5.0.313}\; StatusMsg: Registering Crystal Reports ActiveX Designer Design and Runtime Library 11.5; Tasks: CRInstallation; Flags: runascurrentuser
Filename: regsvr32.exe; Parameters: /s {code:GetCLSIDFldr|\11.5.0.313}{code:LogFileName|sacommoncontrols.dll}; WorkingDir: {code:GetCLSIDFldr|\11.5.0.313}\; StatusMsg: Registering Crystal Analysis Common Controls 11.5; Tasks: CRInstallation; Flags: runascurrentuser
Filename: regsvr32.exe; Parameters: /s {code:GetCLSIDFldr|\11.5.0.313}{code:LogFileName|saxmlserialize.dll}; WorkingDir: {code:GetCLSIDFldr|\11.5.0.313}\; StatusMsg: Registering Crystal Analysis XML Serialization Type Library 11.5; Tasks: CRInstallation; Flags: runascurrentuser
Filename: regsvr32.exe; Parameters: /s {code:GetCLSIDFldr|\11.5.0.313}{code:LogFileName|sacommlayer.dll}; WorkingDir: {code:GetCLSIDFldr|\11.5.0.313}\; StatusMsg: Registering Crystal Analysis Communication Layer Library 11.5; Tasks: CRInstallation; Flags: runascurrentuser
Filename: regsvr32.exe; Parameters: /s {code:GetCLSIDFldr|\11.5.0.313}{code:LogFileName|prompt.dll}; WorkingDir: {code:GetCLSIDFldr|\11.5.0.313}\; StatusMsg: Registering Crystal Reports Prompting 1.0 Type Library 11.5; Tasks: CRInstallation; Flags: runascurrentuser
Filename: {app}\c1regsvr.exe; Parameters: /u tidate8.ocx; Flags: skipifdoesntexist; WorkingDir: {app}
Filename: {app}c1regsvr.exe; Parameters: /u tinumb8.ocx; Flags: skipifdoesntexist; WorkingDir: {app}  
Filename: {app}\SilviaCell.exe; Description: {cm:LaunchProgram, PrSilviaCell }; Flags: nowait postinstall skipifsilent runascurrentuser; WorkingDir: {app}
 
[UninstallDelete]
Type: files; Name: {app}\SilviaCell.url
Type: dirifempty; Name: {app}
 
 
[InstallDelete]
Type: files; Name: {app}\Install.log;
 
[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]
Procedure InstallAutoOSUpdater(Filename: String; Param: String);
var
  ErrorCode: Integer;
  begin
     ShellExec('', ExpandConstant(Filename), ExpandConstant(Param), '', SW_SHOW, ewWaitUntilTerminated, ErrorCode);
  end;
function IsSQLDMOInstalled(): boolean;
var
OK: variant;
  begin
       Result := False;
       try
            OK := CreateOleObject('SQLDMO.SQLServer');
       except
            Result := True;
       end;
   end;
 
//============================================================================
// Get the CLSID from the registry for the queried file to locate where this file was installed by the CR merge module
// We do this so that we know where to register the file after installation.
//============================================================================
 
function GetCLSIDFldr(Param: String): String;
var
  Location: String;
  CSLID: String;
  LogFile: String;
  sStr: String;
begin
  CSLID := Param;
  StringChangeEx(CSLID, '!', '{', True);
  StringChangeEx(CSLID, '@', '}', True);
 
  LogFile := ExpandConstant('{app}')   '\Install.log';
  SaveStringToFile(LogFile, #13#10   CSLID   #13#10, True);
 
  if not RegQueryStringValue(HKEY_CLASSES_ROOT, 'TypeLib\'   CSLID   '\0\win32','', Location) then
     Result := 'Not Registered !!!'   #13#10   'Possible Wrong Crystal Reports Version Installed on Source Machine or '   #13#10   'Wrong CRystal Reports Merge Module Installed on Target Machine'   #13#10;
     
  begin
    Location := ExpandConstant(Location)
    sStr := #13#10   Location   #13#10   StringOfChar('*',70)   #13#10
    SaveStringToFile(LogFile, sStr, True);
    Result := ExtractFileDir(Location);
  end;
end;
 
//-----------------------------------------------------------------------------------------------------------------
// Log the filename process to a log file  
//-----------------------------------------------------------------------------------------------------------------
 
function LogFileName(Filename: String): String;
var
  LogFile: String;
  sSTr: String;
begin
  LogFile := ExpandConstant('{app}')   '\Install.log';
  sStr := #13#10   'Registering '   Filename   #13#10;
  SaveStringToFile(LogFile, sStr, True);
  Result := Filename;
end;
 
//============================================================================

Randem

You should not put the file or any file in Program Fles 64. That file is not a 64 bit file and should be installed in the 32 bit program files folder.
 
Please post you script so I can get a clear picture of what you are attempting to accomplish.

bibin98

The file SQLDMO.dll is in C:Program FilesMicrosoft SQL Server80ToolsBinn
 
But I have add itu in the Search Tab, but it can't be shown cause it isn't the last folder (I thought), so I change the Source line inside the SQLDMO.tpl to C:Program Files
 
Any suggestion so it can be run in ProgramFiles x64? Thanks

bibin98

Looks like I have to fill the .. in the source, I have fill it with {pf} but still don't want to redirect to C:Program Files, what is the function to redirect to Program Files? Thx

Randem

I can only vaguely answer your question as to not enough information was given. If you have SQL Server installed and you have included it in your project then it should be in the location you have posted. Posting only one line of a script will not help much as things in the script may be relative.
 
Basically you need to add the folder location of this file in the search tab.

bibin98

Hi randem, I just meet error that SQLDMO not found  
 
Source: ..Microsoft SQL Server80ToolsBinnSQLDMO.DLL; DestDir: {cf}SqlServerBinn; Flags:  regserver restartreplace sharedfile; Tasks: SQLDMOInstallation;  
 
How can I fix this error?
 
Thanks