Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. man I hate MDAC!

man I hate MDAC!

Scheduled Pinned Locked Moved The Lounge
windows-adminquestionannouncementlearning
19 Posts 7 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • G Giancarlo Aguilera

    I spent the last two days, literally, on the phone trying to get a user's MDAC installed correctly, if there is such a thing, since I've never ran Component Checker on a machine and ended up without any mismatchs whatsoever. This particular user was running W2K SP4; last quarter the software was working, yet once the user updated to the current quarter the software started bombing saying that MDAC 2.6 or above is required, so something must have happened over the course of the quarter. Component Checker, however, said MDAC 2.8 was installed, yet a whole mess of dll files had versions not corresponding to 2.8, particularly the oledb32.dll file, and all bets are off if this file is jacked! To top things off, it seems that the MDAC 2.8 installation does not do anything, yet still says "installation complete", if it detects that MDAC 2.8 is already installed, yet just because your registry or one more files back this assertion up, the system may still have files that are out of sync and, therefore, should be updated. I wish the MDAC install would always do its thing and just make sure not to overwrite newer files instead of not doing anything at all if it "thinks" the version in question is already installed. Man, it's no fun spending hours with a user over the phone having him/her search the registry, run component checker, check file versions, etc... fortunately, this user was a bit more computer savy, unfortunately, however, I'm not always that lucky. Man, just had to blow off some steam!

    C Offline
    C Offline
    Chris Maunder
    wrote on last edited by
    #2

    I had a similar issue with trying to install .NET 1.1. My machine says .NET 1.1 isn't installed (yet it clearly is) so when I try and run the .NET 1.1 installer it says ".NET 1.1 is installed - exiting". At least give us a "Trust me - I know what I'm doing" button. I can't quite understand the rationale for not allowing an install to run twice, especially if the install doesn't offer a "repair install" option. cheers, Chris Maunder

    L 1 Reply Last reply
    0
    • G Giancarlo Aguilera

      I spent the last two days, literally, on the phone trying to get a user's MDAC installed correctly, if there is such a thing, since I've never ran Component Checker on a machine and ended up without any mismatchs whatsoever. This particular user was running W2K SP4; last quarter the software was working, yet once the user updated to the current quarter the software started bombing saying that MDAC 2.6 or above is required, so something must have happened over the course of the quarter. Component Checker, however, said MDAC 2.8 was installed, yet a whole mess of dll files had versions not corresponding to 2.8, particularly the oledb32.dll file, and all bets are off if this file is jacked! To top things off, it seems that the MDAC 2.8 installation does not do anything, yet still says "installation complete", if it detects that MDAC 2.8 is already installed, yet just because your registry or one more files back this assertion up, the system may still have files that are out of sync and, therefore, should be updated. I wish the MDAC install would always do its thing and just make sure not to overwrite newer files instead of not doing anything at all if it "thinks" the version in question is already installed. Man, it's no fun spending hours with a user over the phone having him/her search the registry, run component checker, check file versions, etc... fortunately, this user was a bit more computer savy, unfortunately, however, I'm not always that lucky. Man, just had to blow off some steam!

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #3

      I've had a similar problem with MDAC a few years ago. However, I cannot remember if it was exactly the same problem or not. Luckily, I just remembered details about the post that helped me fix the problem and I found it for you ;) Search for "Repair a corrupted MDAC 2.71 installation - the Solution" in Google Groups. The first post is what you're looking for. I hope it will help!

      1 Reply Last reply
      0
      • C Chris Maunder

        I had a similar issue with trying to install .NET 1.1. My machine says .NET 1.1 isn't installed (yet it clearly is) so when I try and run the .NET 1.1 installer it says ".NET 1.1 is installed - exiting". At least give us a "Trust me - I know what I'm doing" button. I can't quite understand the rationale for not allowing an install to run twice, especially if the install doesn't offer a "repair install" option. cheers, Chris Maunder

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #4

        I'm sure you tried it... but did you try uninstalling the framework and reinstalling it after? ;P

        1 Reply Last reply
        0
        • G Giancarlo Aguilera

          I spent the last two days, literally, on the phone trying to get a user's MDAC installed correctly, if there is such a thing, since I've never ran Component Checker on a machine and ended up without any mismatchs whatsoever. This particular user was running W2K SP4; last quarter the software was working, yet once the user updated to the current quarter the software started bombing saying that MDAC 2.6 or above is required, so something must have happened over the course of the quarter. Component Checker, however, said MDAC 2.8 was installed, yet a whole mess of dll files had versions not corresponding to 2.8, particularly the oledb32.dll file, and all bets are off if this file is jacked! To top things off, it seems that the MDAC 2.8 installation does not do anything, yet still says "installation complete", if it detects that MDAC 2.8 is already installed, yet just because your registry or one more files back this assertion up, the system may still have files that are out of sync and, therefore, should be updated. I wish the MDAC install would always do its thing and just make sure not to overwrite newer files instead of not doing anything at all if it "thinks" the version in question is already installed. Man, it's no fun spending hours with a user over the phone having him/her search the registry, run component checker, check file versions, etc... fortunately, this user was a bit more computer savy, unfortunately, however, I'm not always that lucky. Man, just had to blow off some steam!

          C Offline
          C Offline
          Christian Graus
          wrote on last edited by
          #5

          *grin* Are you using VB6, or does .NET require MDAC as well ? Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

          L G 2 Replies Last reply
          0
          • C Christian Graus

            *grin* Are you using VB6, or does .NET require MDAC as well ? Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #6

            I think .NET needs MDAC for accessing Access databases. But I don't work with Access so I cannot be 100% sure of this.

            G 2 Replies Last reply
            0
            • C Christian Graus

              *grin* Are you using VB6, or does .NET require MDAC as well ? Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

              G Offline
              G Offline
              Giancarlo Aguilera
              wrote on last edited by
              #7

              VB6? You're messing with me, right? I hope to never ever write another line of VB6 code again :laugh:! Actually, ADO.NET requires MDAC 2.6 or above Nice hearing from you again dude :-D! C#, man, what a piece of crap ;P! I'm just kidding dude; I just like pulling your buttons :laugh:. Talk to ya soon

              C 1 Reply Last reply
              0
              • G Giancarlo Aguilera

                VB6? You're messing with me, right? I hope to never ever write another line of VB6 code again :laugh:! Actually, ADO.NET requires MDAC 2.6 or above Nice hearing from you again dude :-D! C#, man, what a piece of crap ;P! I'm just kidding dude; I just like pulling your buttons :laugh:. Talk to ya soon

                C Offline
                C Offline
                Christian Graus
                wrote on last edited by
                #8

                Giancarlo Aguilera wrote: Actually, ADO.NET requires MDAC 2.6 or above Oh, OK. Even for SQL Server ? That plain sucks. I've not had trouble with it yet, but I have distributed an app that used MSDE database recently. I didn't think I distributed MDAC. Giancarlo Aguilera wrote: C#, man, what a piece of crap I agree - C++ is the way to go. I'm knee deep in C++ image processing code, and loving it.... Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

                G 2 Replies Last reply
                0
                • L Lost User

                  I think .NET needs MDAC for accessing Access databases. But I don't work with Access so I cannot be 100% sure of this.

                  G Offline
                  G Offline
                  Giancarlo Aguilera
                  wrote on last edited by
                  #9

                  Certainly for the oledb provider MDAC is required, but now I am curious whether it's required when accessing SQL through the native sql provider, I'm not sure.

                  B 1 Reply Last reply
                  0
                  • C Christian Graus

                    Giancarlo Aguilera wrote: Actually, ADO.NET requires MDAC 2.6 or above Oh, OK. Even for SQL Server ? That plain sucks. I've not had trouble with it yet, but I have distributed an app that used MSDE database recently. I didn't think I distributed MDAC. Giancarlo Aguilera wrote: C#, man, what a piece of crap I agree - C++ is the way to go. I'm knee deep in C++ image processing code, and loving it.... Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

                    G Offline
                    G Offline
                    Giancarlo Aguilera
                    wrote on last edited by
                    #10

                    Yes, even for SQL, although I just now cleared that doubt up http://support.microsoft.com/default.aspx?scid=kb;en-us;315467[^]

                    1 Reply Last reply
                    0
                    • L Lost User

                      I think .NET needs MDAC for accessing Access databases. But I don't work with Access so I cannot be 100% sure of this.

                      G Offline
                      G Offline
                      Giancarlo Aguilera
                      wrote on last edited by
                      #11

                      SQL too, I just cleared that doubt up http://support.microsoft.com/default.aspx?scid=kb;en-us;315467[^]

                      1 Reply Last reply
                      0
                      • G Giancarlo Aguilera

                        I spent the last two days, literally, on the phone trying to get a user's MDAC installed correctly, if there is such a thing, since I've never ran Component Checker on a machine and ended up without any mismatchs whatsoever. This particular user was running W2K SP4; last quarter the software was working, yet once the user updated to the current quarter the software started bombing saying that MDAC 2.6 or above is required, so something must have happened over the course of the quarter. Component Checker, however, said MDAC 2.8 was installed, yet a whole mess of dll files had versions not corresponding to 2.8, particularly the oledb32.dll file, and all bets are off if this file is jacked! To top things off, it seems that the MDAC 2.8 installation does not do anything, yet still says "installation complete", if it detects that MDAC 2.8 is already installed, yet just because your registry or one more files back this assertion up, the system may still have files that are out of sync and, therefore, should be updated. I wish the MDAC install would always do its thing and just make sure not to overwrite newer files instead of not doing anything at all if it "thinks" the version in question is already installed. Man, it's no fun spending hours with a user over the phone having him/her search the registry, run component checker, check file versions, etc... fortunately, this user was a bit more computer savy, unfortunately, however, I'm not always that lucky. Man, just had to blow off some steam!

                        J Offline
                        J Offline
                        Jeremy Falcon
                        wrote on last edited by
                        #12

                        MDAC was never meant to be uninstalled. Also, MDAC 2.8 is not a complete install because MS dropped many of the core Jet componments for 2.8. Use 2.7 for Access, and never uninstall it after it's been put on the system. Jeremy Falcon

                        1 Reply Last reply
                        0
                        • C Christian Graus

                          Giancarlo Aguilera wrote: Actually, ADO.NET requires MDAC 2.6 or above Oh, OK. Even for SQL Server ? That plain sucks. I've not had trouble with it yet, but I have distributed an app that used MSDE database recently. I didn't think I distributed MDAC. Giancarlo Aguilera wrote: C#, man, what a piece of crap I agree - C++ is the way to go. I'm knee deep in C++ image processing code, and loving it.... Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

                          G Offline
                          G Offline
                          Giancarlo Aguilera
                          wrote on last edited by
                          #13

                          So I assume you ended getting that C++ job you were talking about? Good for you. Which compiler out of curiosity (ms, borland)?

                          C 1 Reply Last reply
                          0
                          • G Giancarlo Aguilera

                            So I assume you ended getting that C++ job you were talking about? Good for you. Which compiler out of curiosity (ms, borland)?

                            C Offline
                            C Offline
                            Christian Graus
                            wrote on last edited by
                            #14

                            No, this is just a little outside job, about a months work or so in my spare time. So, VS.NET 2003 :-) Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

                            1 Reply Last reply
                            0
                            • G Giancarlo Aguilera

                              I spent the last two days, literally, on the phone trying to get a user's MDAC installed correctly, if there is such a thing, since I've never ran Component Checker on a machine and ended up without any mismatchs whatsoever. This particular user was running W2K SP4; last quarter the software was working, yet once the user updated to the current quarter the software started bombing saying that MDAC 2.6 or above is required, so something must have happened over the course of the quarter. Component Checker, however, said MDAC 2.8 was installed, yet a whole mess of dll files had versions not corresponding to 2.8, particularly the oledb32.dll file, and all bets are off if this file is jacked! To top things off, it seems that the MDAC 2.8 installation does not do anything, yet still says "installation complete", if it detects that MDAC 2.8 is already installed, yet just because your registry or one more files back this assertion up, the system may still have files that are out of sync and, therefore, should be updated. I wish the MDAC install would always do its thing and just make sure not to overwrite newer files instead of not doing anything at all if it "thinks" the version in question is already installed. Man, it's no fun spending hours with a user over the phone having him/her search the registry, run component checker, check file versions, etc... fortunately, this user was a bit more computer savy, unfortunately, however, I'm not always that lucky. Man, just had to blow off some steam!

                              J Offline
                              J Offline
                              Jason Henderson
                              wrote on last edited by
                              #15

                              I hate MDAC as well. Usually installing 2.8 fixes any problems I have seen, other times you have to take more drastic measures. I have some repair steps that I got off of a website that work for those drastic cases. Email me if you would like me to send it to you.

                              "Live long and prosper." - Spock

                              Jason Henderson
                              blog

                              1 Reply Last reply
                              0
                              • G Giancarlo Aguilera

                                I spent the last two days, literally, on the phone trying to get a user's MDAC installed correctly, if there is such a thing, since I've never ran Component Checker on a machine and ended up without any mismatchs whatsoever. This particular user was running W2K SP4; last quarter the software was working, yet once the user updated to the current quarter the software started bombing saying that MDAC 2.6 or above is required, so something must have happened over the course of the quarter. Component Checker, however, said MDAC 2.8 was installed, yet a whole mess of dll files had versions not corresponding to 2.8, particularly the oledb32.dll file, and all bets are off if this file is jacked! To top things off, it seems that the MDAC 2.8 installation does not do anything, yet still says "installation complete", if it detects that MDAC 2.8 is already installed, yet just because your registry or one more files back this assertion up, the system may still have files that are out of sync and, therefore, should be updated. I wish the MDAC install would always do its thing and just make sure not to overwrite newer files instead of not doing anything at all if it "thinks" the version in question is already installed. Man, it's no fun spending hours with a user over the phone having him/her search the registry, run component checker, check file versions, etc... fortunately, this user was a bit more computer savy, unfortunately, however, I'm not always that lucky. Man, just had to blow off some steam!

                                B Offline
                                B Offline
                                Blake Miller
                                wrote on last edited by
                                #16

                                So..... How about a REAL component checker, then? Are you going to write one for us?

                                G 1 Reply Last reply
                                0
                                • G Giancarlo Aguilera

                                  Certainly for the oledb provider MDAC is required, but now I am curious whether it's required when accessing SQL through the native sql provider, I'm not sure.

                                  B Offline
                                  B Offline
                                  Blake Miller
                                  wrote on last edited by
                                  #17

                                  I think the MSDE requires MDAC as well. It has been a few months, so I might have had false memories implanted in the meantime :doh:

                                  G 1 Reply Last reply
                                  0
                                  • B Blake Miller

                                    I think the MSDE requires MDAC as well. It has been a few months, so I might have had false memories implanted in the meantime :doh:

                                    G Offline
                                    G Offline
                                    Giancarlo Aguilera
                                    wrote on last edited by
                                    #18

                                    yes, msde does require mdac

                                    1 Reply Last reply
                                    0
                                    • B Blake Miller

                                      So..... How about a REAL component checker, then? Are you going to write one for us?

                                      G Offline
                                      G Offline
                                      Giancarlo Aguilera
                                      wrote on last edited by
                                      #19

                                      I highly doubt it :-D. MDAC is a monster I would rather stay away from. Here's another tool though http://www.macropool.com/en/download/repair_mdac.html[^]

                                      1 Reply Last reply
                                      0
                                      Reply
                                      • Reply as topic
                                      Log in to reply
                                      • Oldest to Newest
                                      • Newest to Oldest
                                      • Most Votes


                                      • Login

                                      • Don't have an account? Register

                                      • Login or register to search.
                                      • First post
                                        Last post
                                      0
                                      • Categories
                                      • Recent
                                      • Tags
                                      • Popular
                                      • World
                                      • Users
                                      • Groups