Please let me know whether this is possible through Installshield or not ... View more

Hi , We are setting the registry value in OnResumeUIBefore() function RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE); RegDBSetKeyValueEx("SOFTWARE\\Wow6432Node\\Microsoft\\Windows\\CurrentVersion\\Uninstall\\{#GUID#}", "Publisher", REGDB_STRING, "XYZ", -1); But still publisher name is not getting changed to XZY in control panel > programs and features, it is still showing "Ihr Firmenname" after upgrade ... View more

Can you suggest how to check whether the package is running in fresh installation or upgrade? ... View more

Hi rguggisberg , We changed to SQLServerSelectLoginEx dialog which solved our problem, thank you for your inputs. ... View more

Hi rguggisberg , After changing to SQLServerSelectLogin2( szConnection, szServer, szUser, szPassword, bWinLogin, szDB, TRUE , FALSE); , we are getting "CREATE TABLE permission denied in database 'master' " error message while installing in Azure machines. ... View more

Hi rguggisberg, I could able to show two SQL Dialogs and could able to control the flow by creating similar function to OnSQLLogin. But one issue with this is not able to differentiate between the two dialogs , from both the functions we are calling SQLServerSelectLogin(szServer, szUser, szPassword, bWinLogin) dialog. Is there any way to differentiate the Dialog wording to tell the user which connection string they were entering the values? ... View more

Hi rguggisberg, Can you please send the logic? ... View more

Hi, Through Suite installer we are passing this /s /f1"[SETUPSUPPORTDIR]\Setup.iss" in EXE Silent Command Line setting , it is not possible to change the iss file according to Upgrade or fresh installation at run time ... View more

Hi rguggisberg, We are having two SQL connections with names SQLConnection and PerfSQLConnection, we need to show PerfSQLConnection in only some conditions (say if string xyz="true"), can you suggest whether to write if condition in this case or to create another function similar to OnSQLLogin function? To be more clear we have 3 scenarios: 1)Need to show only SQLConnection related SQL dialog 2)Need to show both SQLConnection and PerfSQLConnection related SQL Dialogs, 3)Need to show only PerfSQLConnection related SQL Dialog. Below is the Installscript code ,can you suggest where to make the changes if we go with IF condition as you mentioned in earlier comment? //--------------------------------------------------------------------------- // OnSQLLogin //--------------------------------------------------------------------------- function number OnSQLLogin( nBtn ) string sMessage; string szConnection, szServer, szUser, szPassword, szDB, sTemp[MAX_PATH]; string szAuthentication,szNASVer,szSQLServerName,szInitialCatalog,szAuthenticationType,szSQLUserName,szSQLPassword; number nResult, nSize, nCount; BOOL bWinLogin, bNext, bPromptForSQLLoginInfo; LIST listConnections; number nvSize; begin nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLSERVERADDRESS", szServer, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLSERVERLOGIN", szUser, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLSERVERPASSWORD", szPassword, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLAUTHENTICATION", szAuthentication, nvSize); if (szAuthentication = "WINDOWS") then bWinLogin = TRUE; else bWinLogin = FALSE; endif; //First initialize SQL Server runtime SQLRTInitialize2(); // Suppress ISSQLSRV.DLL to show a connection error message. MsiSetProperty( ISMSI_HANDLE, "IS_SQLSERVER_CA_SILENT", "1" ); //Get the names of all the necessary connections listConnections = SQLRTGetConnections(); ListGetFirstString (listConnections, szConnection); nCount = 0; //determine if NEXT or BACK will be returned //if there are no connections to make if( nBtn != BACK ) then bNext = TRUE; else bNext = FALSE; //start at end if going BACK while (ISERR_SUCCESS = ListGetNextString( listConnections, szConnection ) ); nCount++; endwhile; endif; // Login for each connection while (nResult = ISERR_SUCCESS) //Get Default values for connection SQLRTGetConnectionInfo( szConnection, szServer, szDB, szUser, szPassword ); // Use our Default, not SQL Servers //bWinLogin = SQLRTGetConnectionAuthentication( szConnection ); // Display login dialog (without connection name) // COMMENT OUT TO SWAP DIALOGS //nResult = SQLServerSelectLogin2( szConnection, szServer, szUser, szPassword, bWinLogin, szDB, FALSE, TRUE ); // Display login dialog (with connection name) // UNCOMMENT TO SWAP DIALOGS //nResult = SQLServerSelectLogin2( szConnection, szServer, szUser, szPassword, bWinLogin, szDB, TRUE, TRUE ); // nResult = SQLServerSelectLogin(szServer, szUser, szPassword, bWinLogin); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "NASVER", szNASVer, nvSize); if(szNASVer!="") then nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLSERVERADDRESS", szServer, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "IS_SQLSERVER_DATABASE", szInitialCatalog, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLAUTHENTICATION", szAuthentication, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLSERVERLOGIN", szUser, nvSize); nvSize = MAX_PATH; MsiGetProperty(ISMSI_HANDLE, "SQLSERVERPASSWORD", szPassword, nvSize); if (szAuthentication = "WINDOWS") then bWinLogin = TRUE; else bWinLogin = FALSE; endif; nResult=NEXT; else nResult = SQLServerSelectLogin(szServer, szUser, szPassword, bWinLogin); endif; if( nResult = NEXT ) then //store data in case we need it again SQLRTPutConnectionInfo2( szConnection, szServer, szDB, szUser, szPassword ); SQLRTPutConnectionAuthentication( szConnection, bWinLogin ); //test connection nResult = SQLRTTestConnection2( szConnection, szServer, szDB, szUser, szPassword, bWinLogin ); nSize = MAX_PATH; MsiGetProperty( ISMSI_HANDLE, "IS_SQLSERVER_STATUS", sTemp, nSize ); if( sTemp != "0" ) then nSize = _MAX_PATH; MsiGetProperty( ISMSI_HANDLE, "IS_SQLSERVER_STATUS_ERROR", sMessage, nSize ); if( nSize = 0 ) then Sprintf(sMessage, SdLoadString( IDS_IFX_SQL_ERROR_LOGIN_FAILED ), szConnection, SdLoadString( ISCRIPT_E_UNKNOWN_ERROR_DESC )); endif; MessageBox( sMessage, MB_OK ); //Show same login dialog again nResult = ListCurrentString(listConnections, szConnection); else //SUCCESS //Move on to next connection nCount++; bNext = TRUE; nResult = ListGetNextString(listConnections, szConnection); endif; else //BACK nCount--; bNext = FALSE; nResult = ListSetIndex( listConnections, nCount ); ListCurrentString( listConnections, szConnection ); endif; endwhile; MsiSetProperty(ISMSI_HANDLE, "SQLSERVERADDRESS", szServer); MsiSetProperty(ISMSI_HANDLE, "SQLSERVERLOGIN", szUser); MsiSetProperty(ISMSI_HANDLE, "SQLSERVERPASSWORD", szPassword); if (bWinLogin = TRUE)then MsiSetProperty(ISMSI_HANDLE, "SQLAUTHENTICATION", "WINDOWS"); else MsiSetProperty(ISMSI_HANDLE, "SQLAUTHENTICATION", "SQL"); endif; if( bNext ) then return NEXT; else return BACK; endif; end; ... View more

We can't move our projects to Basic MSI projects , we have lot of installscript code involved, we need to use Installscript MSI projects only ... View more

Hi, I have created the .iss file and added that file in support directory and passing /s /f1"[SETUPSUPPORTDIR]\Setup.iss" in EXE Silent Command Line setting . But the .iss file created while fresh installation does not work while upgrade and .iss file created while upgrade does not work for fresh installation , so this is not working for us, we don't want to change .iss file everytime because we are not sure whether it is the fresh installation or its an upgrade in production. ... View more

Hi, Last week I tried to pass /v"ISSilentInstall=true" from Suite installer to each packages in EXE Silent Command line , but not able to run in silent ... View more