VB.NET and MDAC+JET

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • bz

    #1

    VB.NET and MDAC+JET

    Hi,

    When writing database program with VB.NET that accesses MDB and XLS file, do
    you guys know if I still need to distribute MDAC and JET4 to the client
    machine?

    Or .NET framework already comes with all those drivers?

    Thanks!


    --
    There is no answer.
    There has not been an answer.
    There will not be an answer.
    That IS the answer!
    And I am screwed.
    Deadline was due yesterday.
    >
    There is no point to life.
    THAT IS THE POINT.
    And we are screwed.
    We will run out of oil soon.



  • Cor Ligthert [MVP]

    #2
    Re: VB.NET and MDAC+JET

    For BZ, the client need in my idea to have a proper license of office.

    Jet is free and if you use AdoNet and when you use OleDB, than you don't
    need AFAIK nothing more.

    Cor

    "bz" <nospam@yahoo.c omschreef in bericht
    news:OLzGXYOCHH A.4428@TK2MSFTN GP04.phx.gbl...
    Hi,
    >
    When writing database program with VB.NET that accesses MDB and XLS file,
    do you guys know if I still need to distribute MDAC and JET4 to the client
    machine?
    >
    Or .NET framework already comes with all those drivers?
    >
    Thanks!
    >
    >
    --
    >There is no answer.
    >There has not been an answer.
    >There will not be an answer.
    >That IS the answer!
    >And I am screwed.
    >Deadline was due yesterday.
    >>
    >There is no point to life.
    >THAT IS THE POINT.
    >And we are screwed.
    >We will run out of oil soon.
    >

    >

    Comment

    • bz

      #3
      Re: VB.NET and MDAC+JET

      So, you are saying that I still need to install MDAC and JET to the client
      machine if I want to access MDB and XLS files.



      "Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
      news:OjS2soOCHH A.3600@TK2MSFTN GP06.phx.gbl...
      For BZ, the client need in my idea to have a proper license of office.
      >
      Jet is free and if you use AdoNet and when you use OleDB, than you don't
      need AFAIK nothing more.
      >
      Cor
      >
      "bz" <nospam@yahoo.c omschreef in bericht
      news:OLzGXYOCHH A.4428@TK2MSFTN GP04.phx.gbl...
      >Hi,
      >>
      >When writing database program with VB.NET that accesses MDB and XLS file,
      >do you guys know if I still need to distribute MDAC and JET4 to the
      >client machine?
      >>
      >Or .NET framework already comes with all those drivers?
      >>
      >Thanks!
      >>
      >>
      >--
      >>There is no answer.
      >>There has not been an answer.
      >>There will not be an answer.
      >>That IS the answer!
      >>And I am screwed.
      >>Deadline was due yesterday.
      >>>
      >>There is no point to life.
      >>THAT IS THE POINT.
      >>And we are screwed.
      >>We will run out of oil soon.
      >>
      >http://spaces.msn.com/bzDaCat
      >>
      >
      >

      Comment

      • Cor Ligthert [MVP]

        #4
        Re: VB.NET and MDAC+JET

        Peter,

        As far as I know are all the computers where Net can run on already with the
        proper MDAC installed.

        Cor

        "bz" <nospam@yahoo.c omschreef in bericht
        news:%23fimPyOC HHA.3396@TK2MSF TNGP02.phx.gbl. ..
        So, you are saying that I still need to install MDAC and JET to the client
        machine if I want to access MDB and XLS files.
        >
        >
        >
        "Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
        news:OjS2soOCHH A.3600@TK2MSFTN GP06.phx.gbl...
        >For BZ, the client need in my idea to have a proper license of office.
        >>
        >Jet is free and if you use AdoNet and when you use OleDB, than you don't
        >need AFAIK nothing more.
        >>
        >Cor
        >>
        >"bz" <nospam@yahoo.c omschreef in bericht
        >news:OLzGXYOCH HA.4428@TK2MSFT NGP04.phx.gbl.. .
        >>Hi,
        >>>
        >>When writing database program with VB.NET that accesses MDB and XLS
        >>file, do you guys know if I still need to distribute MDAC and JET4 to
        >>the client machine?
        >>>
        >>Or .NET framework already comes with all those drivers?
        >>>
        >>Thanks!
        >>>
        >>>
        >>--
        >>>There is no answer.
        >>>There has not been an answer.
        >>>There will not be an answer.
        >>>That IS the answer!
        >>>And I am screwed.
        >>>Deadline was due yesterday.
        >>>>
        >>>There is no point to life.
        >>>THAT IS THE POINT.
        >>>And we are screwed.
        >>>We will run out of oil soon.
        >>>
        >>http://spaces.msn.com/bzDaCat
        >>>
        >>
        >>
        >
        >

        Comment

        • Spam Catcher

          #5
          Re: VB.NET and MDAC+JET

          "bz" <nospam@yahoo.c omwrote in
          news:#fimPyOCHH A.3396@TK2MSFTN GP02.phx.gbl:
          So, you are saying that I still need to install MDAC and JET to the
          client machine if I want to access MDB and XLS files.
          MDAC has been included as a system component since Windows 2000.

          However, most users on Windows 98 should (but you may want to write a check
          routine) have MDAC installed as well.

          Comment

          • Spam Catcher

            #6
            Re: VB.NET and MDAC+JET

            Spam Catcher <spamhoneypot@r ogers.comwrote in
            news:Xns987C9A1 96C7CFusenethon eypotrogers@127 .0.0.1:
            MDAC has been included as a system component since Windows 2000.
            >
            However, most users on Windows 98 should (but you may want to write a
            check routine) have MDAC installed as well.
            BTW, MDAC for Windows 2000 is MDAC v2.5. However, .NET requires MDAC v2.6
            and recommends v2.7. Thus you may still want to put some MDAC error
            handling just in case.

            You'll get this error if you run the app on a machine without MDAC:

            The .NET Data SQL Provider (System.Data.Sq lClient) requires Microsoft Data
            _
            Access Components (MDAC) version 2.6 or later.

            Comment

            • bz

              #7
              Re: VB.NET and MDAC+JET

              So, I still need to install JET4 to access MDB and XLS files, do I?



              "Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
              news:euimhCPCHH A.1012@TK2MSFTN GP04.phx.gbl...
              Peter,
              >
              As far as I know are all the computers where Net can run on already with
              the proper MDAC installed.
              >
              Cor
              >
              "bz" <nospam@yahoo.c omschreef in bericht
              news:%23fimPyOC HHA.3396@TK2MSF TNGP02.phx.gbl. ..
              >So, you are saying that I still need to install MDAC and JET to the
              >client machine if I want to access MDB and XLS files.
              >>
              >>
              >>
              >"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
              >news:OjS2soOCH HA.3600@TK2MSFT NGP06.phx.gbl.. .
              >>For BZ, the client need in my idea to have a proper license of office.
              >>>
              >>Jet is free and if you use AdoNet and when you use OleDB, than you don't
              >>need AFAIK nothing more.
              >>>
              >>Cor
              >>>
              >>"bz" <nospam@yahoo.c omschreef in bericht
              >>news:OLzGXYOC HHA.4428@TK2MSF TNGP04.phx.gbl. ..
              >>>Hi,
              >>>>
              >>>When writing database program with VB.NET that accesses MDB and XLS
              >>>file, do you guys know if I still need to distribute MDAC and JET4 to
              >>>the client machine?
              >>>>
              >>>Or .NET framework already comes with all those drivers?
              >>>>
              >>>Thanks!
              >>>>
              >>>>
              >>>--
              >>>>There is no answer.
              >>>>There has not been an answer.
              >>>>There will not be an answer.
              >>>>That IS the answer!
              >>>>And I am screwed.
              >>>>Deadline was due yesterday.
              >>>>>
              >>>>There is no point to life.
              >>>>THAT IS THE POINT.
              >>>>And we are screwed.
              >>>>We will run out of oil soon.
              >>>>
              >>>http://spaces.msn.com/bzDaCat
              >>>>
              >>>
              >>>
              >>
              >>
              >
              >

              Comment

              • Michel Posseth  [MCP]

                #8
                Re: VB.NET and MDAC+JET

                And ...

                Mdac 2.5 was the last version that had everything included ( Jet oledb ) to
                access Access :-)

                Since version 2.5 Jet oledb has become a seperate installation

                so my recomendation would be ,, ship the jet oledb merge module with your
                deployment and you should be safe

                regards

                Michel Posseth [MCP]



                "Spam Catcher" <spamhoneypot@r ogers.comschree f in bericht
                news:Xns987C9A5 B7A4C3usenethon eypotrogers@127 .0.0.1...
                Spam Catcher <spamhoneypot@r ogers.comwrote in
                news:Xns987C9A1 96C7CFusenethon eypotrogers@127 .0.0.1:
                >
                >MDAC has been included as a system component since Windows 2000.
                >>
                >However, most users on Windows 98 should (but you may want to write a
                >check routine) have MDAC installed as well.
                >
                BTW, MDAC for Windows 2000 is MDAC v2.5. However, .NET requires MDAC v2.6
                and recommends v2.7. Thus you may still want to put some MDAC error
                handling just in case.
                >
                You'll get this error if you run the app on a machine without MDAC:
                >
                The .NET Data SQL Provider (System.Data.Sq lClient) requires Microsoft Data
                _
                Access Components (MDAC) version 2.6 or later.

                Comment

                • Michel Posseth  [MCP]

                  #9
                  Re: VB.NET and MDAC+JET

                  Yes , you do need to make sure that it is installed on the target system
                  before you start your program

                  regards

                  Michel posseth [MCP]


                  "bz" <nospam@yahoo.c omschreef in bericht
                  news:%23KkkhiPC HHA.4256@TK2MSF TNGP04.phx.gbl. ..
                  So, I still need to install JET4 to access MDB and XLS files, do I?
                  >
                  >
                  >
                  "Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
                  news:euimhCPCHH A.1012@TK2MSFTN GP04.phx.gbl...
                  >Peter,
                  >>
                  >As far as I know are all the computers where Net can run on already with
                  >the proper MDAC installed.
                  >>
                  >Cor
                  >>
                  >"bz" <nospam@yahoo.c omschreef in bericht
                  >news:%23fimPyO CHHA.3396@TK2MS FTNGP02.phx.gbl ...
                  >>So, you are saying that I still need to install MDAC and JET to the
                  >>client machine if I want to access MDB and XLS files.
                  >>>
                  >>>
                  >>>
                  >>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
                  >>news:OjS2soOC HHA.3600@TK2MSF TNGP06.phx.gbl. ..
                  >>>For BZ, the client need in my idea to have a proper license of office.
                  >>>>
                  >>>Jet is free and if you use AdoNet and when you use OleDB, than you
                  >>>don't need AFAIK nothing more.
                  >>>>
                  >>>Cor
                  >>>>
                  >>>"bz" <nospam@yahoo.c omschreef in bericht
                  >>>news:OLzGXYO CHHA.4428@TK2MS FTNGP04.phx.gbl ...
                  >>>>Hi,
                  >>>>>
                  >>>>When writing database program with VB.NET that accesses MDB and XLS
                  >>>>file, do you guys know if I still need to distribute MDAC and JET4 to
                  >>>>the client machine?
                  >>>>>
                  >>>>Or .NET framework already comes with all those drivers?
                  >>>>>
                  >>>>Thanks!
                  >>>>>
                  >>>>>
                  >>>>--
                  >>>>>There is no answer.
                  >>>>>There has not been an answer.
                  >>>>>There will not be an answer.
                  >>>>>That IS the answer!
                  >>>>>And I am screwed.
                  >>>>>Deadline was due yesterday.
                  >>>>>>
                  >>>>>There is no point to life.
                  >>>>>THAT IS THE POINT.
                  >>>>>And we are screwed.
                  >>>>>We will run out of oil soon.
                  >>>>>
                  >>>>http://spaces.msn.com/bzDaCat
                  >>>>>
                  >>>>
                  >>>>
                  >>>
                  >>>
                  >>
                  >>
                  >
                  >

                  Comment

                  • bz

                    #10
                    Re: VB.NET and MDAC+JET

                    So, if I am using ADO.NET to open MDB or XLS files, I still need to install
                    JET4.

                    Got it. Thanks!



                    "Michel Posseth [MCP]" <MSDN@posseth.c omwrote in message
                    news:uzptl1aCHH A.3524@TK2MSFTN GP06.phx.gbl...
                    Yes , you do need to make sure that it is installed on the target system
                    before you start your program
                    >
                    regards
                    >
                    Michel posseth [MCP]
                    >
                    >
                    "bz" <nospam@yahoo.c omschreef in bericht
                    news:%23KkkhiPC HHA.4256@TK2MSF TNGP04.phx.gbl. ..
                    >So, I still need to install JET4 to access MDB and XLS files, do I?
                    >>
                    >>
                    >>
                    >"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
                    >news:euimhCPCH HA.1012@TK2MSFT NGP04.phx.gbl.. .
                    >>Peter,
                    >>>
                    >>As far as I know are all the computers where Net can run on already with
                    >>the proper MDAC installed.
                    >>>
                    >>Cor
                    >>>
                    >>"bz" <nospam@yahoo.c omschreef in bericht
                    >>news:%23fimPy OCHHA.3396@TK2M SFTNGP02.phx.gb l...
                    >>>So, you are saying that I still need to install MDAC and JET to the
                    >>>client machine if I want to access MDB and XLS files.
                    >>>>
                    >>>>
                    >>>>
                    >>>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
                    >>>news:OjS2soO CHHA.3600@TK2MS FTNGP06.phx.gbl ...
                    >>>>For BZ, the client need in my idea to have a proper license of
                    >>>>office.
                    >>>>>
                    >>>>Jet is free and if you use AdoNet and when you use OleDB, than you
                    >>>>don't need AFAIK nothing more.
                    >>>>>
                    >>>>Cor
                    >>>>>
                    >>>>"bz" <nospam@yahoo.c omschreef in bericht
                    >>>>news:OLzGXY OCHHA.4428@TK2M SFTNGP04.phx.gb l...
                    >>>>>Hi,
                    >>>>>>
                    >>>>>When writing database program with VB.NET that accesses MDB and XLS
                    >>>>>file, do you guys know if I still need to distribute MDAC and JET4 to
                    >>>>>the client machine?
                    >>>>>>
                    >>>>>Or .NET framework already comes with all those drivers?
                    >>>>>>
                    >>>>>Thanks!
                    >>>>>>
                    >>>>>>
                    >>>>>--
                    >>>>>>There is no answer.
                    >>>>>>There has not been an answer.
                    >>>>>>There will not be an answer.
                    >>>>>>That IS the answer!
                    >>>>>>And I am screwed.
                    >>>>>>Deadlin e was due yesterday.
                    >>>>>>>
                    >>>>>>There is no point to life.
                    >>>>>>THAT IS THE POINT.
                    >>>>>>And we are screwed.
                    >>>>>>We will run out of oil soon.
                    >>>>>>
                    >>>>>http://spaces.msn.com/bzDaCat
                    >>>>>>
                    >>>>>
                    >>>>>
                    >>>>
                    >>>>
                    >>>
                    >>>
                    >>
                    >>
                    >
                    >

                    Comment

                    • Michel Posseth  [MCP]

                      #11
                      Re: VB.NET and MDAC+JET


                      This is where you can find the latest jet oledb drivers ( servicepack 8 )




                      regards

                      Michel


                      "bz" <nospam@yahoo.c omschreef in bericht
                      news:%23rJ3WVbC HHA.4024@TK2MSF TNGP04.phx.gbl. ..
                      So, if I am using ADO.NET to open MDB or XLS files, I still need to
                      install JET4.
                      >
                      Got it. Thanks!
                      >
                      >
                      >
                      "Michel Posseth [MCP]" <MSDN@posseth.c omwrote in message
                      news:uzptl1aCHH A.3524@TK2MSFTN GP06.phx.gbl...
                      >Yes , you do need to make sure that it is installed on the target system
                      >before you start your program
                      >>
                      >regards
                      >>
                      >Michel posseth [MCP]
                      >>
                      >>
                      >"bz" <nospam@yahoo.c omschreef in bericht
                      >news:%23KkkhiP CHHA.4256@TK2MS FTNGP04.phx.gbl ...
                      >>So, I still need to install JET4 to access MDB and XLS files, do I?
                      >>>
                      >>>
                      >>>
                      >>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
                      >>news:euimhCPC HHA.1012@TK2MSF TNGP04.phx.gbl. ..
                      >>>Peter,
                      >>>>
                      >>>As far as I know are all the computers where Net can run on already
                      >>>with the proper MDAC installed.
                      >>>>
                      >>>Cor
                      >>>>
                      >>>"bz" <nospam@yahoo.c omschreef in bericht
                      >>>news:%23fimP yOCHHA.3396@TK2 MSFTNGP02.phx.g bl...
                      >>>>So, you are saying that I still need to install MDAC and JET to the
                      >>>>client machine if I want to access MDB and XLS files.
                      >>>>>
                      >>>>>
                      >>>>>
                      >>>>"Cor Ligthert [MVP]" <notmyfirstname @planet.nlwrote in message
                      >>>>news:OjS2so OCHHA.3600@TK2M SFTNGP06.phx.gb l...
                      >>>>>For BZ, the client need in my idea to have a proper license of
                      >>>>>office.
                      >>>>>>
                      >>>>>Jet is free and if you use AdoNet and when you use OleDB, than you
                      >>>>>don't need AFAIK nothing more.
                      >>>>>>
                      >>>>>Cor
                      >>>>>>
                      >>>>>"bz" <nospam@yahoo.c omschreef in bericht
                      >>>>>news:OLzGX YOCHHA.4428@TK2 MSFTNGP04.phx.g bl...
                      >>>>>>Hi,
                      >>>>>>>
                      >>>>>>When writing database program with VB.NET that accesses MDB and XLS
                      >>>>>>file, do you guys know if I still need to distribute MDAC and JET4
                      >>>>>>to the client machine?
                      >>>>>>>
                      >>>>>>Or .NET framework already comes with all those drivers?
                      >>>>>>>
                      >>>>>>Thanks!
                      >>>>>>>
                      >>>>>>>
                      >>>>>>--
                      >>>>>>>There is no answer.
                      >>>>>>>There has not been an answer.
                      >>>>>>>There will not be an answer.
                      >>>>>>>That IS the answer!
                      >>>>>>>And I am screwed.
                      >>>>>>>Deadli ne was due yesterday.
                      >>>>>>>>
                      >>>>>>>There is no point to life.
                      >>>>>>>THAT IS THE POINT.
                      >>>>>>>And we are screwed.
                      >>>>>>>We will run out of oil soon.
                      >>>>>>>
                      >>>>>>http://spaces.msn.com/bzDaCat
                      >>>>>>>
                      >>>>>>
                      >>>>>>
                      >>>>>
                      >>>>>
                      >>>>
                      >>>>
                      >>>
                      >>>
                      >>
                      >>
                      >
                      >

                      Comment

                      Working...