Data Controls :: Cannot Initialize Data Source Object Of OLE DB Provider

May 7, 2015

This is my query

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

insert into OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;
Database=D:TestDBFirst.xls;;HDR=YES',
'SELECT * FROM [Sheet1$]')
select * from MasterData

And this error comes

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

View 1 Replies


Similar Messages:

Forms Data Controls :: Object Data Source Calling Select Method Twice?

Jun 15, 2010

I have extended GridView in order to have consistent look & feel, paging and sorting. However, when the page is first time loaded, the select method is getting called twice. It works fine when i move between pages in pagination.

Note, i am using Asp.net 2.0.

View 2 Replies

Forms Data Controls :: How To Bind Object Data Source With Bullited List

Sep 27, 2010

i wanted to retrieve things from the data base and perform mathmatical operations on it then post it to the user, so i was told to use the bullited list and bind it to the object dataSource

how to perform such thing??

View 1 Replies

Forms Data Controls :: Object Data Source Class Duplication?

Dec 29, 2010

I populate a DetailsView from an ObjectDataSource that is coded in a class - meaning that the ods Select, Update, Insert and Delete are class methods. The selected record is set to come from a GridView.SelectedValue.

My problem is that when the page loads the code crashes. I am pretty sure I know why: the DetailsView is pulling from a class object and instead of using the existing class object it instansiates a new one which is empty.

Here is the details view code:

[Code]....

Here is the odsDetailsView_1:

[Code]....

As you can see from the code the odsDetailsView gets it's information from a class object "Match". The detailsview is not controlled by any code behind.

View 2 Replies

Forms Data Controls :: GridView Can't Filter Because Of Object Data Source?

Mar 30, 2010

I have the web page that meet the problem. There exists a gridview and filtering. When Select all by using function A, it is OK. when Filter by using function B, it cannot filter and return no rows. When Select all again, it is OK. I have tested that function B can return the corrected filtered rows. But when databind in the web page, it cannot show and no error?

<ContentTemplate>
<asp:GridView ID="gvwBOM" runat="server" DataKeyNames="ProductID"
AutoGenerateColumns="False" DataSourceID="objBOM" AllowPaging="True"
AllowSorting="True" BorderWidth="0px" CellPadding="3" CellSpacing="1" CssClass="grid-view"
OnRowCreated="gvwBOM_RowCreated"
OnRowCommand="gvwBOM_RowCommand"
OnDataBound="gvwBOM_DataBound" >
.........
<asp:ObjectDataSource ID="objBOM" runat="server"
SelectMethod="GetALTBOMs"
SelectCountMethod="GetALTBOMsCount"
EnablePaging="true"
SortParameterName="SortExpression"
TypeName="QI.BLL.WMS.ALTBOM" >
private void FillGridView(string filter)
{
if(filter == "0")
{
objDataSourceSelect="Afunction";
this.objBOM.SelectParameters.Clear();
}
else
{
objDataSourceSelect="Bfunction";
this.objBOM.SelectParameters.Clear();
this.objBOM.SelectParameters.Add("productSupplimentID", ddlTmp.SelectedValue);
}
this.objBOM.SelectMethod = objDataSourceSelect;
this.objBOM.SelectCountMethod = objDataSourceSelect + "Count";
this.gvwBOM.DataBind();
}

View 1 Replies

Forms Data Controls :: Correct Use Of Listvieuw With Object Data Source?

May 2, 2010

i made a small n-tier webapplication, a DATA project with my business objects a DA project with my datacces logic and a GUI project woth my website. For the CRUD operations on my main tables I use a lot of listviews, that works fine but when data grows its slows down.I used already used optimal paging & shared collection's to preventing database acces if data is already loaded en that helps alot.But I see when a user select the EDIT command the select of my listview is performed what is not needed, also when the user than select cancel the select is again called , is this normal behavior or do I made a mistake in program logic somewhere because this behavior is slowing my application down.

View 1 Replies

DataSource Controls :: How To Get Object Source Data

Jun 22, 2010

I am developing on application in that i have taken one list box and getting data to it using an object source.up to this stage it is fine.I need to compare these value what i get into list box and need to represent data in to a report viewer ..how to get these values from objectsource.i m new to c# i placing the code.

[Code]....

View 1 Replies

DataSource Controls :: Getting Rows From Object Data Source?

Jan 7, 2010

I have an object data source that is being used by an rdlc report, and the object data source uses a filter that is built from session variables passed to the page.

The report displays correctly, with the filter applied; however, I want to mark each of the rows as "printed" in a bit field in the database table.

In the table adapter, I have the following Update command that is used by the object data source:

UPDATE dbo.WorkOrder
SET boolWorkOrderPrinted = 'True'
WHERE (WorkOrderID = @Original_WorkOrderID)

And in the Page Load event, I run:

ObjectDataSource1.Update();

However, no records are updated.

View 1 Replies

DataSource Controls :: Is It Possible To Use A Property Of An Object Instance Property For Object Data Source

May 3, 2010

Traditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?

So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.

View 4 Replies

The 'Microsoft.Jet.OLEDB.4.0 Data Source=d:websiteorthwind.mdb' Provider Is Not Re?

Nov 27, 2010

i m running vs 2005 +asp.net with +xp professional+ms access 2003 now problem when i run code of for opening of oledb connection it shows error The 'Microsoft.Jet.OLEDB.4.0 data source=d:website
orthwind.mdb' provider is not registered on the local machine.wht should i do if u r taliking about 32 or 63 bit provide me complete detail

View 2 Replies

DataSource Controls :: How To Create It ,Object Data Source ,Linq And Sql Or Other Any Way?

Sep 20, 2010

my query is SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO
FROM V_HIERARCHY1 a

my data is ,HR HR Rec Records Leave Leave Records HRL.0001 Policy and Process for leave record. 27.06.2010 30.06.2010 WIP Edlink
HR HR Rec Records Leave Leave Records HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned Edlink
HR HR DB Database SAL Salary DDS.0001 Calculation of Monthly salary 08.08.2010 09.08.2010 WIP Edlink
HR HR Rec Records Ind Induction Records HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010 WIP Edlink
HR HR DB Database Emp Employee HDE.0001 Offer letter 06.07.2010 09.07.2010 WIP Edlink

my outout is ,HR

REC
LEAVE
HR1
REC1
LEAVE1

View 1 Replies

DataSource Controls :: What Is The DB Type With The Parameters Of The Object Data Source

Mar 24, 2010

I was looking at the options in Intellisense for the properties used with a parameter for the Object Data Source. There is one that I don't understand how it would be used. explain, or recommend an article, about the DB Type is for and how it would be used?

View 2 Replies

Architecture :: Looking For Better Way To Design, To Use Object's Properties With The Object Data Source?

May 10, 2010

I've posted the same question in the Object Data Source forum. This is a link to it http://forums.asp.net/t/1554083.aspx. Maybe I should've posted here to begin with. There seemed to be some overlap so I wasn't sure which was the best on to post the question in.

I'm trying to get a better understanding of how I could've designed my app so that the Object Data Source could work with the properties of my business objects. Please read the other post to see how it's currently being done. Sorry for the link to the other page. I didn't want to post a bunch of duplicate information. I would love to get some suggestions for alternative ways of doing this.

View 1 Replies

DataSource Controls :: Use The Direction Property Of The Parameters For The Object Data Source?

Apr 20, 2010

I have an insert that uses an object data source with out the direction property set and it works fine. I noticed the direction property though and wondered if I should use it.Should the direction property for the parameters of an object data source be used with a simple CRUD operations?

View 3 Replies

DataSource Controls :: When Should Use The Type Property Or Dbtype With Object Data Source

Apr 24, 2010

I'm trying to understand when to use the type property and when to use the dbtype property. I looked online but couldn't find a good article that said when and why.

View 3 Replies

DataSource Controls :: How To Execute Object Data Source Method On Postback Only

Aug 10, 2010

When my page is first loaded i receive error message stating to the effect

cant find Email for GetInvoicesByVendor.

this refers to a function in another class file:

Public Shared Function GetInvoicesByVendor(ByVal Email As String, ByVal vendorid As Integer) _

As IEnumerable

yet i only want to execute this function during the button click event and not when page is first loaded with the following parameters:

vendorid.Text = 1
txtcustomerid.Text = test@yahoo.co.uk
My objectdatasource is declared as follows:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
OldValuesParameterFormatString="original_{0}"
SelectMethod="GetInvoicesByVendor" TypeName="InvoiceDB">
<SelectParameters>
<asp:ControlParameter ControlID="txtcustomerid" Name="Email"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="vendorid" Name="vendorid" PropertyName="Text"
Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

View 2 Replies

DataSource Controls :: Object Data Source Not Picking Up Business Objects?

Mar 26, 2010

I created a class library: PRTreatmentReviews. I created a reference for the class library on the website. I checked the property pages and the reference to the class is there. I put objectdatasource on a page and tried to pick up the PRTreatmentReviews class but it's not there? The Class

[Code]....

View 13 Replies

How To Retrieve A Subset Of Data From Entity Object Data Source And Pass To Another Page/

Oct 8, 2010

I am playing about just now trying to teach myself a little bit about the entity framework. I have a Gridview data bound to a Entity Date Source using the Entity Framework. If I select certain items in that list I then wish to redirect another page and populate another gridview with just the items selected (but with more detail, different includes/navigation properties)

This is probably the most simple thing but I have spent 2 hours banging my head on the wall trying to get this to work. Essentially I have a continue button which when clicked should identify all the UIDs (a column in the gridview) of the rows and allow me to subset to just these rows and pass them to another page to be rebound to another datagrid

View 2 Replies

Using Object Data Source In 4 ReportViewer?

Nov 22, 2010

I think I'm getting mad here...I thought this should be super simple, but I just can't figure out how to do that.This is what I'm trying to do:I want to create an rdlc report using the ReportViewer control in ASP.NET 4 (VS 2010), and, as its datasource, use a class with some properties.I tried everything I can think of, but I just can't figure this out. All the docs I found state that the object should appear in the DataSource pane of the website, but I can't make it appear there.I would like the fields of the class to appear in the report desiger so I can use them - but I can't do that either.Using the designer, I can only define new dataset - I don't want to use dataset, but business objects!So - how can I do that? Do I have to use some kind of DataSource control? How can I make the report designer know about the business object?

View 2 Replies

Working With Object Data Source In .net?

Aug 20, 2010

I am writting a website using .net in some of my pages I need to use datagrid for showing some datas and for binding my data to datagrid I use object datasource something like below :

//this is
public class userData
{
private long userid = 0;
private string username = null;[code]....

and then in my apsx file I put an objectdatasource and bind the select statement to the GetUsersAmount() and then bind obejctdatasource to my datagrid but I think the way I've chosen is not efficient I just want to hear about your way of doing such these things.

View 3 Replies

Object Data Source Is Stuck In First

Jun 21, 2013

I set up a DAL layer in a dll. This had a couple poorly named methods such as GetData(), which is the default name offered up in the tableAdapter wizard. I also added a few other methods for various reasons, all with better names. I then built the dll and referenced it in an ASP project. On one page, I added an ObjectDataSource, and set it to that tableAdapter (which isn't what I wanted to do, but that's a different story). Under the Select tab, I see the GetData and the other methods. Under the Update tab I see a variety of Update methods. Under the Insert and Delete tabs....I see the same methods as I saw under the Update tab. The Insert and Delete methods that exist for the tableAdapter were not available.

I figured that I did something wrong, and I didn't like that GetData name, so I went back to the dll and changed some things around (I think I added an Insert and Delete method, but by now I can't remember, except to say that I wasn't all that surprised not to see those two methods the first time). I also changed the GetData name to something else, then rebuilt the dll.

Since that time, I have yet to be able to change what shows up in the Object Data Source configuration. The Select adamantly insists on the GetData method, which no longer exists under that name, while the other three tabs all show a variety of Update methods, but neither Insert nor Delete. I noticed that just adding a reference didn't have any impact until the ASP project was built, which moved the dll to the bin folder where it needs to be for the Object Data Source configuration wizard to see it. Therefore, I deleted the dll from the bin folder, then rebuilt. I've also removed the reference, deleted the dll from the bin folder, rebuilt, added the reference, rebuilt again to get the dll back into the bin folder, and anything else I can think of. It still seems to be retaining the original schema from the tableadapter without ever updating to the new name for the GetData. Since that hasn't updated, the rest doesn't surprise me.

View 25 Replies

Databases :: Unable To Initialize Provider. Missing Or Incorrect Schema

May 13, 2010

I'm having trouble setting up my web.config to use MySQL and I keep on getting the above error.

I've got my web.config file as follows and have referenced MySQL.Data.dll and MySQL.Web.dll in my bin folder:

[Code]....

View 4 Replies

Databases :: Unable To Initialize Provider. Missing Or Incorrect Schema?

Jan 25, 2011

I have been trying to get a mysql database to connect to visual studio 2008 so I can use the ASP.net administration tools. I have researched this error for two days now and have tried every suggestion I could find. I am not 100% sure where the .dll's belong but I am pretty sure they are in the correct place and incase not I have added them into a bin folder inside my web application. the only other thing I can think is that maybe my mysql and mysql connector versions dont match. I am currently using mysql version 5.1.54 and my connector version is 6.3.6.0. Also I have successfully conencted to my database in the server explorer and it has already autogenerated the necassary tables into my database. It says my error is on line 59 so here is the code associated with my line 59.

[Code]....

View 1 Replies

Forms Data Controls :: No Mapping Exists From Object Type System.String[] To A Known Managed Provider Native Type?

Dec 1, 2010

I'm trying to pass email addresses from an array to a stored procedure, then display the results in my gridview. I get the following error:No mapping exists from object type System.String[] to a known managed provider native type.On this line: Dim DR As SqlDataReader = MyCommand.ExecuteReader

[Code]....

View 4 Replies

Two Way Sorting In GridView Using Object Data Source?

Feb 2, 2011

I am using Object Data Source to bind data in the gridview. I haveset the property AllowSorting=true. While running the application, Icould sort the data only in ascending order. Is there any way toachieve two way sorting in gridview ie. both ascending and descendingon successive clicks ?.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved