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

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

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

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

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

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

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

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