Everything I've read on setting up External Content Types with BDC seems to use SharePoint 2010, rather than SharePoint Foundation (SPF) 2010 (the free version). Even though it also includes BDC, it doesn't seem to include support for creating a Secure Store App ID for alternate credentials (like full-blown SP does). I cannot seem to get an External List to read from a SQL database table because of this. I'm using a Database that is on the same server as my SPF installation, so it's not doing any remote connections. Can anyone point me to something helps explain this properly?
SharePoint Foundation 2010 and BDC with SQL
2.5k Views Asked by Skatterbrainz At
2
There are 2 best solutions below
0
Skatterbrainz
On
After reviewing a bunch of articles, the solution appears to be explained here: http://wyldesharepoint.blogspot.com/2010/06/setting-up-external-content-type-for.html
Related Questions in SQL-SERVER
- SQL server not returning all rows
- Big data with spatial queries/indexing
- Conditional null constraint on Null
- SQL Query - Order by String (which contains number and chars)
- Optimising a slow running SQL Server Stored procedure ordered by calculated fields to return a closest match
- Dynamics CRM Publishing Customizations - Multi Developers
- Is there anyway to set the relationship of many tables from Model?
- Implementation of Rank and Dense Rank in MySQL
- ORM Code First versa Database First in Production
- MVC : Insert data to two tables
- Data streams in case of Merge
- table with multiple IDs but seperate notes need sorting (Tried SQL code to make a union query)
- SQL table Partitioning by Year with ColumnStore index implemented on the table
- Defining which network to use for SQL Server 2012 Management Studio
- Fill a week days in a table with preceding Sundays value
Related Questions in SHAREPOINT-2010
- Upload a document to a SharePoint document library (can be via Rest Api/other) using C# & also retrieve the unique id of the document
- Sharepoint alers email deletion from alerts
- Apache Reverse Proxy erases <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
- Can REST-like URLs be passed/recognized in sharepoint 2010?
- Configure SharePoint 2010 UPS with PowerShell
- How to dynamically create Sharepoint ComboBoxes?
- SharePoint 2013 Custom list field iterator not saving values for MultiLine or person columns
- Publicly available InfoPath form connecting to Access db in a restricted location
- Why does my Sharepoint WebPart deploy (nominally), but is still not available for adding to a page/form?
- Does CAML Query has a default RowLimit value?
- SharePoint CSOM
- I am getting a The type or namespace name 'listcolumns' could not be found (are you missing a using directive or an assembly reference?)
- Sharepoint 2010 CMIS Integration
- JQuery Show All Tab - Issue with on click
- jQuery UI API failing to load properly with LABjs
Related Questions in DATABASE-CONNECTION
- sqlalchemy force all connections to close mysql
- Android: How to connect oracle database using Android Java code?
- Can not connect to local database via SSMS
- EF Database not Connected Exception
- Why my mysql transaction is not working properly?
- PHP error connecting to MS SQL 2005 using CodeIgniter
- How to manage multiple connections for different users
- What is the connection URL to be used for Cassandra?
- Database connection suffers of concurrent threads
- Unable to connect to database after migrating to Hibernate 4
- What happens if you close a closed connection?
- Closing of DB connections and exception handling
- Database Design Advice for a Social Network App Needed
- Eclipse 4 RCP with ibm rational Doors Database
- could not find installable isam access #2
Related Questions in BDC
- SharePoint List with External Data Column not detecting records deleted from Source DB
- SharePoint BDC - In the Entity Picker control when the user selects the entity a guid is added to the text
- Changing the Sort order on BDC Actions in SharePoint
- Formatting of BDC Fields
- Is BAPI an interface or a conversion tool as per RICEF?
- Why Does SharePoint External Content Item Picker Not Select Item When OK is Pressed?
- How to connect SharePoint Online with Dynamics CRM Online using BDC?
- How to use BDC (business Data Catalog) in sharepoint of user define?
- Filter SharePoint Business Data List By Audience
- SharePoint BDC Service error: Cannot connect to the LobSystem (External System)
- Error when updating SharePoint 2010 list using External Content Type
- Sharepoint 2010 Claims in BDC
- BDC Paging
- How to remove a server from Active Directory when the connection fails?
- Sharepoint BDC Error: The title property of entity tblStaff is set to an invalid value
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Yes, Secure Store is for Standard+.
This link might help you on the right path:
https://sharepoint.stackexchange.com/questions/3331/sharepoint-2010-foundation-bcs-errors/