getting The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine on my windows7 64-bit OS, when i'm running my VB.net project. I tried this link, but no luck.!!
Please help me. !!
.net – The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine in VB.net project
netoledbvb.net
Related Topic
- C# – The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine
- C# – Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
- C# – How to remedy “The breakpoint will not currently be hit. No symbols have been loaded for this document.” warning
- .net – ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
- .net – The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine
- C# – Error – Unable to access the IIS metabase
Best Answer
You are trying to use a component that became obsolete ten years ago. There is no 64-bit version of the provider and there never will be, you'll need to force your application into running in 32-bit mode.
Right-click your EXE project, Properties, Compile tab, scroll down, Advanced Compile Options property. Change the Target CPU setting to "x86".
Forward looking solutions are the ACE provider, the replacement for JET. However currently not available in 64-bit either. SQL Server is the mainstream Microsoft solution, the Express and Compact editions are free. Plenty of 3rd party solutions like SqlLite or MySql. Whether any of them are applicable is unclear from the question, you didn't explain why you need to use such an old provider.