StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Shared Settings File predefined by bypass Connection Wizard

Shared Settings File predefined by bypass Connection Wizard

Govinda Berrio — Thu, 20 Dec 2012 11:13:39 GMT

Hi,

does anyone know if there is a way to "pass in" the location of the Shared Settings File without firing up the Connection Wizard.

What I would like to happen is deploy an app with the location of the SSF embedded, and bypass the connection wizard completely. The user would just install the application, run it and it would apply the DB connections automatically without being prompted. The next prompt after starting the app would be the login.

Thank You,

Govinda

RE: Shared Settings File predefined by bypass Connection Wizard

Trent L. Taylor — Thu, 20 Dec 2012 11:13:39 GMT

Cool. Glad it helped. :)

RE: Shared Settings File predefined by bypass Connection Wizard

Govinda Berrio — Thu, 20 Dec 2012 10:45:13 GMT

Trent,

this looks like exactly what we are looking for.

Thank You!

RE: Shared Settings File predefined by bypass Connection Wizard

Trent L. Taylor — Wed, 12 Dec 2012 13:55:38 GMT

Govinda:

If you wanted to, you could just load a DbeSharedSettingsData and then create the connection yourself. It would look something like this:

[codesnippet]DbeSharedSettingsData sharedSettings = new DbeSharedSettingsData();

//-- Load the shared settings file into the BO. The shared settings file is XML that populates a business object.
sharedSettings.FillWithSharedSettings(@"c:\Repository\NameOfSharedSettingsFile.ssf");

//-- Build a connection string
string connectionString = "server=" + sharedSettings.ss_server + ";";

if(sharedSettings.ss_windowsauthentication)
connectionString += "integrated security=SSPI;";
else
connectionString += "user=" + sharedSettings.ss_username + ";password=" + sharedSettings.ss_password + ";"

connectionString += "database=" + sharedSettings.ss_initialcatalog + ";";

//-- Now you can create your connection
MicroFour.StrataFrame.Data.DataBasics.DataSources.Add(New SqlDataSourceItem(string.Empty,connectionString));

[/codesnippet]

You may have to tweak the above code, I just typed it in here in the forum editor, so it may have a small typo here or there, but this should get you going without changed the SF source.

RE: Shared Settings File predefined by bypass Connection Wizard

Govinda Berrio — Wed, 12 Dec 2012 13:40:09 GMT

Trent,

we are going to try modifying the SF source to add this functionality until you guys can implement it in the SF product.

Can you give me a place to start with this? A class name where it would make sense to add this functionality to, perhaps?

Or the method that loads the SSF and writes the connection files to the user profile?

Thank You,

Govinda

RE: Shared Settings File predefined by bypass Connection Wizard

Govinda Berrio — Tue, 11 Dec 2012 09:14:05 GMT

Thanks Trent

RE: Shared Settings File predefined by bypass Connection Wizard

Trent L. Taylor — Mon, 10 Dec 2012 17:02:40 GMT

Govinda:

At the moment there isn't. However, this only has to be done once. This is a good idea, though. I will look at the source and see how much energy would be involved.