what role has COM, DCOM when ADO/DAO works

[MrRolf]

I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
The reason is that my win95 users often get error messages with automation
and interface in it.

eks: error 430 -> "class does not support Automation or does not support
interface"



Chinese tea is good and healty.

thanks for your time.

[Ben]

MrRolf,

Automation errors when dealing with ADO are in most cases caused by the PC
not having the most updated MDAC (currently 2.6) installed on the system.
You must also remember that MDAC 2.6 does not come with the jet components
in it. To get these you must first install MDAC 2.5 and then upgrade to MDAC
2.6 or install the jet40sp5_9xNT.exe file. Also, make sure the PC has IE
4.01 sp2 or greater installed. This should clear up this error.

Ben

-Mainframe-

"A computer is a terrible thing to waste"


"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>
>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>The reason is that my win95 users often get error messages with automation
>and interface in it.
>
>eks: error 430 -> "class does not support Automation or does not support
>interface"
>
>
>
>Chinese tea is good and healty.
>
>thanks for your time.

[MrRolf]

Thanks Ben

Looking at the text over a cup hot chinese green tea.
There was just two things my brain couldn't figure out..

1. Most important -> "Why on earth must Internet Explorer be installed ??"

jet40sp5_9xNT.exe -> is this "NT" thing meant for win NT ?

Have win95 difficult handling these com tecknologies as mentioned, since
95 have most problems with it.


"Ben" <bmjimenez@tfpdata.com> wrote:
>
>MrRolf,
>
>Automation errors when dealing with ADO are in most cases caused by the
PC
>not having the most updated MDAC (currently 2.6) installed on the system.
>You must also remember that MDAC 2.6 does not come with the jet components
>in it. To get these you must first install MDAC 2.5 and then upgrade to
MDAC
>2.6 or install the jet40sp5_9xNT.exe file. Also, make sure the PC has IE
>4.01 sp2 or greater installed. This should clear up this error.
>
>Ben
>
>-Mainframe-
>
>"A computer is a terrible thing to waste"
>
>
>"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>>
>>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>>The reason is that my win95 users often get error messages with automation
>>and interface in it.
>>
>>eks: error 430 -> "class does not support Automation or does not support
>>interface"
>>
>>
>>
>>Chinese tea is good and healty.
>>
>>thanks for your time.
>

[Ben]

MrRolf,

Why must IE be installed?
Because ADO uses dll's that are only found in IE. They do NOT come in MDAC,DCOM
or the JET file I mentioned. This is something you do know unless you have
dealt with the situation first hand (like me) or you have talked with Microsoft
on the phone (like me).

Is this NT thing meant for NT?
It's meant for both windows 9x and NT. It simply will install the missing
jet files into the PC that the MDAC 2.6 does not have. On a Windows 95 machine
I would recommend intalling DCOM95,MDAC2.5,MDAC2.6 and then make sure it
has IE 4.01sp2 or above. I think the latest IE is 5.x.

The main reason for all this is because ADO is designed to be used on the
Internet as well as a stand alone PC. So there are strong ties between Windows,
IE and your program (if it used ADO). If one thing is missing or the wrong
version you are going to run into problems.


"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>
>Thanks Ben
>
>Looking at the text over a cup hot chinese green tea.
>There was just two things my brain couldn't figure out..
>
>1. Most important -> "Why on earth must Internet Explorer be installed ??"
>
>jet40sp5_9xNT.exe -> is this "NT" thing meant for win NT ?
>
>Have win95 difficult handling these com tecknologies as mentioned, since
>95 have most problems with it.
>
>
>"Ben" <bmjimenez@tfpdata.com> wrote:
>>
>>MrRolf,
>>
>>Automation errors when dealing with ADO are in most cases caused by the
>PC
>>not having the most updated MDAC (currently 2.6) installed on the system.
>>You must also remember that MDAC 2.6 does not come with the jet components
>>in it. To get these you must first install MDAC 2.5 and then upgrade to
>MDAC
>>2.6 or install the jet40sp5_9xNT.exe file. Also, make sure the PC has IE
>>4.01 sp2 or greater installed. This should clear up this error.
>>
>>Ben
>>
>>-Mainframe-
>>
>>"A computer is a terrible thing to waste"
>>
>>
>>"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>>>
>>>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>>>The reason is that my win95 users often get error messages with automation
>>>and interface in it.
>>>
>>>eks: error 430 -> "class does not support Automation or does not support
>>>interface"
>>>
>>>
>>>
>>>Chinese tea is good and healty.
>>>
>>>thanks for your time.
>>
>

[MrRolf]

Thanks Ben

Very good answers







"Ben" <bmjimenez@tfpdata.com> wrote:
>
>MrRolf,
>
>Why must IE be installed?
>Because ADO uses dll's that are only found in IE. They do NOT come in MDAC,DCOM
>or the JET file I mentioned. This is something you do know unless you have
>dealt with the situation first hand (like me) or you have talked with Microsoft
>on the phone (like me).
>
>Is this NT thing meant for NT?
>It's meant for both windows 9x and NT. It simply will install the missing
>jet files into the PC that the MDAC 2.6 does not have. On a Windows 95 machine
>I would recommend intalling DCOM95,MDAC2.5,MDAC2.6 and then make sure it
>has IE 4.01sp2 or above. I think the latest IE is 5.x.
>
>The main reason for all this is because ADO is designed to be used on the
>Internet as well as a stand alone PC. So there are strong ties between Windows,
>IE and your program (if it used ADO). If one thing is missing or the wrong
>version you are going to run into problems.
>
>
>"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>>
>>Thanks Ben
>>
>>Looking at the text over a cup hot chinese green tea.
>>There was just two things my brain couldn't figure out..
>>
>>1. Most important -> "Why on earth must Internet Explorer be installed
??"
>>
>>jet40sp5_9xNT.exe -> is this "NT" thing meant for win NT ?
>>
>>Have win95 difficult handling these com tecknologies as mentioned, since
>>95 have most problems with it.
>>
>>
>>"Ben" <bmjimenez@tfpdata.com> wrote:
>>>
>>>MrRolf,
>>>
>>>Automation errors when dealing with ADO are in most cases caused by the
>>PC
>>>not having the most updated MDAC (currently 2.6) installed on the system.
>>>You must also remember that MDAC 2.6 does not come with the jet components
>>>in it. To get these you must first install MDAC 2.5 and then upgrade to
>>MDAC
>>>2.6 or install the jet40sp5_9xNT.exe file. Also, make sure the PC has
IE
>>>4.01 sp2 or greater installed. This should clear up this error.
>>>
>>>Ben
>>>
>>>-Mainframe-
>>>
>>>"A computer is a terrible thing to waste"
>>>
>>>
>>>"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>>>>
>>>>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>>>>The reason is that my win95 users often get error messages with automation
>>>>and interface in it.
>>>>
>>>>eks: error 430 -> "class does not support Automation or does not support
>>>>interface"
>>>>
>>>>
>>>>
>>>>Chinese tea is good and healty.
>>>>
>>>>thanks for your time.
>>>
>>
>

[MrRolf]

Mr Ben !!

I would like your personal opinion on this ..

What would you recommend me ADO or DAO if i would like to have the soulution
that is the least sensitive on system changes or other distributions ?
How would the list for DAO looked alike, like the one you maked for ADO.

Thanks again.



"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>
>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>The reason is that my win95 users often get error messages with automation
>and interface in it.
>
>eks: error 430 -> "class does not support Automation or does not support
>interface"
>
>
>
>Chinese tea is good and healty.
>
>thanks for your time.

[Arthur Wood]

Mr Rolf,
The reasoin the IE must be installed in that the IE installation adds
the necessary support files for the most current version of ADO.

jet40sp5_9xNT.exe is the installtion module for "Jet 4.0 Service Pack 5"
for ALL flavors of Windows (9x=95/98/98se/98ME) and the NT is obviously for
Windows NT. No mystery whatsoever.

Arthur Wood


"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>
>Thanks Ben
>
>Looking at the text over a cup hot chinese green tea.
>There was just two things my brain couldn't figure out..
>
>1. Most important -> "Why on earth must Internet Explorer be installed ??"
>
>jet40sp5_9xNT.exe -> is this "NT" thing meant for win NT ?
>
>Have win95 difficult handling these com tecknologies as mentioned, since
>95 have most problems with it.
>
>
>"Ben" <bmjimenez@tfpdata.com> wrote:
>>
>>MrRolf,
>>
>>Automation errors when dealing with ADO are in most cases caused by the
>PC
>>not having the most updated MDAC (currently 2.6) installed on the system.
>>You must also remember that MDAC 2.6 does not come with the jet components
>>in it. To get these you must first install MDAC 2.5 and then upgrade to
>MDAC
>>2.6 or install the jet40sp5_9xNT.exe file. Also, make sure the PC has IE
>>4.01 sp2 or greater installed. This should clear up this error.
>>
>>Ben
>>
>>-Mainframe-
>>
>>"A computer is a terrible thing to waste"
>>
>>
>>"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>>>
>>>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>>>The reason is that my win95 users often get error messages with automation
>>>and interface in it.
>>>
>>>eks: error 430 -> "class does not support Automation or does not support
>>>interface"
>>>
>>>
>>>
>>>Chinese tea is good and healty.
>>>
>>>thanks for your time.
>>
>

[Ben]

Mr. Rolf,

The list for DAO is really not a list as far as I know. All files that are
needed to access the database are installed by your program. No MDAC needed!
I am currently working on a program right now and I am strickly using DAO.
Some things are a little more tricky to do, but the end result is alot faster
and (i think) more reliable. If I had it my way I'd like to keep the program
16-bit so that users of Win 3.1 may use the software, but I'm not a big wig
so I have no say.

Ben

-Mainfram-


P.S. Sorry so late




"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>
>Mr Ben !!
>
>I would like your personal opinion on this ..
>
>What would you recommend me ADO or DAO if i would like to have the soulution
>that is the least sensitive on system changes or other distributions ?
>How would the list for DAO looked alike, like the one you maked for ADO.
>
>Thanks again.
>
>
>
>"MrRolf" <rolf-eilert.johansen@siving.hia.no> wrote:
>>
>>I was windering how win 95 managed COM tecknologies when DAO/ADO is used.
>>The reason is that my win95 users often get error messages with automation
>>and interface in it.
>>
>>eks: error 430 -> "class does not support Automation or does not support
>>interface"
>>
>>
>>
>>Chinese tea is good and healty.
>>
>>thanks for your time.
>