Using the SharePoint Business Data Connectivity Designer in VS 2010

The Discussion

• 

  Hey Now Beth,

   

  Nice Vid, learned a lot.

   

  Thx 4 the info,

  Catto

   

• 

  Thank you for the tutorial... but I get the following Error:

   

  Error 1 Error occurred in deployment step 'Add Solution':

  There is no default Business Data Connectivity Service Proxy available for the given SPServiceContext.

   

  Any help?

  Thanks

• 

  Hi, which SharePoint version are you using?

   

  Thanks,

  Boris

• 

  Hi, I get the following error when i add the external list to sharepoint

   

  Error while executing web part: System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString conne

   

  I've searched the internat for possible solutions, but nothing that i've read has solved my problem. Which included increasing the number of recs to read, changing SQl authentication to mixed.

   

  thks

  Faizel

• 

  Hi Faizel,

   

  The error message usually occurs when you are using Windows Authentication and the SQL Server instance is on different computer. Ensure that the account being used to access SQL Server is a domain account. If the account being used is a local account on the client computer, then this error message occurs because the SQL Server and the Domain Controller cannot recognize a local account on a different machine.

   

  If you use SQL Server authentication make sure that that the SQL Server login exists.

   

  Thanks, 

  Boris

   

   

• 

  Excellent - just what I wanted to learn.

  After following instructions for setting up SharePoint 2010 on Windows 7, following the first BDC Project instructions and following the blog entry about Fearure Event Receiver, I get 500 - Internal Server Error at the "Adding Solution" step of deployment process (in your video, when you press F5). Any suggestions?

   

  These are the references I followed:

  http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx">http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx

  https://blogs.msdn.com/sharepoint/archive/2009/12/03/walkthrough-of-creating-a-sharepoint-2010-external-list-using-visual-studio-2010-beta.aspx

  https://blogs.msdn.com/vssharepointtoolsblog/archive/2010/04/02/deploy-a-bdc-model-project-to-sharepoint-foundation-2010-using-visual-studio-2010.aspx

  https://code.msdn.microsoft.com/BDCSPFoundation

   

   

• 

  Thanks, great introduction to creating a BDC in Visual Studio .  

  I hope it has given me enough to get one created.

  Must admit that some follow up demostrations of the following would be great:

  • Using Filters (I know I'm going to need them sometime)
  • Saving, and accessing, connection details (or server level parameters in general) in the "right" place.

   

• 

  Hi

   

  I running a BCS solution in sharepoint 2010 web site, the readitem, readlist, create and delete operations work but the update operation has a problem throwing the following exception: Microsoft.SharePoint.WebPartPages.DataFormWebPartException: Data Source Conflict: Your changes conflict with those made concurrently by another user.

   

  I don't know what is wrong

   

  Any help

   

  Julian 

• 

  Hi Julian,

   

  Make sure all the fields in the update method's parameter have updaterField set to True.

   

  Cheers,

  Vamshi

• 

  Excellent - just what I wanted to learn.

  After following instructions for setting up SharePoint 2010 on Windows 7, following the first BDC Project instructions and following the blog entry about Fearure Event Receiver, I get 500 - Internal Server Error at the "Adding Solution" step of deployment process (in your video, when you press F5). Any suggestions?

   

  These are the references I followed:

  http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx">http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx

  https://blogs.msdn.com/sharepoint/archive/2009/12/03/walkthrough-of-creating-a-sharepoint-2010-external-list-using-visual-studio-2010-beta.aspx

  https://blogs.msdn.com/vssharepointtoolsblog/archive/2010/04/02/deploy-a-bdc-model-project-to-sharepoint-foundation-2010-using-visual-studio-2010.aspx

  https://code.msdn.microsoft.com/BDCSPFoundation

• 

  Try this post, this guy is brilliant!! http://www.gabrielrenom.net

• 

  Hi Vamshi,
  Do you know of your suggestion solved Julian's problem?  I'm having the same problem but even through I've verified that Updater Field is set for all properties in my Update parameter, I'm still getting the same error.
  Could you please let me know if there's another source of this error?  I'm really stuck on this!
   
  Thanks,
  KBW

• 

  Is the code/demo available for the NortwindEnities service (svc) that Boris connects to?

  Ok it looks like I do not need to create my own as there one on the web http://services.odata.org/Northwind/Northwind.svc/.

  Next problem is that Boris has a table called EmpWorkSpace and my Northwind does not!

  Where does the EmpWorkSpace come from?