Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine - ASP.NET Discussion Boards

If you expect any sort of decent answer you need to provide more details. Simply using the subject line to ask the question isn't enough here.

No comment

hi friends
i am using visual web developer 2010 express
i have a master page and a many content pages. i set one of the page(welcome.aspx)as start up page by right clicking on it and choosing the set as start up page.
but after i run the application for some times it says that it is not connected to local host welcome.aspx so again if it set is as start up page by doing the above process it works.
so how to fix it...i cannot always go and click it and set it as set as start up page...

K.Gayathri

Go to WebProject property->Web-> Configure there your specific page OR Start URL

Parwej Ahamad

hi
thanks for the reply
i went into the path what you said and i found out that the specific page was already given correctly but also still i am having the problem.....
sometimes it comes correctly sometimes it doesn't...

K.Gayathri

Are you using internal Visual Studio IIS?

Parwej Ahamad

yes

K.Gayathri

Go to Project Property -> Web -> Start URL:

http://localhost:xxxx/default.aspx

Note: xxxx is port no. When you run the application you will see port no that IIS used.

Thanks

Parwej Ahamad

Hi,

Below error is displayed when i read excel file using oledb4.0. The code is working well for other applications on same server.

System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at UploadExcelFile.SaveXlsFileCols(Int32 int_FileId, String str_filePath, String str_extension, String str_fileName)

Though same code is running for other application on same server.

protected void SaveXlsFileCols(int int_FileId, string str_filePath, string str_extension, string str_fileName)
{
string connString = string.Empty;
if (str_extension == "xls")
{
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str_filePath + ";Extended Properties=\"Excel 8.0;\"";
}
else
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + str_filePath + ";Extended Properties=\"Excel 12.0;\"";
}
// Create the connection object
using (OleDbConnection oledbConn = new OleDbConnection(connString))
{
try
{
if (oledbConn.State == ConnectionState.Open)
{
oledbConn.Close();
}
// Open connection
oledbConn.Open();

DataTable dbSchema = oledbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();

// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM ["+WorkSheetName+"]", oledbConn);

do you have Microsoft Access installed on the host on which the application is running?

Help people,so poeple can help you.

Hi,

Im using datepicker using standalone jquery. The datepicker works perfectly in WebForm. Now i decided to use a site master on my sample project and I add some web content form also inside the site.master.

In my web content form i add search function with date range.

Now, the problem was, after using web content form, datepicker no longer showing the icon "..." beside my asp:textbox.

Please see below tags in my site.Master page.

XML

<asp:ScriptManager ID="ScriptManager1" runat="server">
    <Scripts>
        <asp:ScriptReference Path="~/scripts/datepickerjs/jquery-1.3.1.min.js" />
        <asp:ScriptReference Path="~/scripts/datepickerjs/jquery-ui-1.7.1.custom.min.js" />
        <asp:ScriptReference Path="~/scripts/datepickerjs/daterangepicker.jQuery.js" />
    </Scripts>
</asp:ScriptManager>

i also place the css in site.master inside the head tag.

XML

<link rel="Stylesheet" type="text/css" href="style/datepickercss/ui.daterangepicker.css" />
<link rel="Stylesheet" type="text/css" href="style/datepickercss/redmond/jquery-ui-1.7.1.custom.css" title="ui-theme" />

In my web content form i place the script after the asp:Content tag.

<script type="text/jscript">
    $(function() {
        $("#txtDateFrom").datepicker({
            changeMonth: true,
            changeYear: true,
            buttonText: 'Select Date From',
            buttonImage: 'images/calendar.gif',
            buttonImageOnly: true,
            showOn: 'button'
        });
    });

    $(function() {
        $("#txtDateTo").datepicker({
            changeMonth: true,
            changeYear: true,
            buttonText: 'Select Date To',
            buttonImage: 'images/calendar.gif',
            buttonImageOnly: true,
            showOn: 'button'
        });
    });
</script>

Finally, when i run my project the "..." is not showing. Normally, when i used web form this "..." will show and i can select a date, but now after switching to web content form, "..." is no longer visible.

Thanks

if(you type your code here) {
Messagebox.Show("You help me a lot!");
}
else {
You help me = null;
}

klaydze wrote:
$("#txtDateFrom").datepicker({

Using a MasterPage will change the id. You may want to try

$("[id$='txtDateFrom']").

to get the id that ends in txtDateFrom

[Edit for correct punctuation]

Hi bVagadishnu,

You help me alot. Works perfectly!!!

Thanks

if(you type your code here) {
Messagebox.Show("You help me a lot!");
}
else {
You help me = null;
}

Hi,

I have a query which returns more than 5 Lakhs record which has to export to Excel(.xls). How to split the recors into 65000 each and export to a single excel file with multiple number of sheets.

The database which i am using is oracle. Can any one help me with this either via query in oracle or through coding.

Thanks,
N Padmanabhan.

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

check this Export DataSet to Multiple Excel Sheets[^]

Help people,so poeple can help you.

Thanks for your help. That article is developed using 2008. But i need it in 2005.

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

ok, Sir;

try the following:
1. Start a new web project/site.
2. copy the code and paste it and into new files.
3. build the project/site.
4. run the project/site.

Good Luck

Help people,so poeple can help you.

When i click on link button,an error occurs

CSS

The state information is invalid for this page and might be corrupted.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The state information is invalid for this page and might be corrupted.

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MainMaster.master.cs" Inherits="MainMaster" EnableViewState="false"  %>

How to solve this error?

The very first thing I do when I have exact error message is search Google. It has been discussed at so many places and there are possible causes and solutions given at most of them. Here you go - The state information is invalid for this page and might be corrupted[^] Thumbs Up | :thumbsup:

..Go Green..

I have search google,but I do'nt understand where is the problem.This error occures only whent i clicked link button.

Guys, i got stuck with the some functionality, which i really needed for a tool.. Can we create a ascx file at runtime??.

My tool uses ascx file, to display a widget.. Now i want to create widgets at runtime, so i need to create ascx file runtime. Is this Possible any answers?? Please help me to move forward.

Thanks in advance..!

So, you need an XML parser

Help people,so poeple can help you.

hi i am using visual web developer 2010 express

i am new to it

1)is there any control which looks like a label but acts like a button if so i need to know it(labelbutton if any),where is it

2)i am having a button in master page on the click of which should go to an aspx page so how to call it can anyone help me with it.

K.Gayathri

Perhaps you need to learn a little of ASP.NET here:
- http://asp.net-tutorials.com/[^]

MalarGayu wrote:
1)

ASP.NET

<asp:LinkButton ID="LinkButton1" runat="server">LinkButton</asp:LinkButton>

MalarGayu wrote:
2)

Set the onclick event of the button and access the onclick from code behind:

-Design View

ASP.NET

<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />

- Codebehind

C#

protected void Button1_Click( object sender, EventArgs e )
{
    //Do everything you want when a user clicks the button below this line.
}

You can use Link Button,and to provide look like Linkbutton set properties as

C#

<asp:LinkButton ID="LinkButton11" runat="server" Font-Underline="False" 
            CausesValidation="False" onclick="LinkButton2_Click"><font color="white" size="1">DEPARTMENTS</font></asp:LinkButton>

Hi,
I want to disable the checkbox if the gridview cell 4 has KS value.

Getting object reference not set in gv=Gridview1.SelectedRow

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    GridViewRow gv ;
    gv =GridView1.SelectedRow;
    if (gv.Cells[4].Text == "KS")
    {
        if (gv.RowType == DataControlRowType.DataRow)
        {
            CheckBox chkDelete = (CheckBox)gv.Cells[0].Controls[0];
            chkDelete.Enabled = false;
        }
    }

}

Need help

Thanks
S.Guhananth