Anonymous access in BDC

★★★★★★★★★★★★★★★ When anonymous users log into the SharePoint site which has BDC web parts, you will see the error message “You do not have permission to access abc in xyzInstance”.  This is fixed in the Infrastructure update of WSS and MOSS.  In the Application Definition File, for each method instance ( for which we need…


BDC : How to Create Filters in ADF manually

★★★★★★★★★★★★★★★ When an ADF is generated using BDC Editor tool, by default no filters will be added to any method instance.  There is an option available in BDC editor tool to create filter.  For guys who have tried to create filters using BDC Editor tool know how much painful it is.  I know that there…


Business Data Catalog

★★★★★★★★★★★★★★★ Its all about BDC !


Content Type – Setting up default content type programmatically

★★★★★★★★★★★★★★★ Here’s the sample to add and set a new content type as a default content type to a document library in a SharePoint site.  Also this will hide the pervious default content type.   SPSite oSPSite = new SPSite(""); // Site URL SPWeb oSPWeb = oSPSite.OpenWeb(); SPList list = oSPWeb.Lists["Shared Documents"]; // Name of…


WSS 3.0 – Valid properties to be used in FullText Query Search in Search.asmx

★★★★★★★★★★★★★★★ When we have valid SQL query something like ““Select Category from Scope()”  and execute them using FullText Query Search in WSS 3.0 using Search Web Service, it throws “InvalidPropertyException”.  This confirms that not all the properties can be used in WSS Full Text search.  How do we know which are all the properties that…


Business Data Catalog with Oracle

★★★★★★★★★★★★★★★   There are multiple scenarios in BDC, where we can see this error message “An error occurred while retrieving data from <InstanceName>. Administrators, see the server log for more information.”  Let me talk about one of the instance that can happen when we use BDC Application Definition File (ADF) that uses Oracle database in…


Custom site definition – Using GetAvailableWebTeplates / GetWebTemplates

★★★★★★★★★★★★★★★   In SharePoint object model when the following sequence of steps happen, the deployed custom site definition will not be found.   Step 1 : Add Solution ( The solution package consisting of site templates and features ) Step 2 : Create Web application. Step 3 : Deploy solution. ( The solution is deployed…


Calling OpenBinaryStream throws COM exception – 0x80070092

★★★★★★★★★★★★★★★   Create an instance of SPFile using GetFile method and pass the GUID of the file in its parameter. Then immediately call OpenBinaryStream method in the instance of spfile. It then throws a COM exception “The path specified is being used in a substitute. (Exception from HRESULT: 0x80070092)”   SPFile oSPFile = OSPWeb.GetFile(“GUID of…


Deleting config values specific to a web application

★★★★★★★★★★★★★★★   Many a times, developers unknowingly add inappropriate values in the web config file of the application programatically.  Though it gets added, the next time when a SharePoint site is created, it throws error.  The problem is that, the inappropriate values are already saved in the database and in SharePoint its not suggested to make the changes…