Using the SharePoint Business Data Connectivity Designer in VS 2010 | Visual Studio Team Interviews

ccatto
Catto

Hey Now Beth,

Nice Vid, learned a lot.

Thx 4 the info,

Catto

Frigor

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

bscholl

In reply to Frigor

#Mar 21st @ 1:46 PM

Hi, which SharePoint version are you using?

Thanks,

Boris

faizelw

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

bscholl

In reply to faizelw

#Apr 26th @ 5:47 AM

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

MSSAP

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://blogs.msdn.com/sharepoint/archive/2009/12/03/walkthrough-of-creating-a-sharepoint-2010-external-list-using-visual-studio-2010-beta.aspx

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

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

Aussie Craig

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

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.

jbueno

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

Vamshikgovind

Hi Julian,

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

Cheers,

Vamshi