View Complete Post
I am using business data catalog to display the records present in the Active Directory based on the user selection of samAccountName. Since the number of records present in Active Directory are more
than 3000 the user has to iterate through each page to get to a particular record. I want to add a kind of filter to my Definition file that user can search for a particular samAccountName from the list of samAccountName displayed in the business data list
web part. I am using office server SDK by microsoft to generate the application definition file.
Any help regarding this will be appreciated.
Dear all.. i have a problem with BDC
when i click new external content type, and type the server and dbname and optional name
i get this mesg
The BDC Service application Business Data Connectivity is not accessible. The full exception text is: Method not found: 'Void Microsoft.BusinessData.Infrastructure.AccessDeniedException..ctor(Microsoft.BusinessData.Infrastructure.IAccessControlList,
System.Type, System.String, Microsoft.BusinessData.Infrastructure.IExceptionHelper)'.
same in event viewer.. can someone help me with this?
admin is on BDC, created new BDC service and associated my webapp to it, admin is on all sql server and my database that i connect to..
nothing worked 4 me. !!
appreciate your fast responce
You have network application pool accounts setup in IIS. You need to access data from sql server to BDC. You need to have some authentication done to access the data from BDC. What mode of authentication should you specify in ADF file?
a)pass through b)revert c) rdb credentials d) windows authentication.
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 Comparison and exactMatch ,Even then it did not work.
Following is the app def file
I am working on a project currently where I need to get data out of a 3rd party vendor's software that uses a .sdf file I looked this up and its a SQL CE file. I was hoping to just link to with with access but thats apparently not going to happen. I need to link to the database extract data from it to a csv file for later use. I also and most important I need to get the data from it and create a report that can be printed while on a customers site that my or may not have web access so I need for this program to be on and off line. I had my webapplication that I have been working on open and was able to bring up the sdf file under the server exploere however I can't seem to get anything out of it when I try to do grid views or detail views errors out.
Can I use one of Visual Studio projects to create this sort of applicaiton if so what would be the best approach. I would love to get an access odbc driver since office is allready installed on the employee's laptop's
I have a web app where user uploads a file.
File is saved in server locally and I want to read some data from it.
Currently my development server has office 2003.
So do I need office 2007 in order to be able to read an excel from office 2007 ?
What are other requirements ?
I tried a test, using
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();wrkBook = excelApp.Workbooks.Open(@"C:\www\excel_files\b.xls", ....);
But When trying to open the file I get the error:
Exception from HRESULT: 0x800A03EC
So I'm wondering what I'm missing.
I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where
i can just call the method with my SQL Query
Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");
Plz Post the link if there is any open source !
I was assigned to create a app to convert SQL data to EDI 835 file. (Electronic Data Interchange file for Health Care Claim Payment/Advice, outbound process only).
Can someone help me where to start?
I was rummaging the internet learning aspx and came across the concept of: Microsoft Application Block for Data Access in .NET
It seems great of course. The articles are all early 2003-5 such as
So the question is - is this tech still relevant and should I be using it?
Windows Presentation Foundation has a rich data binding system that includes flexible support for business data validation. We take a look at implementing some complex data input validation scenarios that include customized data errors for users.
MSDN Magazine June 2010
Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.
MSDN Magazine December 2009