Author Topic: Mdac Hell  (Read 24552 times)

0 Members and 1 Guest are viewing this topic.

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Mdac Hell
« on: December 10, 2011, 06:21:19 PM »
Programs running mdac don't run in my windows 7

& naturally i can't install 2.8 here cause mdac is part of the os.

One program says i can't run it because my system needs mdac 2.8 sp1 or later

& the other one:

"the exception unknown software exception (0x0eedfade) occurred
in the application at location 0x75d09673."

&

Exception at 00185F3B. Error creating object.

i managed to install mdac 2.1 successfully through the setup without installing an invasive 400 mb nonsense office access package, since one program pretends i need 2.1 or later.

i also managed to install 2.8 through extraction & inf installation .. .

an mdac checker detected that i have mdac in win7.

But i still cannot open apps requiring mdac to run .. .

I have tried the windows file checker unsuccessfully

& asked a programer what dll loads the program's interface & he told me
it was msado15.dll

i basically have all those files:

- [C:\program files\common files\System]

  - [C:\program files\common files\System\ado]
  - [C:\program files\common files\System\ado\en-US]

    C:\program files\common files\System\ado\en-US\msader15.dll.mui
    C:\program files\common files\System\ado\adoapt15.reg
    C:\program files\common files\System\ado\adofre15.reg
    C:\program files\common files\System\ado\adojavas.inc
    C:\program files\common files\System\ado\ADOMDreadme.txt
    C:\program files\common files\System\ado\ADOreadme.txt
    C:\program files\common files\System\ado\adovbs.inc
    C:\program files\common files\System\ado\adoxreadme.txt
    C:\program files\common files\System\ado\JroReadme.txt
    C:\program files\common files\System\ado\makapt15.bat
    C:\program files\common files\System\ado\makfre15.bat
    C:\program files\common files\System\ado\MDACReadme.htm
    C:\program files\common files\System\ado\msader15.dll
    C:\program files\common files\System\ado\msado15.dll       V6.1.7600.20818
    C:\program files\common files\System\ado\msado20.tlb
    C:\program files\common files\System\ado\msado21.tlb
    C:\program files\common files\System\ado\msado25.tlb
    C:\program files\common files\System\ado\msado26.tlb
    C:\program files\common files\System\ado\msado27.tlb
    C:\program files\common files\System\ado\msado28.tlb
    C:\program files\common files\System\ado\msadomd.dll
    C:\program files\common files\System\ado\msadomd28.tlb
    C:\program files\common files\System\ado\msador15.dll
    C:\program files\common files\System\ado\msadox.dll
    C:\program files\common files\System\ado\msadox28.tlb
    C:\program files\common files\System\ado\msadrh15.dll
    C:\program files\common files\System\ado\msjro.dll

    - [C:\program files\common files\System\msadc]
    - [C:\program files\common files\System\msadc\en-US]

      C:\program files\common files\System\msadc\en-US\msadcer.dll.mui
      C:\program files\common files\System\msadc\en-US\msadcfr.dll.mui
      C:\program files\common files\System\msadc\en-US\msadcor.dll.mui
      C:\program files\common files\System\msadc\en-US\msaddsr.dll.mui
      C:\program files\common files\System\msadc\en-US\msdaprsr.dll.mui
      C:\program files\common files\System\msadc\en-US\msdaremr.dll.mui
    C:\program files\common files\System\msadc\adcjavas.inc
    C:\program files\common files\System\msadc\adcvbs.inc
    C:\program files\common files\System\msadc\HANDLER.reg
    C:\program files\common files\System\msadc\HANDLER.SRG
    C:\program files\common files\System\msadc\handsafe.reg
    C:\program files\common files\System\msadc\handunsf.reg
    C:\program files\common files\System\msadc\MDAC11.CAB
    C:\program files\common files\System\msadc\MDAC20.CAB
    C:\program files\common files\System\msadc\MDAC20_A.CAB
    C:\program files\common files\System\msadc\msadce.dll
    C:\program files\common files\System\msadc\msadcer.dll
    C:\program files\common files\System\msadc\msadcf.dll
    C:\program files\common files\System\msadc\msadcfr.dll
    C:\program files\common files\System\msadc\msadco.dll
    C:\program files\common files\System\msadc\msadcor.dll
    C:\program files\common files\System\msadc\msadcs.dll
    C:\program files\common files\System\msadc\msadds.dll
    C:\program files\common files\System\msadc\msaddsr.dll
    C:\program files\common files\System\msadc\msdaprsr.dll
    C:\program files\common files\System\msadc\msdaprst.dll
    C:\program files\common files\System\msadc\msdarem.dll
    C:\program files\common files\System\msadc\msdaremr.dll
    C:\program files\common files\System\msadc\msdfmap.dll

  - [C:\program files\common files\System\Ole DB]
  - [C:\program files\common files\System\Ole DB\en-US]

      C:\program files\common files\System\Ole DB\en-US\msdaorar.dll.mui
      C:\program files\common files\System\Ole DB\en-US\msdasqlr.dll.mui
      C:\program files\common files\System\Ole DB\en-US\oledb32r.dll.mui
      C:\program files\common files\System\Ole DB\en-US\sqloledb.rll.mui
      C:\program files\common files\System\Ole DB\en-US\sqlxmlx.rll.mui

    - [C:\program files\common files\System\Ole DB\resources]
    - [C:\program files\common files\System\Ole DB\resources\1033]

    C:\program files\common files\System\Ole DB\resources\1033\MSDMINE.RLL
    C:\program files\common files\System\Ole DB\resources\1033\MSOLAP80.RLL
    C:\program files\common files\System\Ole DB\resources\1033\OLAPUIR.RLL
    C:\program files\common files\System\Ole DB\JoltReadme.txt
    C:\program files\common files\System\Ole DB\msdadc.dll
    C:\program files\common files\System\Ole DB\msdaenum.dll
    C:\program files\common files\System\Ole DB\msdaer.dll
    C:\program files\common files\System\Ole DB\MSDAERR.DLL
    C:\program files\common files\System\Ole DB\MSDAIPP.DLL
    C:\program files\common files\System\Ole DB\msdaora.dll
    C:\program files\common files\System\Ole DB\msdaorar.dll
    C:\program files\common files\System\Ole DB\msdaosp.dll
    C:\program files\common files\System\Ole DB\MSDAPML.DLL
    C:\program files\common files\System\Ole DB\msdaps.dll
    C:\program files\common files\System\Ole DB\MSDASC.CNT
    C:\program files\common files\System\Ole DB\msdasc.dll
    C:\program files\common files\System\Ole DB\MSDASC.HLP
    C:\program files\common files\System\Ole DB\MSDASC.TXT
    C:\program files\common files\System\Ole DB\msdasql.dll
    C:\program files\common files\System\Ole DB\msdasqlr.dll
    C:\program files\common files\System\Ole DB\MSDASQLreadme.txt
    C:\program files\common files\System\Ole DB\MSDATL2.DLL
    C:\program files\common files\System\Ole DB\msdatl3.dll
    C:\program files\common files\System\Ole DB\msdatt.dll
    C:\program files\common files\System\Ole DB\msdaurl.dll
    C:\program files\common files\System\Ole DB\MSDMENG.DLL
    C:\program files\common files\System\Ole DB\MSDMINE.DLL
    C:\program files\common files\System\Ole DB\MSJTOR35.DLL
    C:\program files\common files\System\Ole DB\MSMDCB80.DLL
    C:\program files\common files\System\Ole DB\MSMDGD80.DLL
    C:\program files\common files\System\Ole DB\MSMDUN80.DLL
    C:\program files\common files\System\Ole DB\MSOLAP80.DLL
    C:\program files\common files\System\Ole DB\MSOLUI80.DLL
    C:\program files\common files\System\Ole DB\MSOrclOLEDBreadme.txt
    C:\program files\common files\System\Ole DB\msxactps.dll
    C:\program files\common files\System\Ole DB\mtxoci7x_win2k.reg
    C:\program files\common files\System\Ole DB\mtxoci7x_winnt.reg
    C:\program files\common files\System\Ole DB\mtxoci80_win2k.reg
    C:\program files\common files\System\Ole DB\mtxoci80_winnt.reg
    C:\program files\common files\System\Ole DB\mtxoci81_win2k.reg
    C:\program files\common files\System\Ole DB\mtxoci81_winnt.reg
    C:\program files\common files\System\Ole DB\newudl.reg
    C:\program files\common files\System\Ole DB\nonewudl.reg
    C:\program files\common files\System\Ole DB\oledb32.dll
    C:\program files\common files\System\Ole DB\oledb32r.dll
    C:\program files\common files\System\Ole DB\oledb32x.dll
    C:\program files\common files\System\Ole DB\oledbjvs.inc
    C:\program files\common files\System\Ole DB\oledbvbs.inc
    C:\program files\common files\System\Ole DB\sqloledb.dll
    C:\program files\common files\System\Ole DB\sqloledb.rll
    C:\program files\common files\System\Ole DB\SQLOLEDB.TXT
    C:\program files\common files\System\Ole DB\sqlsoldb.chm
    C:\program files\common files\System\Ole DB\SQLSOLDB.HLP
    C:\program files\common files\System\Ole DB\sqlxmlx.dll
    C:\program files\common files\System\Ole DB\sqlxmlx.rll

Now .. .

In winsxs folders, i have two types of msado15.dll
-V6.1.7600.16688
-V6.1.7600.20818

He proposed me to register msado15.dll in:
C:\program files\common files\System

So i unregistered & registered those files in the system directory
& also in the System\ado directory (program files);

-Nothing works .. .

Ps: I have another version V2.81.1117.0
in C:\Windows\System32\DllCache

So if i have registered & unregistered those two win7 versions
in two different locations unsuccessfully, besides killing myself,
what can i do because your Mdac repair tool from tweaking.com
hasn't helped either after a restart .. .


Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #1 on: December 11, 2011, 12:51:37 PM »
Grab my MDAC tester
http://www.pcwintech.com/shanes-toolbox

See what kind of errors it gives when it tried to read a database :-)

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #2 on: December 11, 2011, 02:15:32 PM »
Starting Test.
Date: 12/11/2011 Time: 11:14:29 PM
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using DAO...
--Successful
Opening Table...
--Successful
Closing connection to the database.
--Successful
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Connecting To Test.mdb using ADO...
ERROR!: 91 - Object variable or With block variable not set
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Done, Test Complete.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''

I tried that, it doesn't help either:
http://wiki.answers.com/Q/How_do_you_fix_a_runtime_error_91_object_variable_not_set

« Last Edit: December 11, 2011, 02:28:39 PM by delicate »

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #3 on: December 11, 2011, 02:28:51 PM »
You may want to let the programmer know a trick I do. My Simple Port Forwarding program www.simpleportforwarding.com uses MDAC.
As you can see on your system ADO fails but DAO works.

In my program I have it try one, if it gets an error it uses the other. Will save him a ton of headache, so let him know. The code between the 2 are very similar  :wink:

During the course of my simple port forwarding program I ran into users who had MDAC troubles like yourself. So I made a repair tool that fixed a lot of them (Not all of course)

SO lets see if we have luck with it here.

Run my repair
http://www.tweaking.com/content/page/repair_mdac_ms_jet.html

Reboot after and then run my mdac tester again and lets see if ADO plays nice :-)

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #4 on: December 11, 2011, 03:07:45 PM »
i had already tried your tool unsuccessfully as stated in the original post,
also, another dev from w3schools replied with that:

Sukhdev Singh

    Gender:Male
    Location:New Delhi

Dear,

MDAC
Supported Operating Systems: Windows 2000, Windows 98, Windows ME, Windows NT

You trying to access in windows 7 which is not compatible with MDAC Services.

--------

& the author of the program pretends:

"We have tested the Advanced Email Verifier on Windows 7 and it works well. And nobody from our customers has reported about issues."

-------

So who should i trust ?

Do i really have the option of running mdac services on win7 & am i really
missing something in my os ? or is mr Singh right ?

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #5 on: December 11, 2011, 03:14:38 PM »
Also, isn't ado supposed to work in windows 7 & replace mdac correctly?
it's supposed to be mdac replacement, and in that case, it'd be my
ado system that is buggy .. . & the real issue, instead of trying to
reprogram apps ?

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #6 on: December 11, 2011, 03:16:08 PM »
MDAC works fine on Window 7. I run a few programs of mine that use MDAC. I use it to work with MS access databases.

MDAC isn't going anywhere and I have no clue why someone would think MDAC doesn't work on Windows 7. As you seen for yourself it is already part of Windows :wink:

Sorry I didn't notice you already tried my repair tool. Thats what I get for reading post when I am not feeling well lol.

MDAC is messed up on your system though. At least the ADO part is. Problem is finding out why. We know you have the files on the system. So it isnt a missing file problem.

It must be either a reg key issues, something set wrong. Or something else that ADO depends on is messed up. But I don't know what ADO relies on in the system.


I think Sukhdev Singh is thinking MDAC isnt for windows 7 because if you go to MS to download MDAC it says it is for "Windows 2000, Windows 98, Windows ME, Windows NT" but it only states that because the latest is already on Windows 7.

Do you have service pack 1 installed for windows?

Shane

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #7 on: December 11, 2011, 03:16:59 PM »
Also, isn't ado supposed to work in windows 7 & replace mdac correctly?
it's supposed to be mdac replacement, and in that case, it'd be my
ado system that is buggy .. . & the real issue, instead of trying to
reprogram apps ?

Thats right.

My thing about letting the programmer know my DAO to ADO trick was just to help avoid this is all (From one programmer to another). Nothing more :-)

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #8 on: December 11, 2011, 03:21:03 PM »
in other words, i guess his app is calling ado & not mdac or is supposed to work with ado when mdac's not present, as he pretends his customers have been running his app on win7 without issues .. .

& how could i fix my ado installation ?

do you think you could gather every ado's reg keys in one reg file from your win7
& send it to me or would that be complicated ? ))

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #9 on: December 11, 2011, 03:23:41 PM »
"MDAC isn't going anywhere and I have no clue why someone would think MDAC doesn't work on Windows 7. As you seen for yourself it is already part of Windows"

it's called dac (6.1)

& i cannot install mdac 2.8 sp1 on a windows7 machine running the setup ... .

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #10 on: December 11, 2011, 03:25:21 PM »
I wouldn't know where all the reg keys are. Otherwise I would have that in my repair :-)

MDAC is multiple database accessing tools. ADO is just one part of it. You also have DAO, MS jet and others.

In my program I had users who had only one or the other working on there system. SO to help those users and make my program better I have it use both. Rarely do I get support request related to MDAC now :-)

You didn't answer, but do you have SP1 installed on Windows 7? if not installing it might fix it.

Otherwise one thing you could do is a repair install of Windows. :wink:
http://www.sevenforums.com/tutorials/3413-repair-install.html

Shane

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #11 on: December 11, 2011, 03:26:19 PM »
"MDAC isn't going anywhere and I have no clue why someone would think MDAC doesn't work on Windows 7. As you seen for yourself it is already part of Windows"

it's called dac (6.1)

& i cannot install mdac 2.8 sp1 on a windows7 machine running the setup ... .

MDAC 2.8 is already part of windows, thats why the setup wont let you install it :-)

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #12 on: December 11, 2011, 03:30:54 PM »
a repair install doesn't respect everything that's already installed & i have 10 months of fixes & customizations i don't wanna lose, it's too invasive for my part.

"if sp1 will fix it, then"

it's found in my updates window, but 9 fixes along with sp1 fail to install & i also tried your repair
tool for the windows install program unsuccessfully,

another way to install sp1 ? or fix the issue of not being able to install it before suicide ? ))

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #13 on: December 11, 2011, 03:32:19 PM »
If SP1 wont install then you have more problems. :wink:

Getting SP1 installed will help a lot.

Did you run my Windows repair tool, and if so did you run all the repairs?

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #14 on: December 11, 2011, 03:34:55 PM »
i can't repair everything, if i do that, i'll be adding more obsolete registry entries or waking up services that were disabled maybe. i believe many other fixes are obsolete for my issue like the network & co

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #15 on: December 11, 2011, 03:36:56 PM »
When it comes to SP1 to install, permissions are the biggest issue.

Run both the reg and file permissions repair. Also run the WMI and register system files repair. Also instead of doing SP1 through windows update, download the whole SP1 package and install it that way. This way if it is Windows updates getting in the way then SP1 should install. :wink:

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #16 on: December 11, 2011, 03:39:50 PM »
i think i've done those repairs, but i'll try it & download the update separately, please pray for me ahaha

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #17 on: December 11, 2011, 03:40:27 PM »
Good luck :wink:

Shane

Offline friedmonky

  • Jr. Member
  • **
  • Join Date: Oct 2011
  • Posts: 89
  • Location: USA
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #18 on: December 11, 2011, 03:51:27 PM »
If SP1 fails to install again, the System Update Readiness Tool might help.  Download and run it before trying to install SP1 again.

http://windows.microsoft.com/en-US/windows7/What-is-the-System-Update-Readiness-Tool

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #19 on: December 11, 2011, 07:07:09 PM »
I did all that & couldn't install sp1 either ((

Shane, could you do me a favor ?

if you have win7 sp2, zip your
C:\Program Files\Common Files\System\ado
folder & email it to me please:
ukrainian consular (in one word)
At
gmail
com

(email of registration)

otherwise, a package of win8 ado folder would interest me as well,
cause your repair tool registers actual rtm dll versions & new dlls
may have fixed my issue.

i've read a report of another guy whos upgraded to win7 ultimate rtm
& faced the same issue.

then i'll try to register all the files i have unpacked one by one.

Also, i don't know if you forgot something in your mdac repair tool
but there are two ways of registering here:

http://www.arcomit.co.uk/support/kb.aspx?kbid=000027

with u switch & then s
for the ado folder .. .
« Last Edit: December 11, 2011, 07:11:22 PM by delicate »

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #20 on: December 11, 2011, 07:26:59 PM »
I'm on Win7 sp1 64 bit.

You on 32 or 64?

Shane

Offline delicate

  • Newbie
  • *
  • Join Date: Dec 2011
  • Posts: 11
  • Karma: 0
    • View Profile
Re: Mdac Hell
« Reply #21 on: December 11, 2011, 07:29:47 PM »
32, i guess it might not work here (( unless u have another pc running 32bit,
i never upgraded to 64 to avoid soft compatibility issues ((

Offline Shane

  • Lead Developer - Coder
  • Administrator
  • Hero Member
  • *****
  • Join Date: Sep 2011
  • Posts: 9279
  • Location: USA
  • Karma: 138
  • "Knowledge should be shared not hidden."
    • View Profile
    • Tweaking.com
Re: Mdac Hell
« Reply #22 on: December 12, 2011, 12:37:53 AM »
I dont have 32 bit handy right now.

I have also never had a single issue with 32 bit apps on 64 bit. The only thing to worry about is drivers. If  you have old hardware that doesnt have 64 bit drivers. But other than that havent had a single issue with any of my customers computers :-) (I run a computer repair business) :wink:

Shane