Registering ADO components

Hello to the experts out there

We all know that creating a database project in VB6 requires you to install MDAC on the clients machine which the PDW will happily add for you. However this significantly adds to the installation size. From 3MB to 10MB!
This is not an option for me so i tried adding only the reference that the project needed: the Microsoft Active X data objects library 2.7, (msado15.dll)
I also added in the .reg files to register them during setup. (Adoapt15.reg,Adofre15.reg)
This works fine on my developing PC, but during testing, an error occurs while trying to register the component. I am developing on an NT machine and i have trouble installing on another 'clean' NT machine. However when i checked the NT machine, it already had the ado components installed under "\Program Files\Common\System\ADO"
On a Win2000 machine it runs okay.
On Win98/95 I know DCOM98 is needed, but i have yet to try that yet.
Have not test on WinME either.
Can someone tell me how to solve this?

regards
shern
shernAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arbertCommented:
You need to distribute MDAC--it works on your development machine because all the pieces are there MSADO15.DLL is not the only piece needed for ADO functionality.  Why isn't a 10mb install an option?  If that's what it takes to get all the files, there isn't much of a choice.

Also, get rid of PDW--it's crap.  I've had it hose machines several times by overlaying DLLs with older ones.

Take a look at installshield or wise.

Brett
0
Éric MoreauSenior .Net ConsultantCommented:
Duplicate question!


You cannot go on to only installs some of the files. You need to install the complete MDAC_TYP.EXE (which can be installed separately). The problem is that msado15.dll has a lot of dependencies and that's why you need to install the whole 8 meg.
0
shernAuthor Commented:
IM sorry i accidentally posted this same question twice >_<
anyway...
If the entire mdac is need how come i can pull it off on the win2000 machine w/O faults?
Is there any other maybe older components that don't require too many dependencies?
I can't afford to make the installation filesize big, because the company i am doing the program for wants it
ASAP(as small as possible), it is to be distributed on the net. I don't want to have to direct users to go and download mdac, it has to be that one installation file should take care of everything. Does mdac come installed on any of the Win O/S by default?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

arbertCommented:
That's like buying a car without tires because it's too tall.....You gotta distribute all the dependencies....

You could generate a CAB that they can install from the web easily--checkout installshield....

Brett
0
Éric MoreauSenior .Net ConsultantCommented:
>>how come i can pull it off on the win2000 machine w/O faults?

Win2K includes ADO 2.5. This is why you may not have problems on these computers!

>>wants it ASAP(as small as possible), it is to be distributed on the net. I don't want to have to direct users to go and download mdac

You don't have many options!
0
shernAuthor Commented:
Okay
It appears that
on the o/s systems that i checked on already
come with

programs/common files/system/ado

for win98/2000/NT/XP

So i don't have to include MDAC with the installation file
0
arbertCommented:
That's a poor assumption.  Just because it comes with the operating system originally, doesn't mean that it's install correctly, still even installed, or the version you require.....

Brett
0
Éric MoreauSenior .Net ConsultantCommented:
With Windows 2000, it is more a problem version. You said that you are using ADO 2.7. W2K installs (correctly) ADO 2.5!
0
shernAuthor Commented:
okay i packaged two versions
one for 98
one for NT/XP/2000

fot the 98 version i used ADO2.0
and it works okay

for the NT/XP/2000 version
it doesnt run correctly either it keeps saying that files are out of date and after rebooting.. the same error occurs even though i supposedly updated the files.
And 2000 doesnt work very well
0
Éric MoreauSenior .Net ConsultantCommented:
have you created your package on XP? You must remove msvcrt.dll from the list of distributed files.
0
shernAuthor Commented:
what about NT? what version of ADO does it install?
is it also 2.5?
I removedf msvcrt on all versions
0
Éric MoreauSenior .Net ConsultantCommented:
NT doesn't install MDAC because NT is older then MDAC.
0
shernAuthor Commented:
OK so u mean for NT the users have to install MDAC seperately or i have to include them in the package installer correct? ANother thing: I seem to have a problem
running the installer on win2k machines with service pack 2 installed. The installer will prompt that files on the computer are out of date and ask to update the files and reboot. however after rebooting, the installation doesnt proceed, it keeps on trying to update the files again. Any Ideas?
0
Éric MoreauSenior .Net ConsultantCommented:
When I create a package, I always include the correct version of MDAC. If it is already on the client PC, it is simply skip. Else it is updated.

Have you installed SP5 for VB6?

You may also have a problem with OleAut32.dll like it is documented into http://support.microsoft.com/default.aspx?scid=kb;en-us;279764

If you still have problems, I would request client to download and run VBRun60sp5.exe from http://support.microsoft.com/default.aspx?scid=kb;EN-US;290887
0
shernAuthor Commented:
THanks for the previous post regarding OleAut32.dll. the thread you gave me was right on the dot! I was searchng the net for something like that :>

Anyway I had problems deploying the app on an NT machine( which is weird since im using an NT machine to write this project in the 1st place) I included the MDAC_TYP.EXE to be kicked off when i run setup. And the components still do not register correctly! I've checked the Commonfiles/System/ADO folders and the ADO files already exist. The app runs, but Fails while utilising the ADO.

ANyway for win98 I've managed not to include MDAC_TYP by using an earlier version of ADO 2.0 msado20.tlb. Seems to work fine so far
0
Éric MoreauSenior .Net ConsultantCommented:
>>And the components still do not register correctly

What is the EXACT error?


>>by using an earlier version of ADO 2.0 msado20.tlb

I hope you do not try to distribute the .tlb!
0
shernAuthor Commented:
>>by using an earlier version of ADO 2.0 msado20.tlb

I hope you do not try to distribute the .tlb!

(of course not! :> doin so will only generate an error that says cannot register the tlb)

>>And the components still do not register correctly

What is the EXACT error?
1st error:
REGSVR:Unable to local "C:\Program FIles\Common Files\System\ADO\msado15.dll" 126: the specified module could not be foun.

2nd error:
Unable to register library "C:\Program FIles\Common Files\System\ADO\msado15.dll" the operation completed successfully

Sounds pretty contradicting don't it?
0
Éric MoreauSenior .Net ConsultantCommented:
on which OS?
0
arbertCommented:
You know you could have already had this fixed and saved a big headache by getting installshield--software distribution really shouldn't be left up to guesswork.

Brett
0
shernAuthor Commented:
emoreau: WIN NT
0
Éric MoreauSenior .Net ConsultantCommented:
Are you installing MDAC_TYP.EXE from your setup package or do you install msado15.dll ?

Which version of MDAC are you trying to install?
0
arbertCommented:
emoreau, look above at the entire thread--we've been through the whole MDAC thing--and the version is listed.
0
Éric MoreauSenior .Net ConsultantCommented:
shern, Can you show your setup1.lst file?
0
shernAuthor Commented:
>>Are you installing MDAC_TYP.EXE from your setup package >>or do you install msado15.dll ?

>>Which version of MDAC are you trying to install?

im installing the mdac_type.exe ver 2.7 i think. the lattest one.
0
CleanupPingCommented:
Hi shern,
This old question (QID 20554212) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
arbertCommented:
What's the status of this question?
0
CleanupPingCommented:
shern:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
0
GPrentice00Commented:
This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in a week or two.  I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help/closing.jsp

GPrentice00
Cleanup Volunteer
0
arbertCommented:
Split the points (not that there were that many) everyone attempted to help....
0
Éric MoreauSenior .Net ConsultantCommented:
20 points is not enough to be splitted!
0
GPrentice00Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->PAQ - no points refunded

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer
0
YensidModCommented:
Question is PAQ'd and no points refunded.

YensidMod
Community Support Moderator @Experts Exchange
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Installation

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.