Dutch proofing tools Office 2010 Beta

By default the Dutch proofing tools are not available in Office 2010 beta. To get Dutch proofing tools available in Office 2010 beta:

1. start Word and go-to File -> Options -> Languages
2. make another language other then Dutch the default.
3. remove the Dutch language and close Word.
4. Download the French Microsoft Office 2010 Beta Language Pack
5. Install the Frensh language pack
6. start Word and go-to File -> Options -> Languages
7. make Dutch the default.

Speed-up-SharePoint

Add crl.microsoft.com to your host file. For more information see Speed-up-SharePoint

EntityDataSource Where with relationships

The EntityDataSource control can be used with a data-bound control to retrieve data from an EDM and to display. Most of the samples just display data based on a single table. Just what I want, but I had one more requirement. I required a filter based on a related table.

 

First let show the EDM modal:

 

I have two tables:

• Dossier: contains all the dossier in the company.
• Access: specifies which departments have access to a dossier.

 

My Grid needed to display all the dossier a specific department was the owner (Dossier.OwnerId) of or had access to (Access.DepartementId).

 

In the sample below, I assume the departmentId is 1.

 

The first requirement was very simple: just create a where on the OwnerId like:

But the second requirements cause me trouble. First of all I needed to make sure the Access table was included in my "query". Second the where needed to query on a the Access table which was a collection on the Dossier object (because of the 1 to many relationship).


Solution:

 

Logging to the SharePoint log in custom SharePoint solutions

Logging information about your application is not nice to have, but a must. A good log, can help you debug and fix problems.
SharePoint logs information by using the Unified Logging Service (ULS). Wouldn't it be nice if you good create the same behaviour in your own custom SharePoint solution??


You can!! Use the The SharePoint Logger of the Developing SharePoint Applications Guidance .

How to connect to the SharePoint Services Integrated Database with SQL Server Management Studio Express

Just use the connection string:

\\.\pipe\mssql$microsoft##ssee\sql\query

BDC Crawl Error - Access Denied By BDC

Symptoms

When you created a BDC definition and starts crawling the content, you get an error message "The parameter is incorrect. (Access denied by BDC)".

How to solve the problem

When you have a problem in SharePoint there are several places to find more information about the error:

• EventLog
  
• SharePoint log "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS"
  
• SQL log
  

Perform the following steps to figure out what the problem is:

1. In this case we start looking the the SharePoint log, because that's will probably the best place to get more information about the problem. So open the log file (if there are many log files, open the one which starts with your server name, and is the latest one).

2. Search for Access Denied.

3. If you find something like the message below, this post will probably describe your problem.

Access Denied for User 'JKNDEVSRV01\SPSearchService'. Securable MethodInstancewith Name 'EmployeeIDEnumeratorInstance' has ACL that contains: User 'JKNDEVSRV01\administrator' with Rights 'Execute, Edit, SetPermissions, UseInBusinessDataInLists, SelectableInClients'

4. The message below indicates that the Account which is used to crawl you BDC data as not enough rights to crawl the data.

Solution

Make sure the account which performs the crawling (Default Content Access Account) has enough rights on the BDC Definition.
Perform the following steps to solve the problem:

1. In the SharePoint Central Administrator go-to the Shared Service Provider -> BDB Application -> AdventureWorks -> Customer -> Manage Permissions, see figure below. (in this case AdventureWorks is my BDC Application and Customer is the entity to crawl.)

2. Make sure the crawling account is in the list and has at least Execute permissions.

Remark: After I published this post, I found some interesting link to the Microsoft site, which BDC Warnings and Error Messages.