Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    jet provider not registered (2003)

    Edited by HansV to provide link to MSKB article using <!t>[mskb=239114]<!/t>

    I am getting the message 'The 'Microsoft.Jet.4.0' provider is not registered on the local machine' when I try to open a connection object, which points at an Access database, on my local machine. I am trying to connect using asp.net, but I seem to remember having similar problems when I tried to connect using classic asp. I have followed the instructions in <!mskb=239114>Microsoft Knowledge Base Article 239114<!/mskb>, How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine, but when I downloaded the install file, and ran it, it said that my system was already up to date.

    Ian

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: jet provider not registered (2003)

    It sounds like the Jet provider may not be properly registered. Does this article give you any ideas?
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: jet provider not registered (2003)

    Thanks Charlotte, that site did give me some ideas, but it didn't solve the problem. In the end it turned out that I had used the text
    Provider=Microsoft.Jet.4.0;
    in my connection string, instead of
    Provider=Microsoft.Jet.OleDb.4.0;
    the difference being a missing 'OleDb' between 'Jet' and '4'.
    Why do they have to be so obscure?
    Thanks again.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: jet provider not registered (2003)

    Yes, that would certainly do it. There is no such thing as the Microsoft.Jet.4.0 provider. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Computers are stupid machines and they try to do exactly what you tell them to, whether it works or not! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •