after modifying the manifest file, i get "a refferal was returned from the server" error level="highestAvailable" uiAccess="true"/> i changed uiAccess = true, it was = false before. ... View more

which section of the manifest file do i edit what setting do i include? ... View more

Having the same problem with installation dialog going in the background, has anybody figured out why this happens and how to fix it? ... View more

Hi Narayana You can install IIS via installshield. For windows 7, use: DISM.exe /Online /Enable-Feature /FeatureName:IIS-WebServer /FeatureName:IIS-WebServerRole /FeatureName:IIS-IIS6ManagementCompatibility /Featurename:<>............... For Vista, use pkgmgr with an unattended .xml file: Start /w PkgMgr.exe /n:" + '" :\Unattend.xml" Read more: http://learn.iis.net/page.aspx/133/using-unattended-setup-to-install-iis-70/ ... View more

Hi Datagaard Your SQL Version: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup\CurrentVersion Your SQL Instance name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names Also, you can run this T-SQL query to check versions and editions: SELECT SERVERPROPERTY('productversion') AS N'Product Version', SERVERPROPERTY ('productlevel') AS N'Product level', SERVERPROPERTY ('edition') AS N'Edition' =========== Installscript =========================== Use RegDBGetKeyValueEx to query the respective keys mentioned above: e.g. RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE); // 80 = sql2000, 90 = sql2005 & 100 = sql2008 if (RegDBGetKeyValueEx("Software\\Microsoft\\Microsoft SQL Server\\80\\Tools\\ClientSetup\\CurrentVersion", "CurrentVersion", nvType, svMSDEVersion, nvSize)= 0 ) then if (RegDBGetKeyValueEx("Software\\Microsoft\\Microsoft SQL Server\\80\\Tools\\ClientSetup", "SQLPath", nvType, svMSDEDataPath, nvSize)= 0 ) then // Your code here endif; endif; ... View more

Hi hcl_60 You can use LaunchAppAndWait: Below i have a .sql file that i would like to run, in my case i use SQL osql Command line: osql -S \ -U -P You would need to know the mysql command line: LaunchAppAndWait("\"" + MSDETARGETLOCATION + "\\binn" + "\\osql.exe\""," -S (local)\\SL -U sa -P -i \"" + TARGETDIR ^ "\\TestProc.sql\" -o \"" + TARGETDIR ^ "\\TestProc.log\"",WAIT); If you want, you can create your stored procedure dynamically or just have the file ready to use with the command, but the following code will create the stored procedure dynamically and execute it: // Create the stored proc OpenFileMode( FILE_MODE_NORMAL ); CreateFile( nvFilehandle, TARGETDIR", "TestProc.sql" ); WriteLine( nvFilehandle, "CREATE PROCEDURE [dbo].[TestProc]" ); WriteLine( nvFilehandle, "@ColName as sysname") WriteLine( nvFilehandle, "AS") WriteLine( nvFilehandle, "DECLARE @STR AS VARCHAR(200)"); WriteLine( nvFilehandle, "SET @STR = " select count(*) from " + @TableName + " where " + @ColName + " is not null"); WriteLine( nvFilehandle, "EXEC (@STR)"); WriteLine( nvFilehandle, "GO"); CloseFile (nvFilehandle); // Launch the stored procedure LaunchAppAndWait("\"" + MSDETARGETLOCATION + "\\binn" + "\\osql.exe\""," -S (local)\\SL -U sa -P -i \"" + TARGETDIR ^ "\\TestProc.sql\" -o \"" ^ "\\TestProc.log\"",WAIT); ... View more

Not yet sure why it works from your disk1. But i would try removing the "Return= " To just: Set WshShell = CreateObject ("WScript.Shell") WshShell.Run(strCommand, 0, true) ... View more

@Vikram You are being a bit vague about your problem. Based purely on the statement: "Return = WshShell.Run(strCommand, 0, true)" Is "Return" a variable that you defined? or was it meant to be used as a keyword? In which case, this: "Return = " will generate an error and should instead be "return [(][expression][)]; ". if "Return" is a variable, make sure it is declared and that what you are assigning it to is the same data type, also make sure that strCommand is declared. ... View more

@samarasamcete Use VerGetFileVersion, to get the version (stored in svVersionNumber ), then you could use VerCompare to check against svVersionNumber to see if it is the desired version: // Get the version if ( VerGetFileVersion ( WINSYSDIR + "msiexec.exe" , svVersionNumber )=0 ) then // Compare results if VerCompare ( svVersionNumber , "2.0.2600.2" , VERSION )= LESS_THAN then // Add your logic here. // maybe to install a later version or show an error message or whatever... endif; endif; ... View more

@HennoKeers What about a scenario where you have users who need those hotfixes and are not on the domain, but are still employees? This is the scenario that we are currently facing, we periodically send out Hotfix CDs to some of our users, and this needs a setup. ... View more