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
Looks like you have not refered the link I provided:
This
link may be the all in one referance I think. ( http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/4fbd905f-f877-4bd9-b44c-97a61acd2b3f/#181ac1cb-134b-406a-be79-cfd089ce1461
)
If you are experiencing : " <strong >The 'Microsoft.Jet.Oldedb.4.0' provider is not registered on the local machine." kind of error due your 64 bit machine, HERE IS THE SOLUTION ... !
please convert your Target Framework from "Any CPU" to "x86" in project properties and make sure the same by right clicking solution and going to "Configuration Manager"
OR
Installing 2007 / 2010 Office System Driver: Data Connectivity Components (2007 /
2010 )
With the 2nd alternative you may want to change the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”. (I had to do this)
Resulting the Connection String to look like below:
aarsh
Participant
1547 Points
435 Posts
Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Dec 18, 2012 01:30 PM|LINK
Looks like you have not refered the link I provided:
This link may be the all in one referance I think. ( http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/4fbd905f-f877-4bd9-b44c-97a61acd2b3f/#181ac1cb-134b-406a-be79-cfd089ce1461 )
If you are experiencing : " <strong >The 'Microsoft.Jet.Oldedb.4.0' provider is not registered on the local machine." kind of error due your 64 bit machine, HERE IS THE SOLUTION ... !
With the 2nd alternative you may want to change the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”. (I had to do this)
Resulting the Connection String to look like below: