you're reading...
ASP.NET, IT-Center, Operating System, Web Based

ASP.NET IIS 7 Error : Microsoft.Jet.OleDb.4.0 provider is not registered on the local machine

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
1.Open your IIS : type “inetmgr” in start menu > Run >
2. 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.

See Also : 
http://support.microsoft.com/default.aspx/kb/239114 Use regsvr32 to register them. How to use that is here with an examplehttp://support.microsoft.com/kb/278604.
How to keep a Jet 4.0 database in top working condition: http://support.microsoft.com/kb/303528

About berbagisolusi

Berbagi merupakan sebuah bentuk simbol keikhlasan untuk membantu dan menolong, sedangkan solusi adalah cara menyelesaikan masalah. Setiap manusia pasti mengalami masalah, tetapi kita tidak perlu mengalami masalah yang sama jika orang lain pernah mengalami dan kita tahu hal tersebut.


No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 9 other followers

December 2011
« Nov   Jan »


Web Statistic

Blog Stats

  • 149,580 hits
%d bloggers like this: