You need to allow 32-bit application to run on 64-bit machine.
For that setting
You can either do
1. Open command prompt and navigate to the %systemdrive%\Inetpub\AdminScripts
2. cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true
Thatshould do it hopefully.
OR you can go the IIS Manager and for the application pool (the one your application is running under) go to advanced settings and there should be the option to Enable 32-bit Apps on x64 machines.
Thanks for the info but my quesiton is why is the 64 bit version not correct? If the 64 bit version is not appropiate for 64 bit Windows 2008 R2 then when is the 64 bit version appropriate?
If OLEDB is 32-bit I still think my question is valid and you that is not an answer. Microsoft has a 64 bit install named
AccessDatabaseEngine_x64.exe. If that tool will not work on Windows 2008 R2 bit then where does it work? The instuctions refer to OLEDB - if OLEDB is only 32 bit then what is
that tool?
Based on the name and instuctions there is a 64 bit version and it support OLEDB
Please point me to the ADO.NET if that is what I should be using.
Users upload data in Excel to an ASP.NET Web Application that I recently migrated from Windows 2003 32 bit to Windows 2008 R2
But I still contend I have a valid question.
If AccessDatabaseEngine_x64.exe is not vailid on Windows 2008 R2 then where is it valid?
Rahul.B
Member
142 Points
39 Posts
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web ser...
Jan 24, 2011 03:06 PM|LINK
Hello All,
I get the error 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.', when i am trying to read an excel file.
I have already installed 2007 Office System Driver: Data Connectivity Components available on http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
I can see the entry of the installed driver on the registry.
The web server is a Windows 2003 R2 Enterprise x64 R2 machine.
After installing the driver the machine has been restarted.
Same build works on a similar machine (Similar Hardware/OS). Hence ruled out rebuilding the code in 64 bit settings.
Thanks in advance.
Rahul B
shehzad.chhi...
Member
140 Points
30 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Jan 24, 2011 05:04 PM|LINK
You need to allow 32-bit application to run on 64-bit machine.
For that setting
You can either do
1. Open command prompt and navigate to the %systemdrive%\Inetpub\AdminScripts
2. cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true
That should do it hopefully.
OR you can go the IIS Manager and for the application pool (the one your application is running under) go to advanced settings and there should be the option to Enable 32-bit Apps on x64 machines.
Shehzad Chhipa
Rahul.B
Member
142 Points
39 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Jan 25, 2011 04:31 PM|LINK
My problem was solved by installing a correct version of the oledb driver.
you would need the 32bit version called "AccessDatabaseEngine.exe" NOT the 64bit edition which is "AccessDatabaseEngine_x64.exe".
Monte Balam
Member
10 Points
5 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Apr 08, 2011 07:13 PM|LINK
Thanks for the info but my quesiton is why is the 64 bit version not correct? If the 64 bit version is not appropiate for 64 bit Windows 2008 R2 then when is the 64 bit version appropriate?
Lannie
Contributor
3724 Points
726 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Apr 08, 2011 10:27 PM|LINK
OLEDB is 32-bit
Monte Balam
Member
10 Points
5 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Apr 08, 2011 11:13 PM|LINK
If OLEDB is 32-bit I still think my question is valid and you that is not an answer. Microsoft has a 64 bit install named AccessDatabaseEngine_x64.exe. If that tool will not work on Windows 2008 R2 bit then where does it work? The instuctions refer to OLEDB - if OLEDB is only 32 bit then what is that tool?
Lannie
Contributor
3724 Points
726 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Apr 08, 2011 11:28 PM|LINK
OLEDB is an old connection driver that can communicate with MS Office (Access, Excel), and other databases.
I believe you will find it listed as 32-bit only on MS Tech Net website.
For 64-bit, MS Office uses ADO.NET.
Monte Balam
Member
10 Points
5 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Apr 08, 2011 11:38 PM|LINK
Thanks
If I should be looking to a different product then please point me there
A 64 bit applicaiton is on www.microsoft.com/download/ with a date fo 12/16/2010
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en
Based on the name and instuctions there is a 64 bit version and it support OLEDB
Please point me to the ADO.NET if that is what I should be using.
Users upload data in Excel to an ASP.NET Web Application that I recently migrated from Windows 2003 32 bit to Windows 2008 R2
But I still contend I have a valid question.
If AccessDatabaseEngine_x64.exe is not vailid on Windows 2008 R2 then where is it valid?
Lannie
Contributor
3724 Points
726 Posts
Re: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. on 64 bit web...
Apr 09, 2011 07:09 PM|LINK
http://www.amazon.com/Pro-ADO-NET-Data-Services-Working/dp/143021614X/ref=sr_1_11?ie=UTF8&qid=1302375941&sr=8-11
Do not confuse the database engine with the various database connection protocols (ODBC, OLEDB, ADO.NET, and many others)
I have read the limitation of OLEDB is that it is limited to 32-bit.
I always found OLEDB too limiting and ADO.NET providing more functionality, so never wasted my time usng OLEDB.