ADO (?) Errors on NT

[Jeff Carlin]

I have a client whose NT4 box will not run an ADO-based VB6 app. Looking thru his uninstall log (St6unst.log), I find nothing that gives a clue. Everything was installed and/or registered.

The kind of errors encountered while running the app are:
430 Class does not support Automation...
3709 Operation is not allowed...

Is this a DCOM-type error? Doesn't NT automatically have DCOM, etc? Is MDAC involved?

We have lots of other clients running similar apps on NT boxes with no problems. Can anyone give me a clue???

Thanks

[crispin]

What version of MDAC is on the client? (check by getting the version number of msado15.dll)

[Jeff Carlin]

I looked in the setup.lst file for this project (the list of distributed files) and "msado15.dll" is not in there. Is this a problem? The only "msado" file in there is "msadox.dll".

Additionally, what version of MDAC should they have? They are running NT4. I notice I have Ver 2.50xxx on my machine. Should I have them load that?

Thanks for your help. I am lost!

[jbart]

That is most likely the problem. I got error 430 when I had incompatible versions of ADO on the development PC and the client PC's.

[crispin]

Jeff

Yes, load the development version onto the client version - the other option if you can't find the MDAC_TYP.EXE file which is the setup file for the components is to download the lastest version from Microsoft.

[Jeff Carlin]

Crispin - are you saying to send him the msado15.dll file? If so, where should he install? Should he register it? Etc...

Thanks.

[crispin]

Jeff
You need to go to :

http://www.microsoft.com/data/download.htm

and download the latest version of:

MDAC 2.5 RTM

here is the link:

http://www.microsoft.com/data/download_250rtm.htm

this then needs to be installed on the client machine.

(to everyone else)
I know there are other ways to do this, and to just copy the relevant DLLS here - and I know theres a KB article that describes this somewhere in the depths of the MS kb, but I have done this a while ago, and encountered no end of problems with Office, SQL server, ODBC, and other beasts.

[Jeff Carlin]

Ok, here's the latest...

Client definitely has the latest MDAC version on his machine. He also has the msado15.dll file. We are both going nuts!

Just a thought...if he installed MDAC as a non-Admin, would that make a difference? Sorry, just grasping for straws.

Anyone???

[samwise]

What service pack is installed? And what version of IE is installed?

Samwise Galenorn

[crispin]

good call samwise. And yes if he tried to install MDAC as a non admin it would go horribly wrong...

[Jeff Carlin]

samwise-

What SP for NT4 is needed. Also, what about version for IE?

crispin-

Would a non-Admin install still install the files? What could be the result?

Thanks, guys.

[samwise]

For MDAC 2.5, I believe Service Pack 5 with Internet Explorer 4.01 SP2. That minimum requirement would insure it would work.

And yes, you do need admin privledges.

Now, you can install MDAC 2.5 Service Pack 1. It has all of the bug fixes, so it should be good.

In review, use (for Win NT 4.0)
Service Pack 5.0 or above (SP 6a is out now)
Internet Explorer 4.01 SP2 or above (IE 5.5 is out now)
MDAC 2.5 SP1. (MDAC 2.6 is out now. I used to test that product at Microsoft)

(Install them in that order).

Samwise Galenorn
[email protected]