﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?)  » Force the Selection of a DataBase on a New Installation</title><generator>InstantForum 2017-1 Final</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>StrataFrame Forum</webMaster><lastBuildDate>Sat, 02 May 2026 13:05:35 GMT</lastBuildDate><ttl>20</ttl><item><title>Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32002.aspx</link><description>I use Installaware to make my installation CD's for my SF projects. &lt;br/&gt;&lt;br/&gt;Is there a way to FORCE SF to ask which Instance of Sql to use and which Database to use every First time a new installation is run?&lt;br/&gt;&lt;br/&gt;The reason I am asking this is because I am trying the installation on a Win 8 machine and it does not ask me for the SQL information. </description><pubDate>Tue, 30 Apr 2013 10:35:04 GMT</pubDate><dc:creator>Terry Bottorff</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32011.aspx</link><description>Boy do I agree that Installaware is a good product but Extremely Expensive. And you are also correct about the discounts. Even after you apply the discounts the cost is over the top.&lt;br/&gt;&lt;br/&gt;Thanks again.</description><pubDate>Tue, 30 Apr 2013 10:35:04 GMT</pubDate><dc:creator>Terry Bottorff</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32010.aspx</link><description>I glad it worked for you too.&lt;br/&gt;&lt;br/&gt;About IA, I am still in version 9, I have not had the need to upgrade mainly because their marketing and upgrade method is very confusing, prices are too high, then many different discounts to apply and still the end price is too high.&amp;nbsp; I love IA, it is a very good product.&lt;br/&gt;&lt;br/&gt;Even though I am not targeting Windows 8 yet, so far I have been able to test my main application on Windows 8 and the current version of IA I have still does the job, I have not tried with .Net 4.5, that would be a challenge. &lt;span&gt;:w00t:&lt;/span&gt;</description><pubDate>Tue, 30 Apr 2013 09:41:00 GMT</pubDate><dc:creator>Edhy Rijo</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32009.aspx</link><description>I am not sure if there was one specific thing (Admin rights or the installation directory)&amp;nbsp;that fixed my problem but the problem is resolved. Thank you Edhy for the great help.&lt;br/&gt;&lt;br/&gt;Since you use Installaware also, do you build for Win 7? I have version 2012 and it does not have Win 8 as a choice?&lt;br/&gt;&lt;br/&gt;TIA.</description><pubDate>Tue, 30 Apr 2013 08:51:06 GMT</pubDate><dc:creator>Terry Bottorff</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32008.aspx</link><description>Oh wow. That gives me some things to try. &lt;br/&gt;&lt;br/&gt;Thank you so much. I shall return and let you know.</description><pubDate>Mon, 29 Apr 2013 09:18:51 GMT</pubDate><dc:creator>Terry Bottorff</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32007.aspx</link><description>I understand now.&amp;nbsp; Since I also use InstallAware v9 R2, let me tell you the setting I use to make my applications run as "Administrators"&lt;br/&gt;&lt;br/&gt;From the "Application Information" section, go to&lt;ul&gt;&lt;li&gt;"Summary and UAC" and in the "User Account Control, set the "Requested Elevation Level to "Always Elevate (requireAdministator)&lt;/li&gt;&lt;li&gt;"Application Requirements", in Special Requirements, check "Administrator priviledges"&lt;/li&gt;&lt;/ul&gt;I install my applications in a folder in the root drive, I never used the "Program Files" folders, in my case my company name is Progytech and my application is CardTracking.Net, so the installation folder will be C:\Progytech\CardTracking.Net&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;I have done some testing on Windows 8 and it worked without having to modify SF.</description><pubDate>Mon, 29 Apr 2013 07:10:22 GMT</pubDate><dc:creator>Edhy Rijo</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32006.aspx</link><description>This is my first adventure into using Win 8. I have SqlExpress installed and my database attached. I used my install for Win 7 that works fine for one of my projects. When I ran the project the first time on Win 8 it did not ask me to attach to the data like it does on Win 7 and then when I select a menu item that needs data it can not find it. That is why I thought if I could Force it to go thru the connection routine I would be fine. I really don't want to worry about a connection manager.&lt;br/&gt;&lt;br/&gt;So I will try what you mentioned and see what that leads to. If anyone else has any ideas to share? TIA.</description><pubDate>Mon, 29 Apr 2013 06:40:35 GMT</pubDate><dc:creator>Terry Bottorff</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32005.aspx</link><description>I have not seen any option to pre-select user name and password.&lt;br/&gt;&lt;br/&gt;I use MS-SQL server for all my applications, most of the time I have access to my customer's server and even install MS-SQL engine, but if the customer already have a DBA or IT guy, they sometimes will not allow a consultant to log in to their servers, so what I do is that I ask them to use a specific user and password which is then used by each workstation install when SF shows up the connection manager.&lt;br/&gt;&lt;br/&gt;Of course, you could go other routes here, like creating your own connection manager server and install it on the server to pass over the connection string to your workstations, this is what the folks at MicroFour have done with their medical application, it is not easy, but doable.&lt;br/&gt;&lt;br/&gt;What is your major concern here? what do you want to accomplish?</description><pubDate>Sun, 28 Apr 2013 17:43:37 GMT</pubDate><dc:creator>Edhy Rijo</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32004.aspx</link><description>&lt;p align="left"&gt;OK Edhy. Thanks. I been thinking of that but is there a way to select the user and password?&lt;/p&gt;</description><pubDate>Sun, 28 Apr 2013 15:37:12 GMT</pubDate><dc:creator>Terry Bottorff</dc:creator></item><item><title>RE: Force the Selection of a DataBase on a New Installation</title><link>http://forum.strataframe.net/FindPost32003.aspx</link><description>Hi Terry,&lt;br/&gt;&lt;br/&gt;In the SetDataSources() method, you can modify your data source item and enter the name of the database your application is expecting, I don't think you can pre-select the server or the instance to be used.</description><pubDate>Sun, 28 Apr 2013 15:12:18 GMT</pubDate><dc:creator>Edhy Rijo</dc:creator></item></channel></rss>