RBS (Strataframe) database on a separate server


Author
Message
Jeff Pagley
Jeff Pagley
Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)
Group: StrataFrame Users
Posts: 223, Visits: 893
Hi SF Team,

How do I setup the DB connections in my app to point to the RBS (Strataframe) database on a different server than my user database.  Right now what I am doing is the following which is a connection string which points to the same server for both databases.

builder.DataSource = MyDataSource

builder.InitialCatalog = MyDataBase

builder.UserID = "sa"

builder.Password = MyPassword

DataLayer.DataSources.Add(New SqlDataSourceItem("", builder.ConnectionString))

Thanks,

Jeff


Replies
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
There are two things you need to do differently when the security data is not in the same database as the rest of the app:



1. Make sure the key of the datasource that access the security tables differs from the key used by the rest of the app. The default key is an empty string (""). This is typically used for the main data source. You need to use a different one for the security datasource:



DataLayer.DataSources.Add(New SqlDataSourceItem("security", builder.ConnectionString))




The key is set to "security" in the line above.



2. Let the framework know that the security data is accessible via this datasource, by setting the SecurityDataSourceKey to the key you used when creating the data source for security:



SecurityBasics.SecurityDataSourceKey = "security"




Both of these are typically done the the SetDataSources method in AppMain.vb (program.cs).
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Also Charles Thomas Blankenship posted a detail document on how to setup the RBS on a separate database, check out this link: http://forum.strataframe.net/FindPost14216.aspx


Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search