About gknierim

gknierim · ‎Dec 15, 2011

Hi Jens, What did you right this dll in - .NET? and how did you call the dll and where did you put it? I'm guessing Custom Actions somewhere? Le tme know and I think that might be the answer. Thanks, Greg

gknierim · ‎Dec 14, 2011

Wow, adding another feature (and making not visible) at the same level actually worked. This is a bug IMO. Now I have a dummy subfeature to get the other subfeature to work.

gknierim · ‎Dec 14, 2011

Vernice...did you even read the question?

gknierim · ‎Dec 13, 2011

I've seen lots of threads on this issue but I still can't get it working. I have a feature and a subfeature. I have set my subfeature to InstallLevel 200 and to Install Local. The parent feature is InstallLevel 1 and InstallLocal. When I select the feature, the subfeature is selected automatically. However, when I go to deselect the subfeature, the feature becomes unchecked. How can I get it so just the feature is selected but the subfeature is not?

gknierim · ‎Dec 13, 2011

I know this is old but I have the same problem. I have set my subfeature to 200 and to Install Local. The parent feature is installlevel 1 and InstallLocal. When I select the feature, the subfeature is selected automatically. However, when I go to deselect the subfeature, the feature becomes unchecked. How can I get it so just the feature is selected but the subfeature is not?

gknierim · ‎Dec 07, 2011

Is there way I can run certain SQL Scripts based on a results from a SQL Query? My situation: I need to retrieve the current version of the database. Currently this is stored in a table I have created. Based on that result, I need to decide whether or not to run the remaining SQL scripts in the SQL Scripts view. This is kind of a upgrade process for the database. Is this possible or do I just need to create 1 big script that does everything at once - basically a script with several conditional statements? I've looked briefly into specifying the version field for each SQL Script which creates a table in the database that stores that version. The problem is that, this install is a new installation package and that table will not be present and I must use the existing tables. Any suggestions for this would be greatly appreciated. Thanks, Greg

gknierim · ‎May 13, 2011

Looks like adding the following before calling the SQLServerSelect dialog makes the list work: SQLRTInitialize2(); Sure would've be nice to know that from the documentation.

gknierim · ‎May 12, 2011

InstallScript MSI project. I've added the SQLServerSelect Dialog. When I click on the Browse button, the list of servers is blank. I've seen other posts about adding a dummy SQLConnection which I have done and I have also added a dummy SQL Script under that connection. I've also created a feature called "Database" that is checked and the script is associated with that feature. So, why is the list blank? If I go into SSMS and try adding a server, I see a very long list of servers so I know that they exist. Thoughts? Thanks, Greg

gknierim · ‎May 12, 2011

Since I am really wanting to test to see if a database server is online or not, I have a few questions: 1) Is it neccessary to specify an IP address for the server? Meaning, if I specify the computer/instance name will that resolve the IP address for me? 2) If I just need an instance name and use the SQLServerSelect dialog, is there a way to continue past the dialog if it can't connect to it? Thanks, Greg

gknierim · ‎May 11, 2011

I don't need to do anything with server except check its existence with either ipv4 or ipv6 and then store the address in the registry. Also the user could continue without it existing so I just need to know how to query the server. If the server exists doesn't mean that a database will exist.

gknierim · ‎May 11, 2011

Well, I guess that is part of the battle. This will always be on the local network (internal) so I would think that a PING would suffice but it could be that they have that disabled via their firewall settings so I'm not really sure there is a sure way to test if an IP address is "alive". The design is also to let the installer have the choice of going back to edit the IP if one can't be found, or to continue, which in my opinion kind of defeats the purpose of testing it in the first place. The dialog basically allows the user to specify the IP address of a SQL Server database server.

gknierim · ‎May 11, 2011

You might need to do the following before creating your key so that it writes to the 64 bit part of the registry: REGDB_OPTIONS = REGDB_OPTIONS | REGDB_OPTION_WOW64_64KEY;

gknierim · ‎May 11, 2011

I have a custom dialog that allows the user to enter either an IPv4 or IPv6 address. How can I test to see if that IP Address is accessible? Thanks, Greg

gknierim · ‎Apr 26, 2011

Yea, the problem that I am trying to work around is letting the user installing the databases to be able to pick folders other than the default data directories. I've read in some posts that you can't browse remote folders due to the restriction of the windows installer so maybe I will just have to have the user run an installation on the database server so that they can pick their own data directories and not the default. Then I can have the installer create the folders if they don't exist because it is running locally. Unless anyone else has another idea? Thanks, Greg

gknierim · ‎Apr 26, 2011

Hi, I was wondering if there was a way to browse the folders on a remote server? I am installing a SQL Server database from a script on the remote server but I am just manually specifying the path on the remote server instead of browsing to it. How or is it possible to do this from the installation? The project is an InstallScript MSI project. Thanks, Greg

Online Status	Offline
Date Last Visited	‎Mar 18, 2019 12:11 PM

Re: Run SQL Scripts based on Specific Version

Re: Subfeature Selection

Re: Features and subfeatures

Subfeature Selection

Re: Features and subfeatures

Run SQL Scripts based on Specific Version

Re: SQLServerSelect Browse List Empty

SQLServerSelect Browse List Empty

Re: How to test if IP Address is accessible

Re: How to test if IP Address is accessible

Re: How to test if IP Address is accessible

Re: Registry entry not being created

How to test if IP Address is accessible

Re: Remote Folder Access

Remote Folder Access

Re: Run SQL Scripts based on Specific Version

Re: Subfeature Selection

Re: Features and subfeatures

Subfeature Selection

Re: Features and subfeatures

Run SQL Scripts based on Specific Version

Re: SQLServerSelect Browse List Empty

SQLServerSelect Browse List Empty

Re: How to test if IP Address is accessible

Re: How to test if IP Address is accessible