2 Replies - 14207 Views - Last Post: 07 October 2010 - 07:07 AM Rate Topic: -----

#1 hookiethe1   User is offline

  • D.I.C Lover

Reputation: 416
  • View blog
  • Posts: 1,336
  • Joined: 28-September 10

'Microsoft.Jet.OLEDB.12.0' provider is not registered on the l

Posted 07 October 2010 - 05:46 AM

G'day all, I'm trying to write a program to open up and read excel spreadsheets. I am using Visual Studio 2008 on XP Pro 32 bit and Office 2007, I have IIS version 5.1. I have the CPU type set to x86 in the build options, but I keep getting:

'Microsoft.Jet.OLEDB.12.0' provider is not registered on the local machine.

Also it's the same if I try 4.0 instead of 12, and ACE instead of Jet. I've tried all the options Google could come up with, including downloading the Access database engine from MS (I don't have Access in my office suite) but no luck yet. I'd be very appreciative of any suggestions!

Thanks

This post has been edited by hookiethe1: 07 October 2010 - 05:47 AM


Is This A Good Question/Topic? 0
  • +

Replies To: 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the l

#2 hookiethe1   User is offline

  • D.I.C Lover

Reputation: 416
  • View blog
  • Posts: 1,336
  • Joined: 28-September 10

Re: 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the l

Posted 07 October 2010 - 06:59 AM

OK, I figured this one out on my own, I did have to change "Jet" to "ACE," not quite sure why it didn't work the first time, but it's working now.
Was This Post Helpful? 0
  • +
  • -

#3 Curtis Rutland   User is offline

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 5106
  • View blog
  • Posts: 9,283
  • Joined: 08-June 10

Re: 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the l

Posted 07 October 2010 - 07:07 AM

If you downloaded the newest version of the Access engine, you have to use ACE. ACE is the new engine. So, if you tried ACE prior to your download, it wouldn't have worked, but that's why it worked after you downloaded it.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1