StrataFrame Forum
Back
Login
Login
Home
»
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
Post Reply
Like
1
Shared Settings File predefined by bypass Connection Wizard
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Trent Taylor
Trent Taylor
posted 12 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
Cool. Glad it helped.
Reply
Like
1
Govinda Berrio
Govinda Berrio
posted 12 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 94,
Visits: 481
Trent,
this looks like exactly what we are looking for.
Thank You!
Reply
Like
1
Trent Taylor
Trent Taylor
posted 12 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
Govinda:
If you wanted to, you could just load a DbeSharedSettingsData and then create the connection yourself. It would look something like this:
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));
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.
Reply
Like
1
Govinda Berrio
Govinda Berrio
posted 12 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 94,
Visits: 481
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
Tags
Connection Wizard
Shared Settings File
Reply
Like
1
Govinda Berrio
Govinda Berrio
posted 12 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Users
Posts: 94,
Visits: 481
Thanks Trent
Reply
Like
1
Trent Taylor
Trent Taylor
posted 12 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
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.
Reply
Like
1
Govinda Berrio
Govinda Berrio
posted 12 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 94,
Visits: 481
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
Tags
Connection Wizard
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search