OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
***At the Fill command I'm getting this message:
Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
I'm using Visual Studio 2005. This is an ASP.NET app. The operating system is XP Professional, Service Pack 2. MDAC 2.8 is installed. I've adjusted the compiler settings to x86.
In the IIS(7), search for the application pool that supports your Web Application rigth click on it and select the option "Set Application Pool Defaults"...then find the Option Generals->Enable 32-bit Applications set it to true.
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
***At the Fill command I'm getting this message:
Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
I'm using Visual Studio 2005. This is an ASP.NET app. The operating system is XP Professional, Service Pack 2. MDAC 2.8 is installed. I've adjusted the compiler settings to x86.
What else should I do?
Thanks in advance!
Terry
Following worked fine for me:
The solution is to configure the application pool and enable 32-bit application support. For IIS 7, running on Windows Vista, you can do this from the application pool's advanced settings.
Hi. My application is windows application. i am changing to target paltform to x86. when it run windows vista(64 Bit). the application has same error(The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.). what can i do resolve this
issue?
Have you tried opening Excel from the start menu rather than double clicking on the file?
And the Open Office version is available as a seperate download, you don't need to get the whole suite. Its a lot smaller than 93 mb! I'm on dial up as well and thats what I use.
brotherterry
Member
7 Points
2 Posts
Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Jul 14, 2006 03:52 PM|LINK
Hi All,
I'm trying to open an Excel file. Here is the code:
string connectionString = @"Provider=Microsoft.Jet. OleDb.4.0;Data Source=UploadSalesDataXLS.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
***At the Fill command I'm getting this message:
Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
I'm using Visual Studio 2005. This is an ASP.NET app. The operating system is XP Professional, Service Pack 2. MDAC 2.8 is installed. I've adjusted the compiler settings to x86.
What else should I do?
Thanks in advance!
Terry
Althaf Hussa...
Member
2 Points
1 Post
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Jul 02, 2007 07:37 AM|LINK
Hi.. For me also the same problem.. if you get any solution please send me
thanks
Althaf
naturehermit
Star
14610 Points
3046 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Jul 02, 2007 11:38 AM|LINK
There are few thing you guys need to do, get the latest oleDB provider from here
http://support.microsoft.com/default.aspx/kb/239114 Use regsvr32 to register them. How to use that is here with an example http://support.microsoft.com/kb/278604.
How to keep a Jet 4.0 database in top working condition:
http://support.microsoft.com/kb/303528
Hope that will help both of you. Good luck
shalin_3127
Member
4 Points
6 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Feb 28, 2008 06:34 PM|LINK
Even i m gettig the same error.. ne solutions???? plz lemme knw if u knw whts the solution for this error??
Ahmedabad,India
srameh
Member
117 Points
80 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Apr 24, 2009 08:29 PM|LINK
In the IIS(7), search for the application pool that supports your Web Application rigth click on it and select the option "Set Application Pool Defaults"...then find the Option Generals->Enable 32-bit Applications set it to true.
And that's it! Microsoft Jet is working again.
-----------------------
teslatrooper
Member
10 Points
62 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Jun 24, 2009 08:55 AM|LINK
Following worked fine for me:
The solution is to configure the application pool and enable 32-bit application support. For IIS 7, running on Windows Vista, you can do this from the application pool's advanced settings.
prabakarank1...
Member
6 Points
4 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Dec 17, 2009 04:25 AM|LINK
Hi. My application is windows application. i am changing to target paltform to x86. when it run windows vista(64 Bit). the application has same error(The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.). what can i do resolve this issue?
barringtonn
Member
2 Points
1 Post
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Dec 17, 2009 11:44 AM|LINK
Have you tried opening Excel from the start menu rather than double clicking on the file?
And the Open Office version is available as a seperate download, you don't need to get the whole suite. Its a lot smaller than 93 mb! I'm on dial up as well and thats what I use.
EverBright Smiles
EverBright Smiles
prabakarank1...
Member
6 Points
4 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Dec 23, 2009 04:59 AM|LINK
Hi ..i can open the MSAccess database through command prompt. my MsJet40 file version is 4.0.9756.My system is windows 7.
what can i do resolve this issue?
rathinakumar...
Member
4 Points
2 Posts
Re: Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine
Mar 04, 2010 04:55 PM|LINK
Hi
Changing the 32-bit mode is a good solution........... Good IDEA GREATTTTTT
Thanks
B. Rathina kumar
Works Really Thanks