?
Solved

Registering ADO components

Posted on 2003-03-17
32
Medium Priority
?
332 Views
Last Modified: 2013-11-14
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
0
Comment
Question by:shern
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 9
  • 7
  • +3
32 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 8156522
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8156533
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
 

Author Comment

by:shern
ID: 8156544
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 34

Expert Comment

by:arbert
ID: 8156551
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8156555
>>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
 

Author Comment

by:shern
ID: 8156857
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
 
LVL 34

Expert Comment

by:arbert
ID: 8157192
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8158305
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
 

Author Comment

by:shern
ID: 8159857
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8160954
have you created your package on XP? You must remove msvcrt.dll from the list of distributed files.
0
 

Author Comment

by:shern
ID: 8164356
what about NT? what version of ADO does it install?
is it also 2.5?
I removedf msvcrt on all versions
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8165717
NT doesn't install MDAC because NT is older then MDAC.
0
 

Author Comment

by:shern
ID: 8178231
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8178677
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
 

Author Comment

by:shern
ID: 8178767
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8178773
>>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
 

Author Comment

by:shern
ID: 8178839
>>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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8183154
on which OS?
0
 
LVL 34

Expert Comment

by:arbert
ID: 8183175
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
 

Author Comment

by:shern
ID: 8185033
emoreau: WIN NT
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8186515
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
 
LVL 34

Expert Comment

by:arbert
ID: 8186630
emoreau, look above at the entire thread--we've been through the whole MDAC thing--and the version is listed.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8186642
shern, Can you show your setup1.lst file?
0
 

Author Comment

by:shern
ID: 8192329
>>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
 

Expert Comment

by:CleanupPing
ID: 8532136
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
 
LVL 34

Expert Comment

by:arbert
ID: 8718248
What's the status of this question?
0
 

Expert Comment

by:CleanupPing
ID: 8899992
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
 
LVL 6

Expert Comment

by:GPrentice00
ID: 8982912
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
 
LVL 34

Expert Comment

by:arbert
ID: 8983102
Split the points (not that there were that many) everyone attempted to help....
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 8985178
20 points is not enough to be splitted!
0
 
LVL 6

Expert Comment

by:GPrentice00
ID: 9034017
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
 

Accepted Solution

by:
YensidMod earned 0 total points
ID: 9126349
Question is PAQ'd and no points refunded.

YensidMod
Community Support Moderator @Experts Exchange
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Monitor input from a computer is usually nothing special.  In this instance it prevented anyone from using the computer.  This was a preconfiguration that didn't work.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question