Jan 10, 2012
02:19 PM
After a lot of testing with some other stored procedures I created, I determined the data type for the number was incorrect. It should be adNumeric.
... View more
Jan 09, 2012
04:40 PM
I have an InstallScript custom action where I'm trying to execute a stored procedure that has an out parameter. I'm using ADO to accomplish this. This is what I have so far. set oConn = CreateObject("ADODB.Connection"); /* I open the connection string using the Oracle ODBC driver. I've tested it and am able to execute select queries off of it and get results, so I know it works. */ set oCommand = CreateObject("ADODB.Command"); oCommand.ActiveConnection = oConn; oCommand.CommandType = AD_CMD_STORED_PROC; oCommand.CommandText = "myStoredProcedureName"; set oParams = oCommand.Parameters; set oParam1 = oCommand.CreateParameter("myParam", AD_VARIANT, AD_PARAM_OUTPUT, 10); oParams.Append(oParam1); oCommand.Execute; szResult = oParam1.Value; So my stored procedure has a varchar2 out parameter, and I want to get that value back after executing the stored procedure. I get an error after trying the Execute method where it says "Parameter type is not supported". I think this is in reference to the use of adVariant for VARCHAR2. I see a note saying ADO doesn't support adVariant, but that's what maps to Oracle VARCHAR2. I've tried adVarChar instead of adVariant, but then I get a generic error message instead. Can anyone help me with the syntax for making this stored procedure call? There isn't much guidance out there for doing this in InstallShield. Thanks.
... View more
Labels
- Labels:
-
InstallShield 2011
Nov 08, 2011
10:51 AM
I have a custom action that fails on calling the InstallScript RegDB functions to create a registry key if UAC is enabled. If I execute it as in system context, it works. I can't use the built-in registry editor in the IDE because it doesn't have the flexibility that is needed. My registry keys are installed under a key that is potentially shared by other apps. If my app is the first installed, it will create this common key. But what happens during uninstallation is it deletes that common key (and all the keys from other apps under it) if it created that key in the first place. I didn't see an option to prevent this behavior, so I resorted to using an IS custom action.
... View more
Nov 07, 2011
12:55 PM
They are included alongside the MSI on the target system, so I can't use InstallFiles. However, I am now using MoveFiles to copy them. How would I get a custom action to execute with elevated privileges when specified only as Deferred? My InstallScript action fails for me when I don't have it as executing in system context. By the way, I've noticed there seems to be some sort of stigma with using custom actions. Aside from the fact that you need to create corresponding rollback and uninstall actions (which I have easily done), is there some problem with using custom actions to programmatically accomplish a task, such as copying files? Or is it just the extra burden of manually having to ensure uninstall and rollback is taken care of properly?
... View more
Nov 04, 2011
04:06 PM
I didn't think I could use a custom action to copy it to the local system if UAC is enabled and the action is not in system context. The reason I have it set as executing in system context is because the UAC prevented me from writing files. Is this not true?
... View more
Nov 04, 2011
09:38 AM
I have a custom action that calls an InstallScript function to copy files from a resource folder relative to my MSI file and place them on the target system. This custom action executes as Deferred in System Context. The system context is needed because the files will fail to be copied if UAC is enabled. However, the customer also wants to be able to install from a mapped network drive. This is a problem, because custom actions running Deferred in System Context will fail to access network shares because they are running under the SYSTEM account, (in SMB terminology a 'NULL User') which is disallowed in Windows. So, it seems if I have my custom action run in system context, it will fail to install from a network location. If I have it as non-system, it fails due to UAC restrictions. Is there a way to satisfy both of these customer demands? (1. Install from a mapped network drive 2. Install with UAC enabled) It seems like I've hit a catch-22 or something.
... View more
Labels
- Labels:
-
InstallShield 2011
Oct 31, 2011
05:07 PM
Apparently, the problem was in the connection string. OLEDB does not support connecting as SYSDBA, so I changed "Provider=OraOLEDB.Oracle" to "Driver={Oracle in client11_home1}" and "Data Source" to "DBQ", and I could then connect as SYSDBA.
... View more
Oct 31, 2011
11:56 AM
I'm trying to connect to Oracle as the SYS user using ADO in an InstallScript function, but I keep getting an error saying I need to connect as sysdba. I've followed the steps in this post but to no avail. My connection string is Provider=OraOLEDB.Oracle;Data Source=MyDatabase;User ID=SYS;Password=password; In the ISSQLDBMetaData table in Direct Editor, I've changed the following columns to these values: AdoDriverName: {Oracle in client11_home1} AdoCxnServer: DBQ= ISAttributes: 6 AdoCxnAdditional: DBA Privilege=SYSDBA When I connect as SYSTEM, without as sysdba, things work fine. But when I try as SYS, it fails to connect. If I add AS SYSDBA to the password field in my connection string, I get an invalid password error. I'm not sure what I'm doing wrong. Help please.
... View more
Labels
- Labels:
-
InstallShield 2011
Oct 24, 2011
11:47 AM
It seems I could change the UninstallString registry value to launch a UI-based uninstall. However, I'd also need to change the WindowsInstaller value from it's default value of 1 for this to work. What exactly does the WindowsInstaller value do, aside from always calling the Remove as "msiexec /x{productcodeguid}"? Is it safe to edit the WindowsInstaller registry value?
... View more
Oct 24, 2011
11:05 AM
I have a Basic MSI project and I want the user to be able to uninstall the application from Add/Remove Programs. I know this method only performs the Execute sequence to silently uninstall the app. My dilemma is, I need to uninstall some database stuff and need the user to enter the password to access it. For security reasons, I can't store this password anywhere. Is there any way for me to gather user input when removing software through ARP?
... View more
Labels
- Labels:
-
InstallShield 2011
Oct 21, 2011
01:31 PM
Thanks. After doing some research I came across both of these points and realized they both will cause problems with my install 😞
... View more
Oct 21, 2011
10:32 AM
I have an InstallScript function that checks if a directory exists in a location relative to the MSI file. When I run the installer from a location on a network drive I have mapped to my local machine, it fails to find the directory. I have tried using both ExistsDir(SourceDir^myDirectory) and Is(PATH_EXISTS, SourceDir^myDirectory) and both return false if the directory it's looking for is located on a mapped network drive (located off the target machine). The directory exists, I can copy the path that is passed into the function and access it myself. The MSI I'm launching is also located on the same mapped drive when this occurs. Is there a way to check if a directory exists or not in InstallScript even if it's located outside the target machine?
... View more
Labels
- Labels:
-
InstallShield 2011
Oct 17, 2011
02:19 PM
Thanks. I'm aware of msizap and have used it before, but I need a solution that I could include in my MSI, to check if the machine is in an unstable state and then revert to a stable state.
... View more
Oct 17, 2011
01:02 PM
I have a Basic MSI project and during the middle of the Execute phase of the installation, I lost power. I had already set some registry keys, and placed files in folders on the target system. However, the product wasn't registered with Windows (there is no key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall), so Windows doesn't think the product is installed. So when I try to uninstall through the MSI by running maintenance mode, it gets an error because Windows doesn't see it as installed. If I try to run the MSI again, it installs as if the product hadn't been installed. Is there a best practice concerning what to do in these situations?
... View more
Labels
- Labels:
-
InstallShield 2011
Oct 17, 2011
12:44 PM
In an InstallScript function, use REGDB_OPTIONS = REGDB_OPTION_WOW64_64KEY; to use the 64-bit part of the registry. After you're done, revert back to the default settings by using REGDB_OPTIONS = REGDB_OPTION_USE_DEFAULT_OPTIONS;
... View more
Latest posts by anom217
Subject | Views | Posted |
---|---|---|
557 | Jan 10, 2012 02:19 PM | |
1663 | Jan 09, 2012 04:40 PM | |
1197 | Nov 08, 2011 10:51 AM | |
1197 | Nov 07, 2011 12:55 PM | |
1197 | Nov 04, 2011 04:06 PM | |
4033 | Nov 04, 2011 09:38 AM | |
687 | Oct 31, 2011 05:07 PM | |
3976 | Oct 31, 2011 11:56 AM | |
1051 | Oct 24, 2011 11:47 AM | |
2481 | Oct 24, 2011 11:05 AM |
Activity Feed
- Posted Re: ADO Stored Procedure - Help on InstallShield Forum. Jan 10, 2012 02:19 PM
- Posted ADO Stored Procedure - Help on InstallShield Forum. Jan 09, 2012 04:40 PM
- Posted Re: Help executing from mapped drive with UAC on InstallShield Forum. Nov 08, 2011 10:51 AM
- Posted Re: Help executing from mapped drive with UAC on InstallShield Forum. Nov 07, 2011 12:55 PM
- Posted Re: Help executing from mapped drive with UAC on InstallShield Forum. Nov 04, 2011 04:06 PM
- Posted Help executing from mapped drive with UAC on InstallShield Forum. Nov 04, 2011 09:38 AM
- Posted Re: Connect to Oracle as SYSDBA using ADO on InstallShield Forum. Oct 31, 2011 05:07 PM
- Posted Connect to Oracle as SYSDBA using ADO on InstallShield Forum. Oct 31, 2011 11:56 AM
- Posted Re: Silent Uninstall needs password on InstallShield Forum. Oct 24, 2011 11:47 AM
- Posted Silent Uninstall needs password on InstallShield Forum. Oct 24, 2011 11:05 AM
- Posted Re: Check for directory on mapped network drive on InstallShield Forum. Oct 21, 2011 01:31 PM
- Posted Check for directory on mapped network drive on InstallShield Forum. Oct 21, 2011 10:32 AM
- Posted Re: Best practice for unfinished state after losing power? on InstallShield Forum. Oct 17, 2011 02:19 PM
- Posted Best practice for unfinished state after losing power? on InstallShield Forum. Oct 17, 2011 01:02 PM
- Posted Re: Registry on InstallShield Forum. Oct 17, 2011 12:44 PM
- Posted Re: Installing 32 bit app under 64 bit Program Files on InstallShield Forum. Sep 14, 2011 12:31 PM
- Posted Installing 32 bit app under 64 bit Program Files on InstallShield Forum. Sep 13, 2011 09:40 AM
- Posted Re: File permissions with UAC on InstallShield Forum. Sep 01, 2011 03:52 PM
- Posted File permissions with UAC on InstallShield Forum. Sep 01, 2011 02:33 PM
- Posted Re: Detecting Elevated Admin on Vista or Higher OS on InstallShield Forum. Sep 01, 2011 01:18 PM