View Complete Post
I have issueÃÂ retrieving data from a remote oracle database usingÃÂ Business Data List WebPart. I have created an BDC definitionfile using the BDC Meta ManÃÂ tool.ÃÂ ThenÃÂ I imported this defination fileÃÂ into the Shared Services, so no issue it successfully imported the file.Now when I try to display the data using Business Data List WebPart,ÃÂ itÃÂ fails to display any data. It gets the column headings but no data. I get an error stating "An error occurred while retrieving data from OracleInstance. Administrators, see the serverlog for more information."The SharePoint log has the following exception:Exception handed to HandleRuntimeException.HandleException System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.ÃÂ ÃÂ ÃÂ ÃÂ at System.Data.OracleClient.OCI.DetermineClientVersion()ÃÂ ÃÂ ÃÂ ÃÂ at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)ÃÂ ÃÂ ÃÂ ÃÂ at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)ÃÂ ÃÂ ÃÂ ÃÂ at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConn
i have a dropdownbox and a gridview
what I want is to have a list item which populates all data in a gridview.
I have tried using list item selected value=0 but to no avail.
what is the easiest way to achieve this?
I'm having a devil of a time joining two tables for a BDC to be used as a Business Data field in a list. I've seen plently of examplesÃÂ connecting two tables to use with web parts, however i haven't seen anything about using an association in a list. Before i continue to beat myself up i need to know that this is possible.
If that's confusing here's what i'm trying to do.
I have two tables Locations and Region. I need the Region_Name from the region table based on the Location_Id (primary key) from the Location table. Locations is connected to Region by Region_id as a foreign key.
Any help would be immensely appreciated.
I have a datalist binded to an object data source which has a method
In the data list Item template, I have put a div with a heading that will not show if there is no language by that personId in the database table.
If there is data them problem is the datalist repeates the heading for each language instead of showing just the heading above and the row of languages below. I have included all my code below if somebody could advise what is wrong. thank you.
Method in DAL
SELECT PersonId, LanguageId, (SELECT LanguageName FROM Language WHERE (LanguageId = PersonLanguage.LanguageId)) AS LanguageName FROM PersonLanguageWHERE (PersonId = @PersonId)
<asp:DataList ID="DataList3" runat="server" DataKeyField="ModelId" DataSourceID="ObjectDataSource4" RepeatDirection="Horizontal" > <ItemTemplate> <div id="Div03"&n
I want to show search result as default parameters when initiation of business data list.
Is there any solution to solve this problem. Thanks.
Background: In SPS 2010 I created an External Content Type that is displaying the Customers table from a Customers database in SQL Server 2008. (I also added myself as the DBO for that database.) I configured the ECT to authenticate with the User's
Identity and to also use the Secondary Secure Store Application ID "contoso\administrators". I then added both these accounts to the Business Data Connectivity Service and granted them all four permission sets. I configured the ECT Operations to perform all
operations, and I filtered the return by limiting it to a 100 items. Using the Create List and Form wizard I then created an External List from the ECT.
Problem: When I display the External List in the browser I get this error - Access denied by Business Data Connectivity.
I have read several blogs about this issue (which seems to be common) but I still can't resolve it. Can anyone help?
I'm trying to implement Business Data Lists hitting our DBMS. The queries are very resource intensive, but the data is not going to change much day to day.
Even though I have the "Enable Data View Caching" enabled and the Data Caching Timeout set to 24 hours, 8 hours, etc etc I'm still seeing trips to our DBMS.
What gives? I thought DVC was supposed to enabled out of the box on these web parts?
http://support.microsoft.com/kb/2000112 This says it won't work on non Publishing Pages, but (as far as I know) all my pages are publishing pages.
I am working with sharepoint 2007and I am trying to add a webpart list, specifically a Business Data List.
I am trying to do it through Site Actions> Edit Page.
Thanks in advance,
I have a BDC entity whose fields contain a variety of data – numbers, dates and strings.
When I use the business data list web part I find that some of the columns’ dynamic filtering (accessed from the list’s column header) doesn’t work.
For these problem fields, the filter values load correctly but when I select a value all records disappear.
Initially I thought this was limited to just string columns but there is one string column that does filter correctly.
Here are some things that may be useful to know:
The datasource is a SQL view and all fields are varchar(255)
I have a BDC xml file which specifies a finder and a specific finder method. These both work fine.
What I want to do is configure the application so that when connected to a list column the object picker uses my finder method rather than the specific finder method which it defaults to. Is this possible?
For further explination if you look at the following image
If I want to find the department using the objet picker I have to type the full identifier.
If I click the browse (address book icon) to popup the browse window I can then use my finder method. I want the initial object picker to use my find method and if there multiple matches be able to pick one using the popup you get when the message "No exact
match was found." is displayed.
Hope this makes some sense!
Here's what I have so far...
1. I have a document list in MOSS 2007.
2. Each document in the list
may be sent to an external system for further processing. This was done by adding a custom feature to the document libraries actions menu in SharePoint.
3. The external system uses it's own SQL Server database. A table in this database references the SharePoint document’s GUID. Additional
columns in the table are updated during external processing data such as status.
The problem I'm trying to solve is this:
1. I would like the see the external processing status for a document in the original SharePoint document list. This status will change and needs to be updated for each document automatically.
I tried setting up a business data column in the document list. I created the XML definition of the external SQL Server table using the MOSS 2007 SDK and imported the definition. I added the business data column to the list