what role has COM, DCOM when ADO/DAO works


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 8 of 8

Thread: what role has COM, DCOM when ADO/DAO works

  1. #1
    MrRolf Guest

    what role has COM, DCOM when ADO/DAO works


    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.

  2. #2
    Ben Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.



  3. #3
    MrRolf Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.

    >



  4. #4
    Ben Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.

    >>

    >



  5. #5
    MrRolf Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.
    >>>

    >>

    >



  6. #6
    MrRolf Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.



  7. #7
    Arthur Wood Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.

    >>

    >



  8. #8
    Ben Guest

    Re: what role has COM, DCOM when ADO/DAO works


    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.

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center