ADO.NET in VB6

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vul
    #1

    ADO.NET in VB6

    May ADO.NET be used in VB6 ?
    I'm not asking about using it in DLL created in VB.NET or C# and then DLL is
    used in VB6. I'm asking about direct using.
    I need some of ADO.NET features, which are not available in a traditional
    ADO, and I need them in VB6 project.

    Thank you
    Al


    Tags: None
    • Shawn Wildermuth (C# MVP)
      #2
      Re: ADO.NET in VB6

      Hello vul,

      Unfortunately no. You could wrap ADO.NET in a COM wrapper, but that would
      be a nightmare. WHat features? Perhaps there is an ADO way of doing what
      you need...


      Thanks,
      Shawn Wildermuth
      Speaker, Author and C# MVP
      http://adoguy.com

      May ADO.NET be used in VB6 ?
      I'm not asking about using it in DLL created in VB.NET or C# and then
      DLL is
      used in VB6. I'm asking about direct using.
      I need some of ADO.NET features, which are not available in a
      traditional
      ADO, and I need them in VB6 project.
      Thank you
      Al

        Comment

        • vul
          #3
          Re: ADO.NET in VB6

          I have 10 ADO recordsets in VB6 program. All of them should be edited on
          Pocket PC, then edited data should be returned into SQL Server.
          It looks like pretty easy task via :
          1. create ADO.Net dataset, containing all those data,
          2. save it as a single XML file,
          3. sending to Pocket PC user,
          4. User makes changes via VB 2005 program and saves them
          5. Send updated XML back
          6. Populate ado.net dataset by opening XML
          7. Save data back to SQL

          With a standard ADO I do not see such an easy solution. There are some other
          problems with creating DLL in VB 2005 working with VB 6, but I already
          almost did that part. Maybe I'll meet some other problems

          Al


          "Shawn Wildermuth (C# MVP)" <swildermuth@ne wsgroup.nospamw rote in message
          news:fc24ddbd10 31c8c878c492c9f 7ac@msnews.micr osoft.com...
          Hello vul,
          >
          Unfortunately no. You could wrap ADO.NET in a COM wrapper, but that would
          be a nightmare. WHat features? Perhaps there is an ADO way of doing what
          you need...
          >
          >
          Thanks,
          Shawn Wildermuth
          Speaker, Author and C# MVP
          http://adoguy.com

          >
          >May ADO.NET be used in VB6 ?
          >I'm not asking about using it in DLL created in VB.NET or C# and then
          >DLL is
          >used in VB6. I'm asking about direct using.
          >I need some of ADO.NET features, which are not available in a
          >traditional
          >ADO, and I need them in VB6 project.
          >Thank you
          >Al
          >
          >

            Comment

            • Cor Ligthert [MVP]
              #4
              Re: ADO.NET in VB6

              Al,

              As you ask the question than the answer is simple "No"

              Cor

              "vul" <aaa@optonline. netschreef in bericht
              news:OJHgKqsqGH A.2464@TK2MSFTN GP03.phx.gbl...
              May ADO.NET be used in VB6 ?
              I'm not asking about using it in DLL created in VB.NET or C# and then DLL
              is used in VB6. I'm asking about direct using.
              I need some of ADO.NET features, which are not available in a traditional
              ADO, and I need them in VB6 project.
              >
              Thank you
              Al
              >

                Comment

                • Steven Nagy
                  #5
                  Re: ADO.NET in VB6

                  I'm not asking about using it in DLL created in VB.NET or C# and then DLL is
                  used in VB6.
                  Actually, yes you are. ADO.NET is a DLL called System.Data.dll and a
                  few other dlls.

                  As Cor says, the answer is NO.

                  However, if you want to use ADO.NET, then you would need the .NET
                  framework on the PC, in which case, why not do it all in .NET?

                  Otherwise, just stick to your plan from before, except use VB6 to parse
                  the returned XML and reconstruct it. Or write your own EXE in .NET that
                  accepts the XML, and returns an ADO recordset. Then continue on with
                  your VB6 app.

                    Comment

                    • Marina Levit [MVP]
                      #6
                      Re: ADO.NET in VB6

                      I think it would be easier from VB6 to just manipulate the XML document.

                      "vul" <aaa@optonline. netwrote in message
                      news:%23xLLDJtq GHA.956@TK2MSFT NGP03.phx.gbl.. .
                      >I have 10 ADO recordsets in VB6 program. All of them should be edited on
                      >Pocket PC, then edited data should be returned into SQL Server.
                      It looks like pretty easy task via :
                      1. create ADO.Net dataset, containing all those data,
                      2. save it as a single XML file,
                      3. sending to Pocket PC user,
                      4. User makes changes via VB 2005 program and saves them
                      5. Send updated XML back
                      6. Populate ado.net dataset by opening XML
                      7. Save data back to SQL
                      >
                      With a standard ADO I do not see such an easy solution. There are some
                      other problems with creating DLL in VB 2005 working with VB 6, but I
                      already almost did that part. Maybe I'll meet some other problems
                      >
                      Al
                      >
                      >
                      "Shawn Wildermuth (C# MVP)" <swildermuth@ne wsgroup.nospamw rote in
                      message news:fc24ddbd10 31c8c878c492c9f 7ac@msnews.micr osoft.com...
                      >Hello vul,
                      >>
                      >Unfortunatel y no. You could wrap ADO.NET in a COM wrapper, but that
                      >would be a nightmare. WHat features? Perhaps there is an ADO way of
                      >doing what you need...
                      >>
                      >>
                      >Thanks,
                      >Shawn Wildermuth
                      >Speaker, Author and C# MVP
                      >http://adoguy.com
                      >>
                      >>May ADO.NET be used in VB6 ?
                      >>I'm not asking about using it in DLL created in VB.NET or C# and then
                      >>DLL is
                      >>used in VB6. I'm asking about direct using.
                      >>I need some of ADO.NET features, which are not available in a
                      >>traditional
                      >>ADO, and I need them in VB6 project.
                      >>Thank you
                      >>Al
                      >>
                      >>
                      >
                      >

                        Comment

                        • Earl
                          #7
                          Re: ADO.NET in VB6

                          If you are using SQL Server for the backend, why make the end run around
                          merge replication? Let the server do all the heavy lifting. It takes about a
                          page of code to set up merge on the PocketPC.

                          "vul" <aaa@optonline. netwrote in message
                          news:%23xLLDJtq GHA.956@TK2MSFT NGP03.phx.gbl.. .
                          >I have 10 ADO recordsets in VB6 program. All of them should be edited on
                          >Pocket PC, then edited data should be returned into SQL Server.
                          It looks like pretty easy task via :
                          1. create ADO.Net dataset, containing all those data,
                          2. save it as a single XML file,
                          3. sending to Pocket PC user,
                          4. User makes changes via VB 2005 program and saves them
                          5. Send updated XML back
                          6. Populate ado.net dataset by opening XML
                          7. Save data back to SQL
                          >
                          With a standard ADO I do not see such an easy solution. There are some
                          other problems with creating DLL in VB 2005 working with VB 6, but I
                          already almost did that part. Maybe I'll meet some other problems
                          >
                          Al
                          >
                          >
                          "Shawn Wildermuth (C# MVP)" <swildermuth@ne wsgroup.nospamw rote in
                          message news:fc24ddbd10 31c8c878c492c9f 7ac@msnews.micr osoft.com...
                          >Hello vul,
                          >>
                          >Unfortunatel y no. You could wrap ADO.NET in a COM wrapper, but that
                          >would be a nightmare. WHat features? Perhaps there is an ADO way of
                          >doing what you need...
                          >>
                          >>
                          >Thanks,
                          >Shawn Wildermuth
                          >Speaker, Author and C# MVP
                          >http://adoguy.com
                          >>
                          >>May ADO.NET be used in VB6 ?
                          >>I'm not asking about using it in DLL created in VB.NET or C# and then
                          >>DLL is
                          >>used in VB6. I'm asking about direct using.
                          >>I need some of ADO.NET features, which are not available in a
                          >>traditional
                          >>ADO, and I need them in VB6 project.
                          >>Thank you
                          >>Al
                          >>
                          >>
                          >
                          >

                            Comment

                            Previous template Next
                            Working...