.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to get a list of all the BCS services in a farm

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

This question is pretty similar to this post


I have been searching the web using this post as an example to try and find the missing pieces.  I would like to get a list of all the BCS services in the SharePoint farm and show them in a list to the user.

I have tried searching for SPServiceApplicationProxyGroup, BdcServiceApplicationProxy, and a few other bits and pieces.  I don't know if I am tired or really dense, but I am missing something obvious here.  Hopefully someone can point me in the right direction because right now i am left with reading MSDN object trees hoping to find something that strikes a chord.






View Complete Post

More Related Resource Links

Add Items to List with BDC Column via Web Services

I really hope this is possible.  I am trying to add items to a list that have a BDC column as one of the fields.  Here is the code I am using in the Batch

batchElement.InnerXml = "<Method ID='1' Cmd='New'>" +  
"<Field Name='Title'>Hello World</Field>" +  
"<Field Name='bdc'>BDCIdentifier</Field>&

Feature for XXXXXXXX list template XXX is not installed in this farm. vsewss

Hi Do you know why I got the error below and how to solve it ? Feature for XXXXXXXX list template XXX is not installed in this farm.  The operation could not be completed. ThanksMomo

How to query for id's of the fields with List Data Retrival Services Query() web service

Since i marked a post as answer in my previous topic, it seems that people dont visit the topic anymore as they see it as "answered" while it actually is only partially answered. So i guess i have to ask again in a different topic.    I need to get data from Sharepoint Server (3.0 i belive) for my Integration Services project. For that i use Sharepoint's webservices. I've read tutorials and downloaded sample programs to talk to WSS web services. I realise i have two ways to get items in a list: Use Query() or GetListItems(). Problem is, GetListItems() has a mandatory "Row limit" field and i might have to import ALOT of fields, so i thought Query() is better for me.  But, when using GetListItems(), the WSS returns the ID of the fields (for example, for a field of type user, something like "395;Ivanov Ivan Ivanovich" is returned) but when using Query() for the same list, WSS returns only the field value ("Ivanov Ivan Ivanovich") without the ID. I need it to return the ID as well. How can i set it up, on my side or server side, so i would receive the ID's, not only the values of the fields that are actually linking to something by ID when i use Query() web service?     

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

Full Farm Backup Fails on Windows Sharepoint Services Search Database

I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

How to delete list item by its url using web services?


How guys,

I need to delete an SPListItem from remote MOSS site. The problem is that I don't know its id, only url.

Any ideas?

Getting servers list in the farm in WSS 2.0


I need to get the list of all servers in the farm. Using WSS 3.0 I can do that

                            using (SPSite startSite = new SPSite(ConfigurationSettings.AppSettings["FarmName"]))
                                SPFarm farm = startSite.WebApplication.Farm;
                                foreach (SPServer spServer in farm.Servers)

How to scale from Single Farm Services to Enterprise Farm Services


I have a question onHow to scale from Single Farm Services to Enterprise Farm Services. i.e

Today , if i have a Farm with All Services like Managed metadata and Search running .. . but  tommorow  client introduce 2 new farms then there are 2 options w.r.t to service sharing

a) either do cross farms sharing of services ... which i understand how it will happen

b) or because of XYZ reasons , go for Enterprise Service Farms which hosts your manage metadata service / Earch for all your farms .... 

So, question is in this case how one will move existing managed metedata / Search service to Enterprise Service Farm ?


Update a record in a SharePoint list using web services


Hi all,

I am trying to update one field in a record on a SharePoint list. I am using the code below to do this. The thing is it is tossing an error:

Unexpected end of file has occurred. The following elements are not closed: Method. Line 1, position 29.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Xml.XmlException: Unexpected end of file has occurred. The following elements are not closed: Method. Line 1, position 29.

Source Error:

Line 791:
Line 792:    /* Update the inspire field to exported*/
Line 793:    batchElement.InnerXml += "<Method ID='1' Cmd='Update'>";

Line 794:    batchElement.InnerXml += "<Field Name='ID'>6</Field>";
Line 795:    batchElement.InnerXml += "<Field Name='inpsire'>new</Field>";

As I understand; I create a method and then cmd update. I then give the ID of the record th

cascading drop down list in infopath forms services Using SharePoint Look up list from multiple Sh



Some one can help me, if possible screen shots.
Environment : MOSS 2007, InfoPath 2007

Question on Searching with Cross Farm Services


 have to Sharepoint 2010 Farms - called FarmA and FarmB. Both farms have web applications and content. FarmA is also a publisher of the Search Service Application. It has been configured to crawl content in both FarmA and FarmB.

I have successfully published the Search Service and the consuming FarmB see results from both farms when I do a search from a Enterprise Search Center site collection. The issue that I'm having is that when I do the same search in FarmA, I only see results from FarmA. I'm not sure if the results are getting security trimmed. I am using different farm accounts for earch farm, though I am accessing both web applications with my account. Or is there some additional configuration required on FarmA to show results from FarmB.

Any help would be appreciated Thanks in advance Brian Denicola

Consume SharePoint List in Excel Services


I found some older questions regarding this but they are all listed in the Pre-SharePoint 2010 forums. I wanted to know if there is anything I can do to more easily pull data from a SharePoint List (more specifically a set of related lists) into Excel Services such that data refresh is handled as well.


I found a couple topics that used UDF as solutions to this problem, but I am not sure if they will handle data refresh. These solutions are discussed in: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/79f5c968-b68f-4d53-bfe0-d57258cfed6c and http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/16f9255d-cd06-4687-ab8e-68bd6210d0f8


I am hoping the 2010 version of Excel Services can handle this more simply, thanks!

Copy List Item using web services

how to copy a list item using web services?

Creating list items via web services (WCF Application)


I've been working with SharePoint over the last 5 years and only just recently started learning the programming side of it.  I'm still pretty shakey with C# but I am getting better each day.

I was asked to create a WCF Application which would allow our CRM application to pass data to MOSS 2007 so that a list item is created.  After much work, I have created this source code (http://www.mediafire.com/?o7l0l444ee72oy8).  The problem is that I don't actually know if it works since I am unsure how I can test it!

I tried creating unit tests within the solution and they do complete successfully, but the test item is not created in the SharePoint list.  After some furthe research, I have come to find out that unit testing with SharePoint is notoriously tricky.

At this point, I believe I need to create a test application (console app maybe?) to test the WCF and pass some test data through the web service but I'm not sure how to do this correctly.  Any help would be greatly appreciated since I am still getting familiar with coding.  Thanks!

MOSS 2007 Services Not Starting After Adding 2008 R2 WFE to 2003 R2 Farm


In preperation for our 2010 upgrade we have been migrating our 2003 R2 infrastructure to 2008 R2. Our prior environment was server 2003 R2 DB server running SQL 2005 and one 2003 R2 WFE. We migrated the DB server to 2008 R2 and SQL 2008. The next step was to add a 2008 R2 WFE and then decommision the 2003 R2 WFE.

Setup was successful on the 2008 R2 box. However, in CA the services on the 2008 R2 WFE show "Starting". The CA service is the only service that shows "Started" on the 2008 R2 box. The Document Conversions Launcher Service, Document Conversions Load Balancer Service, Windows SharePoint Services Search and Windows SharePoint Services Web Application show "Starting". The Windows SharePoint Services Administration does not display a status.

What step am I missing to get all of the services running on the new 2008 R2 WFE so I can turn off the 2003 R2 WFE? I don't see anything in the error logs.


Using SharePoint web services to access KPI List data



How to get the indicators in a KPI list data(like list row data) from SharePoint using SharePoint web services





unable to set indexing services on single server farm



I have recently updated from WSS 3 to MOSS 2007. Now I am not able to create SSP because I am not able to enable indexers.

When I am going to Operations-->Services on Server I am not able to find Office sharepoint search. Also the custom is selected as serices you choose run on this server.

Any help will be appreciated.

Thanks & Regards,

Rahul Rashu 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend