Monday, August 30, 2010

Monday, August 23, 2010

Can't find PInvoke DLL 'sqlceme35.dll

This problem is occurred me while I'm ruining a SQL in compact device. So i resolved this error by installing


above files. If this will not work try wce500 folder also. it may work.

Getting lower case (lcase) and upper case in the infopath using translate function


translate(Field,"ABCDEFGHIJKLMNOPQRSTUVWYXZ", "abcdefghijklmnopqrstuvwyxz")

Lower Case in InfoPath

translate(../d:Owner,"ABCDEFGHIJKLMNOPQRSTUVWYXZ", "abcdefghijklmnopqrstuvwyxz")

Upper Case in InfoPath

translate(../d:Owner,"abcdefghijklmnopqrstuvwyxz", "ABCDEFGHIJKLMNOPQRSTUVWYXZ")

Give permission user as a site admin in a Site Collection

for that you should be in a farm administrator group of the SharePoint site.  using following stsadmn command you can grant permission to the user.

stsadm –o adduser –url “http://websites/sites/abc”  -userlogin "domain\user"   –useremail  “” -username "name" -role "Full Control" -siteadmin