Business Data Connectivity Service In SharePoint , Connect SharePoint with SQL, Excel or any third party system

Dear All,
Today i connect the 3rd Party database through SharePoint via Business Data Connectivity Services.

What are the problem i am facing?
First i face a problem to get the "Access denied by business data Connectivity" which i mentioned the whole tread and solution here

http://social.msdn.microsoft.com/Forums/office/en-US/11f090bc-7645-4b76-8464-9addc4386fc6/access-denied-by-business-data-connectivity?forum=sharepointdevelopment

Solution for the this problem is simple
Login with your SharePoint Central Administration > Application Management > Configure alternate access mappings (under Web Applications)

Make sure your alternative path is set for your "Central Administration Site Collection" the problem will be resolve out

Other thing Make sure running:
1) Service under the Start > Services > Claims to Windows Token Service
2) Make sure your SharePoint Web Services Root is enable under IIS>Application Pool

Once every thing is done then you need to do the following steps:
http://www.c-sharpcorner.com/UploadFile/anavijai/create-external-content-type-using-sharepoint-designer-2013/

Once the above steps will done you can do the following steps to make any of SQL table in to sharepoint
http://www.c-sharpcorner.com/UploadFile/anavijai/create-external-list-in-sharepoint-2013/

It's so easy the first problem eat my 3 days and i hop my post and working save your time

Regards
Rashid Imran Bilgrami
CEO Best visualization
http://www.bestvisualization.com

Comments

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All When trying to open a PDF file from a mapped drive in SharePoint 2010. You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com

SharePoint: A Complete Guide to Getting and Setting Fields using C#

Original article https://social.technet.microsoft.com/wiki/contents/articles/21801.sharepoint-a-complete-guide-to-getting-and-setting-fields-using-c.aspx Introduction This article demonstrates how to set and get the various SPField types for a SharePoint list using C#. The examples demonstrated set and get fields from an item that belongs to a custom list. The custom list contains a number of fields, and all the fields are named based on the type of field they are. For example, there is a Text field, which has been named, textfield. This is depicted in the following picture: Applies To The examples demonstrated below are tested with and apply to the following versions of SharePoint: SharePoint 2010 SharePoint 2013 Get the List, and the first SPListItem This is the basic code for getting an item. If the list has at least one item, the first item is retrieved, otherwise a new item is created. var web = SPContext.Current.Site.RootWeb; var list = web.Lists...

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code protected override void OnInit(EventArgs e) { base.OnInit(e); InitializeControl(); // Register the ScriptManager ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page); if (scriptManager == null) { scriptManager = new ScriptManager(); scriptManager.ID = "ScriptManager1"; scriptManager.EnablePartialRendering = true; ...

Search This Blog