Recent Posts

Sunday, June 20, 2010

The 'ASEOLEDB' provider is not registered on the local machine ( windows 64 bit )

I was facing below error in my ASP.net website hosted in IIS 7, windows 2008 (64 bit) . I spent nearly 2 days searching for the solution but could not find the right one that could save my hours of work.
System.InvalidOperationException: The 'ASEOLEDB' 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)

So for you guys who are facing same issues just save your time checking below solution. Hope it works for you

In IIS go to your website and find out the application pool that it is using and go to Application pools and right click on the same and click on Advanced settings

Then Select Enable 32-Bit Applications to True
That's it it should work for you no matter what you are using for database either access, Sql server, Oracle or sybase it is the quickest fix.



Related Posts by Categories




No comments:

Post a Comment