Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) while deploying solution.


Hi,

We were receiving this error randomly while trying to deploy the solution from within Visual studio. This error used to crop up randomly. Sometimes after waiting for few seconds or minutes if we try again, things used to work properly without that error.

In one of the forums it was suggested that stopping the indexing service would resolve the issue.

I tried it and it really worked.

Check out that thread

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/8123068c-10ca-4271-b8bc-ac2e934531bf

Bye..

Unable to connect to the database SharePoint_Config on Server. Check the database connection information and make sure that the database server is running..


Hi,

While trying to open a SharePoint Site, we were getting the following error in the event log.

Unable to connect to the database SharePoint_Config on Server.  Check the database connection information and make sure that the database server is running..

The password of the  account that was specified within the Identity tab of App Pool of the site had changed.

Correcting it resolved the issue.

Bye..

Error parsing Solution. Value does not fall within the expected range.


Hi,

I started getting this error while deploying the site definition solution in SharePoint ( it was visual studio 2008) . I also had a web application in the same solution.

I removed that web application and then it got deployed without any error. However that web application was there earlier as well but it wasn’t giving error before. Not sure what exactly caused the error.

Anyways, I hope it would be useful !

Bye.

Get Value for Person or Group Column Type


To get the value for Person or Group Column Type after removing the special characters from it, use this function

private string  GetValue(SPListItem item, SPField gpField)
{
    string currentValue = item[gpField.Title].ToString();
    SPFieldLookup field = (SPFieldLookup)gpField;
    SPFieldLookupValue fieldValue = (SPFieldLookupValue)field.GetFieldValue(currentValue);
    return fieldValue.LookupValue;
}

to call it

string strName = GetValue(spListItem, spListItem.Fields["fieldName"]);

 

Bye..

One of the best site for InfoPath developers


I was assigned a certain task in InfoPath, and while browsing for some help, i found this site.

http://www.bizsupportonline.net/

It seemed like one of the best sites as far as InfoPath development and SharePoint integration part of it are concerned.

 

Bye..

JavaScript on click of Finish Button in Survey – SharePoint


Hi,

We had created a survey and wanted some message to appear when user clicks on finish button.

Through one of my colleague i came to know about this function — PreSaveAction

function PreSaveAction()
{
alert(“Thanks for the participating in the survey!”);
return true;
}

Placing the above function in the newform.aspx using SharePoint designer  did the trick.

We could use the PreSaveAction function for custom validation as well !

http://edinkapic.blogspot.com/2007/10/add-javascript-date-validation-into.html

Bye..