Recent update: 2008-3-21
9436 byte By
seth23 at 2008-3-7
Hello all :)I'm trying to import an xml definition file into my ssp in moss2007.i have few entities, among which Members and Personns, which are related as shown in the association in the end of the file.Both entities have an 'id' field. and i have the following error when ...
5283 byte By
Vansen at 2008-3-6
Hi, i came about a problem recently. I had to connect a BDC Application to some Database-Views. These are Views that have about 160 Columns each. I wanted to have all Columns available in the Entity - So i thought about what to do now ? The solution I worked out took me about 15 mins to ...
311 byte By
Vansen at 2008-3-5
Hi, is it possible to have one or more connections to a Database and one ore more connections to a web service inside only one XML-Metafile ? Is it possible to have Associations between entities located inside different XML-Metafiles ? How could this be done ? TIA, Oliver ...
Hi Is there any sample BDC application file available for connecting to SAP other than the one found in /Program Files/ Microsoft Office Server/12.0/BDC folder?Secondly do we need to install the SAP .Net Connector on the MOSS Server to connect to SAP?Thanks and Regards Guruprasad Karnik ...
3704 byte By
Erulu at 2008-3-1
I defined the wildcard as "%" (this is proposed in all examples I've seen): <Property Name="WildcardCharacter" Type="System.String">%</Property> I've a SQL statement defined: Select Uid,firstname,lastname From dbo.Participant WHERE ...
1130 byte By
Vansen at 2008-2-28
Hi everyone, this week i set up a BDC connection to an Oracle Server - 8.7.1 to be precise. I also had to install the oracle client software - also 8.7.1. Everything worked fine - i was able to see all the rows of the table inside of MOSS. Then i came across one problem: i tried to add a ...
190 byte By
Erulu at 2008-2-27
How is it possible to add a checkbox in every line of a BDC column? I want to select multiple entries in my BDC list web part and process them in any way (e.g. delete all selected entries).
935 byte By
Erulu at 2008-2-26
How can I pass parameters to the BDC? E.g. Assume that I have a dropdown list with different names (name1,..., name10) and I want to group my result by nameX. SELECT * FROM myTable GROUP BY @nameX My question is not limited to the GROUP BY expression it should work for every SQL statement ...
I've got several large Lob Systems mapped into the BDC, and have been using them and searching them successfully, until I realized a problem today, and I can't seem to find documentation about it.I have fields in my entity of type DateTime, but when I go to create a managed property and map ...
Hi,I've recently started using Sharepoint 2007 and I'm trying to use the KPI feature with some data we have in an SQL server 2005 database. I've managed to setup BDC so that I can display the table pretty much as it is in the database in a Business Data List. What I'd like to have is a KPI ...
3709 byte By
Erulu at 2008-2-23
If my RdbCommandText contains no parameter, it isn't possible to have an action with a parameter? I tried just to define a simple SELECT statement (without any parameters) and defining the Actions in the XML file or in the SharedServices ("Add Action"). Every time I defined an ...
165976 byte By
Vansen at 2008-2-22
Hi All, i got a big problem defining Associations. I always have this problem when defining an association. Maybe someone can clear things up for me where this stupid mistake is coming from. The XML File beneath connects to a CRM system. There SourceEntity:Accountbase is connected to the ...
Hi, I am stuck to import the application definition file for web service. Do anyone have the such application definition file for webservice? I just want to get the array of string or objects from web-method. any help appreciated. Thanks. Masood.
918 byte By
Erulu at 2008-2-21
How can I pass parameters to the BDC?E.g. Assume that I have a dropdown list with different names (name1,..., name10) and I want to group my result by nameX.SELECT * FROM myTable GROUP BY @nameXMy question is not limited to the GROUP BY expression it should work for every SQL statement ...
189 byte By
Erulu at 2008-2-20
How is it possible to add a checkbox in every line of a BDC column? I want to select multiple entries in my BDC list web part and process them in any way (e.g. delete all selected entries).
165584 byte By
Vansen at 2008-2-19
Hi All, i got a big problem defining Associations. I always have this problem when defining an association. Maybe someone can clear things up for me where this stupid mistake is coming from. The XML File beneath connects to a CRM system. There SourceEntity:Accountbase is connected to the ...
607 byte By
Rhonda at 2008-2-19
We have MOSS 2007, users have Office 2003 on desktops. We have a document library of standard documents with about 10 metadata fields for each doc. Three of the fields are using BDC to feed directly from another sql database. When a user navigates to the document library they see all of the fields d...
Hi,I've recently started using Sharepoint 2007 and I'm trying to use the KPI feature with some data we have in an SQL server 2005 database. I've managed to setup BDC so that I can display the table pretty much as it is in the database in a Business Data List. What I'd like to have is a KPI ...
486 byte By
ieka at 2008-2-17
hai.. i just want to ask a few question. im using 2 servers rite now. one is MOSS and another one is SQL server 2005. this sql is running on virtual server. Im using the AdventureWorksDW database sample and i can import the application definition in my MOSS. but when i try to create a business ...
Hi,We have a collection of web parts (bdc list, document lists, tasks and others) which all show filtered data according to the selection made by the user via a BDC filter. When the user browses around and potentially goes into a parent or sub site we want their choice to be retained so that ...
1120 byte By
Vansen at 2008-2-15
Hi everyone,this week i set up a BDC connection to an Oracle Server - 8.7.1 to be precise. I also had to install the oracle client software - also 8.7.1. Everything worked fine - i was able to see all the rows of the table inside of MOSS. Then i came across one problem: i tried to add a ...
3691 byte By
Erulu at 2008-2-15
I defined the wildcard as "%" (this is proposed in all examples I've seen):<Property Name="WildcardCharacter" Type="System.String">%</Property>I've a SQL statement defined:Select Uid,firstname,lastname From dbo.Participant WHERE ...
Hi,I have a SingleServer instalation for MOSS.I get this "Unable to connect..." error in BDC Item list web part. I think is something with the credentials the goes to SQL Server. <LobSystemInstance Name="Charisma TS"> <Properties> <Property ...
14286 byte By
Erulu at 2008-2-15
I'm working with the BDC for about 2-3 weeks and there are some things that are quite confusing. Although I've read and searched a lot in the BDC's literature I couldn't answer my questions:Business Data List web part: Search field# I remember that The BDC MetaMan created at first a ...
Hi AllI'm looking to find a way to share list data across sites, so that the data is available in lookup columns. The current lookup column type only allows lookup from lists in the same site - could the BDC be used to access data in lists in other sites via the Sharepoint web services? then I ...
Hi,I am creating a document library in SharePoint. In the document library I have a BDC attached that gets the account data from my MS CRM database. By picking browse in the properties of a document I’m able to find accounts.However when I open a word template I don’t get the opportunity to ...
Hi, Does anyone knows how to access MSAccess database using BDC (Business Access Database) with MOSS 2007.
I have been visiting this forum in the last few weeks; asked a few questions and posted a few responses. My observation lets me draw 2 conflicting conclusions: There is so little traffic in this forum that I think nobody out there is using BDC, or everyone out there knows how to use BDC. But it ...
In Intranet and Extranet situations when I use AD, I can permit a whole group of AD users to use BDC and that simplifies administration; but in Internet situation when I use ASP.NET 2.0 membership and role providers that access a database store, I don't know how to do it. I can assign each ...
9442 byte By
seth23 at 2008-2-12
Hello all :)I'm trying to import an xml definition file into my ssp in moss2007.i have few entities, among which Members and Personns, which are related as shown in the association in the end of the file.Both entities have an 'id' field. and i have the following error when ...
Hi,I have a WSS3 application that needs to query an SQL2000 ODBC source. I've seen the functionality of BDC in MOSS2007, but can the same functionality be applied against WSS3. In other words is there anything out there that I can install and configure to perform the same BDC function - a web ...
Hi,I m getting following error when crawling:bdc2://a9aed45a-d536-464c-8881-08adbd9d6599/226...The object was not found. (The item was deleted because it was either not found or the crawler was denied access to it.)Note that I am using web-service. The authentication method where web-service ...
Hi,We have a collection of web parts (bdc list, document lists, tasks and others) which all show filtered data according to the selection made by the user via a BDC filter. When the user browses around and potentially goes into a parent or sub site we want their choice to be retained so that ...
9443 byte By
seth23 at 2008-2-8
Hello all :)I'm trying to import an xml definition file into my ssp in moss2007.i have few entities, among which Members and Personns, which are related as shown in the association in the end of the file.Both entities have an 'id' field. and i have the following error when ...
I have been visiting this forum in the last few weeks; asked a few questions and posted a few responses. My observation lets me draw 2 conflicting conclusions: There is so little traffic in this forum that I think nobody out there is using BDC, or everyone out there knows how to use BDC. But it ...
posted this over in general QA and thought it might go here better:Using MOSS and the BDC, we have the capability to add Business Data as columns in a list. How would I go about creating a "People" type in my BDC that pulls the data from the user profiles in MOSS?What I would like to ...
Hi, Is there any application definition file for Active Directory. I want all users from active directory for given groups or some other criteria... Please help... Thanks!
Hi Is there any sample BDC application file available for connecting to SAP other than the one found in /Program Files/ Microsoft Office Server/12.0/BDC folder?Secondly do we need to install the SAP .Net Connector on the MOSS Server to connect to SAP?Thanks and Regards Guruprasad ...
Hi,I'm trying to work with the AdventureWorks sample database SQL 2005 version and BDC in MOSS 2007. The application is correctly defined in MOSS, using the sample XML application definition file for AdventureWorks SQL2000 version. When I try to retrieve data from the web part, I get an error ...
Hi, I'm using the AdventureWorks BDC example to try to assiociate two entities. The example works, but when I do my modifications, I get the error "Could not find fields to insert all the Identifier Values to correctly execute an Association method." It's possible I've stared ...
<span class=ms-error>Here's the message, what log is this referring to? "An error occurred while retrieving data from aspnetdb_ExtranetInstance. Administrators, see the <span style="font-weight:bold">server log </span>for more information."</span>
Hi,I am facing two problems:The first problem is that I am able to import the application definition file successfully but when I am going to use the entity, I could not find that application and entity in the "Business Data Type Picker".I have checked all the permission with the ...
Has anyone figured this out? Metadata defines a static list of actions that an entity can perform, but I would like the action list to be customizable in code so that one role can perform certain actions and the other role can perform others. MSDN hinds that this can be done but there is no ...
I think (based on experiment and crawling through the internet) that this is impossible, but I will ask again - does anyone know of a way to make a BDC column multivalued?I have a web service that allows people to seach for values from an external system, but they need to select more than one ...
MOSS documentation states explicitly that I cannot do what I want to do, namely, create a data source connection to lists and document libraries in another Sharepoint site collection:"If the other site is in the same site collection, you can access all of the data sources in that site, ...
<span class=ms-error>Here's the message, what log is this referring to? "An error occurred while retrieving data from aspnetdb_ExtranetInstance. Administrators, see the <span style="font-weight:bold">server log </span>for more information."</span>
Hi,I am creating a document library in SharePoint. In the document library I have a BDC attached that gets the account data from my MS CRM database. By picking browse in the properties of a document I’m able to find accounts.However when I open a word template I don’t get the opportunity to ...
<span class=ms-error>Here's the message, what log is this referring to? "An error occurred while retrieving data from aspnetdb_ExtranetInstance. Administrators, see the<span style="font-weight:bold">server log </span>for more information."</span>
Hi All,I'm trying to setup a connection to a WebService using Single Sign-On credentials. I have configured the LobSystemInstance as follow. <Property Name="WebServiceAuthenticationMode" Type="System.String">WindowsCredentials</Property><Property ...
I am trying to execute a application definition file through webpart .The filter has to be done based on UserID which is of Type Int64.But it gives error as "A Wildcard filter requires a TypeDescriptor that resolves to a String:Hence i tried to change the Filter descriptor to type ...