I want to upload the data from Excel to SQL Server 2008 & 2012 also.
in that i wrote some lines of code but when i try to open a oledb connection , it showing some error message</div> <div style="margin-top: 25px;">
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
But my PC configuration is 64 bit format and where i can set that bit formation.
Yup, we had similar problem in the past with 64bits environment and that driver.
You can try enabling it and if it doesn't work you can revert it back, here is how to enable it:
https://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx
Please "Mark as Answer" if this post answers your question.
pranathis
Member
28 Points
136 Posts
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 15, 2012 08:03 AM|LINK
I want to upload the data from Excel to SQL Server 2008 & 2012 also.
in that i wrote some lines of code but when i try to open a oledb connection , it showing some error message</div> <div style="margin-top: 25px;">
can anyone help me to resolve this issue..</div>
oned_gk
All-Star
31820 Points
6510 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 15, 2012 08:08 AM|LINK
http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/1d5c04c7-157f-4955-a14b-41d912d50a64
pranathis
Member
28 Points
136 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 15, 2012 08:55 AM|LINK
In my PC i installed this S/W and try to debug my page again it's showing the same error . How can i resolve this
aarsh
Participant
1543 Points
428 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 15, 2012 09:26 AM|LINK
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/4fbd905f-f877-4bd9-b44c-97a61acd2b3f/#181ac1cb-134b-406a-be79-cfd089ce1461
pranathis
Member
28 Points
136 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 17, 2012 08:03 AM|LINK
Hi,
When I run on my local pc, local server it works. When I push it to my webhost and goto the website then only i face this problem.
ferrymeidian...
Member
500 Points
126 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 17, 2012 08:10 AM|LINK
Set Enable 32-Bit Applications in the AppPool to True
Regards,
Ferry Meidianto
www.meidianto.com
pranathis
Member
28 Points
136 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 17, 2012 08:21 AM|LINK
But my PC configuration is 64 bit format and where i can set that bit formation.
ferrymeidian...
Member
500 Points
126 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 17, 2012 09:23 AM|LINK
Yup, we had similar problem in the past with 64bits environment and that driver.
You can try enabling it and if it doesn't work you can revert it back, here is how to enable it:
https://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx
Regards,
Ferry Meidianto
www.meidianto.com
pranathis
Member
28 Points
136 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 17, 2012 11:07 AM|LINK
PC configuration 64 -bit formate and MS- Office formate is 32 - bit formate. And i install AccessDataBaseEnginee also 32 bit formate .
Is it ok or any issue in that also
ferrymeidian...
Member
500 Points
126 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 17, 2012 10:41 PM|LINK
Have you tried enabling 32-bits application in IIS AppPool I suggested? That's the case when you need to set that configuration to True.
Regards,
Ferry Meidianto
www.meidianto.com