Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SecurityDatabaseKey
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01177449
Message ID:
01177852
Views:
10
Sarosh,

>Tried that but now I am getting an error "You must specify a DatabaseKey on the Picker control" (in the sample app) when I Select Orders from the Customer Menu pick and then click the Browse button.

That's actually correct. If you look in the MM .NET Dev Guide topic "Working with the PickList" controls, you'll see that you need to set the DatabaseKey property of the picker under these conditions:
DatabaseKey - Specifies the database key to be used in the picker business object to retrieve data. If you only use a single database key with your application (even if you use multiple database sets) you do not need to specify this setting.
So, in order to get this to work properly, set the DatabaseKey property of the picker control on the Customer Orders form to Northwind.

>I am not clear about relationship between
>
>    <!--   User application and configured property settings go here.-->
>    <!--   Example: <add key="settingName" value="settingValue"/> -->
>    <add key="SecurityDatabaseSetKey" value="CustA"/>
>    <add key="SecurityDatabaseKey" value="SecurityDB"/>
>    <add key="DatabaseSetDefault" value="CustA"/>
>
Actually, there is no SecurityDatabaseSetKey...just SecurityDatabaseKey and DatabaseSetDefault.


>
>  <databases>
>	<add key="CustA\Northwind\Connection" value="server=AppDBServer;database=Northwind;Integrated Security=SSPI;Persist Security Info=False;" />
>	<add key="CustA\Northwind\DataAccessClass" value="DataAccessSql" />
>	<add key="CustB\Northwind\Connection" value="Provider=vfpoledb.1;Data Source=C:\Program Files\Mere Mortals .NET Framework 2005\Samples\VFPData\northwind.dbc" />
>	<add key="CustB\Northwind\DataAccessClass" value="DataAccessOleDb" />
>	<add key="CustA\SecurityDB\Connection" value="server=AppDBServer;database=SecurityDB;Integrated Security=SSPI;Persist Security Info=False;" />
>	<add key="CustA\SecurityDB\DataAccessClass" value="DataAccessSql" />
>  </databases>
>
>and also where and who reads the "SecurityDatabaseSetKey", "SecurityDatabaseKey", "DatabaseSetDefault" settings.
>
>Is this explained somewhere in the help file?

Yes, check out the MM .NET Dev Guide topic "Specifying Database Sets in the Config File"

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform