May 30, 2013
02:18 PM
Hi All, I have a string that will be a server location such as: http://localhost/ReportServer https://localhost/ReportServer http://localhost:85/ReportServer https://localhost:85/ReportServer How can I split the string (could be any of those four varities) to get seperate strings for each component like: http (or https) localhost 85 (if present) ReportServer
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
May 30, 2013
02:14 PM
Thanks so much, that was very helpful!
... View more
May 17, 2013
02:21 PM
Hi All, I am trying to add some additional functionality to the already existing SQLServerSelectLogin(Ex) dialog. I'm trying to get the the checkbox to already be checked and the edit box underneath it to have the same value of the database field (and possibly grayed out). I'd also like make it so if I uncheck the box, the text underneath is highlighted/editable. Is there a way to do this?
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
May 14, 2013
03:35 PM
Hi All, I have a simple script that I'm running to detect if MS SQL Server 2008 R2 or better is installed on a machine before the installation proceeds. It seems to work just fine on my Windows 7 32-bit machine but fails on my Windows 2008 64-bit machine. What looks like is happening is that it's reading only part of the registry keys (100, 90, etc) under HKLM\SOFTWARE\Microsoft\Microsoft SQL Server. On Win2K8 64-bit it's breaking because it's skipping right over MSSQL10_50.xxxxx. Any ideas what might be wrong? The SSRS section works fine. // Create list of prereqs that may be missing from the machine. // // Microsoft SSRS RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE); szMSSSRS = MSSSRS; szSubKey = "SOFTWARE\\Microsoft\\Microsoft SQL Server"; listResults = ListCreate(STRINGLIST); listPrereqs = ListCreate(STRINGLIST); listPrereqsMissing = ListCreate(STRINGLIST); nItem = REGDB_KEYS; nResult = 0; nStartRSVersion = 0; nLengthRSVersion = 9; nSSRSInstalled = -1; szValidRSVersion = "MSRS10_50"; RegDBQueryKey(szSubKey, nItem, listResults); // Get the first string in the list nResult = ListGetFirstString(listResults, szString); // Loop while (nResult != END_OF_LIST) // Extract characters from the current item in the list StrSub(svSubStr, szString, nStartRSVersion, nLengthRSVersion); if (svSubStr = szValidRSVersion) then nSSRSInstalled = 0; endif; // Get the next item in the list nResult = ListGetNextString(listResults, szString); endwhile; if (nSSRSInstalled != 0) then ListAddString(listPrereqsMissing, szMSSSRS, AFTER); endif; // Destroy list ListDestroy(listResults); // Microsoft SQL Server 2008 R2 RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE); szSubKey = "SOFTWARE\\Microsoft\\Microsoft SQL Server"; listResults = ListCreate(STRINGLIST); listPrereqs = ListCreate(STRINGLIST); listPrereqsMissing = ListCreate(STRINGLIST); nItem = REGDB_KEYS; nResult = 0; nStartSQLVersion = 0; nLengthSQLVersion = 10; nSQLServerInstalled = -1; szValidSQLVersion = "MSSQL10_50"; szMSSQLServer2008R2 = MSSQLSERVER2008R2; RegDBQueryKey(szSubKey, nItem, listResults); // Get the first string in the list nResult = ListGetFirstString(listResults, szString); // Loop while (nResult != END_OF_LIST) // Extract characters from the current item in the list StrSub(svSubStr, szString, nStartSQLVersion, nLengthSQLVersion); if (svSubStr = szValidSQLVersion) then nSQLServerInstalled = 0; endif; // Get the next item in the list nResult = ListGetNextString(listResults, szString); endwhile; if (nSQLServerInstalled != 0) then ListAddString(listPrereqsMissing, szMSSQLServer2008R2, AFTER); endif; // Destroy list ListDestroy(listSubKeys);
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
May 01, 2013
02:58 PM
Thanks, Phil. Before I did that I created a new variable for the buffer size and used it only for that MsiSetProperty and it worked fine. Thanks for your time and help!
... View more
May 01, 2013
01:24 PM
Thanks, Phil. I have nvSize initialized to 255.
... View more
May 01, 2013
10:35 AM
Hello, I am having an issue with an InstallScript MSI project. What’s happening is that when IS performs the MsiGetProperty( ISMSI_HANDLE, "IS_SQLSERVER_SERVER", szJPSSQLServer, nvSize ) action, I am not getting the desired result. In this case it should be writing “(local)” without quotes to the public property IS_SQLSERVER_SERVER. For some reason it is removing the last character and writing “(local” without the quotes. Dlg_SdStartCopy: szTitle = ""; szMsg = ""; // RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE); szSubKey = "SOFTWARE\\MyCompany\\MyApp"; RegDBSetKeyValueEx(szSubKey, "USERNAME", REGDB_STRING, szUserName, -1); RegDBSetKeyValueEx(szSubKey, "IS_SQLSERVER_SERVER", REGDB_STRING, szSQLServer, -1); // MessageBox(IS_SQLSERVER_SERVER, INFORMATION); MsiGetProperty( ISMSI_HANDLE, "IS_SQLSERVER_SERVER", szSQLServer, nvSize ); MessageBox(IS_SQLSERVER_SERVER, INFORMATION); MsiGetProperty( ISMSI_HANDLE, "PORTNUMBER", svPortNumber, nvSize );
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
Apr 30, 2013
08:04 AM
Hi All, I am working on a suite so I can install a main app and then a support app after it. Is there a way I can pass a PROPERTY from the main install to the support install afterwards? I'm trying to pass USERNAME and IS_SQLSERVER_SERVER from the main install to the support install. Thanks!
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
Apr 26, 2013
04:43 PM
Thanks for your reply, Robert! What's happening with my installer is that I am dropping the files down, configuring stuff, etc. All of that is working. I have a custom action running after InstallFinalize that restores databases from a folder that is on the machine. Next CA I'm trying to run will add the user (specified in the install and saved as USERNAME property) against the server name in IS_SQLSERVER_SERVER. I can't seem to get that last CA to run correctly. Originally I did it as an InstallScript but was unable to pass a PROPERTY to it (plus I think you can't run an InstallScript while an MSI is working even if it's run after InstallFinalize). I recreated as a Basic MSI and it works great from a CMDline and can pass the USERNAME and IS_SQLSERVER_SERVER properties to it and all is well. The problem is happening when I launch the Basic MSI from a CA. Any way you know of to achieve my desired results?
... View more
Apr 26, 2013
02:17 PM
Hi All, I'm having a tremendously frustrating time with getting error 1721 or error 1722 when trying to run a Custom Action to run a simple Basic MSI file. The error I'm getting is this: CustomAction AddUser_dbowner returned actual error code 1618 (note this may not be 100% accurate if translation happened inside sandbox) Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action AddUser_dbowner, location: C:\CheckSix\_Deploy\SQL\, command: C:\Windows\system32\msiexec.exe /i C:\CheckSix\_Deploy\SQL\AddUser_dbowner.msi /qn C6_USERNAME=win732-test\c6user IS_SQLSERVER_SERVER=(local) Action ended 17:04:45: AddUser_dbowner. Return value 3. Action ended 17:04:45: INSTALL. Return value 3. Everything looks ok in the statement and I have it running after another Custom Action which runs fine and launches after InstallFinalize. Any ideas?
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
Apr 23, 2013
05:17 PM
Hi All, I have a need to run a SQL script during my install, then run a batch file to restore databases that were installed onto the machine, then run a different script against those restored databases. Is there a way to do this in IS? I have the first two steps running correctly, just need to run another SQL script after the databases have been restored. Thanks!
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
Apr 22, 2013
10:18 AM
Hello All, I'm trying to have the install determine if IIS 7 or greater is installed. Is there a simple way to get this information? I see that HKLM\SOFTWARE\Microsoft\InetStp contains a string called VersionString but contains "Version 7.5". Is there a way to get that 7.5 value from to do a version check?
... View more
Labels
- Labels:
-
InstallShield 2012 Spring
Apr 11, 2013
01:56 PM
I'm using RegDBQueryKey to make a list of the keys in HKLM\Software\Microsoft\Microsoft SQL Server. I know I can use ListFindString to find a line of data in the queried list, but can I have it search for just part of a value? For example look for MSSQL10_50 instead of MSSQL10_50.MSSQLServer? I think the ListFindKeyValueString function might be the answer but I can't find any examples on how to use it. Thanks!
... View more
Latest posts by bbarton11
Subject | Views | Posted |
---|---|---|
781 | May 31, 2013 09:16 AM | |
1748 | May 30, 2013 02:18 PM | |
750 | May 30, 2013 02:14 PM | |
1805 | May 17, 2013 02:21 PM | |
1428 | May 14, 2013 03:35 PM | |
1106 | May 01, 2013 02:58 PM | |
1106 | May 01, 2013 01:24 PM | |
1877 | May 01, 2013 10:35 AM | |
865 | Apr 30, 2013 08:04 AM | |
1542 | Apr 26, 2013 04:43 PM |
Activity Feed
- Posted Re: How do I split a string? on InstallShield Forum. May 31, 2013 09:16 AM
- Posted How do I split a string? on InstallShield Forum. May 30, 2013 02:18 PM
- Posted Re: Adding Functionality to an Existing SQL Dialog on InstallShield Forum. May 30, 2013 02:14 PM
- Posted Adding Functionality to an Existing SQL Dialog on InstallShield Forum. May 17, 2013 02:21 PM
- Posted Code Working Differently on Win2K8 64-bit than Win7 32-bit on InstallShield Forum. May 14, 2013 03:35 PM
- Posted Re: Issue: Removing last character from property/variable on InstallShield Forum. May 01, 2013 02:58 PM
- Posted Re: Issue: Removing last character from property/variable on InstallShield Forum. May 01, 2013 01:24 PM
- Posted Issue: Removing last character from property/variable on InstallShield Forum. May 01, 2013 10:35 AM
- Posted Pass public PROPERTY from one Suite Install to Another? on InstallShield Forum. Apr 30, 2013 08:04 AM
- Posted Re: Error 1721 or 1722 on Custom Action on InstallShield Forum. Apr 26, 2013 04:43 PM
- Posted Error 1721 or 1722 on Custom Action on InstallShield Forum. Apr 26, 2013 02:17 PM
- Posted Running SQL Scripts After InstallFinalize on InstallShield Forum. Apr 23, 2013 05:17 PM
- Posted Re: Getting IIS Version of Machine on InstallShield Forum. Apr 22, 2013 01:20 PM
- Posted Getting IIS Version of Machine on InstallShield Forum. Apr 22, 2013 10:18 AM
- Posted Re: How to get a registry key (not string value) on InstallShield Forum. Apr 11, 2013 01:56 PM
- Posted Re: How to get a registry key (not string value) on InstallShield Forum. Apr 11, 2013 12:32 PM
- Posted Re: How to get a registry key (not string value) on InstallShield Forum. Apr 11, 2013 10:30 AM
- Posted Re: How to get a registry key (not string value) on InstallShield Forum. Mar 29, 2013 02:49 PM
- Posted Assigning Environment Variable to Property on InstallShield Forum. Mar 29, 2013 01:29 PM
- Posted How to get a registry key (not string value) on InstallShield Forum. Mar 29, 2013 10:55 AM