Unable to create Dataset (HELLLLLLLLP! please)

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Grumpy Aero Guy

    Unable to create Dataset (HELLLLLLLLP! please)

    Visual Studio .net Academic Edition:

    After creating a OLEdbDataadapte r, followed by an OLE DB Connection (all of
    which occurs successfully, by the way), I am unable to create a Dataset.

    I consistently receive a dialogbox indicating that "there were errors
    creating the dataset, rebuild the solution, fix any errors and try again".

    Upon (re)building the solution, there are no errors thrown and the dataset
    can still NOT be created.

    I have tried:

    Reinstalling .net
    Uninstalling .net completly and REinstalling .net
    (framework---everything)---
    Reinstallation from the ground up following complete uninstall.
    Several Access 2003 databases (different ones...same .net error thrown)

    Problem remains........ ...

    Connecting to the same (simple Access 2003---Jet 4.0) databases on another
    installation occurs flawlessly. Albeit, the other attempt was NOT the
    academic version, but the professional version (worked fine)

    I'm outta ideas....

    Any wisdom out there? Thanks in advance.

    --


    Frank Bachman
    (Grumpy Aero Guy)



  • Cor Ligthert

    #2
    Re: Unable to create Dataset (HELLLLLLLLP! please)

    Grumpy,

    I assume that you are creating the dataset using the rightclick on the
    OleDbdataadapte r icon in the designer.

    The problem that I know what is the most in this is that there is some
    orphan code in the windows designer part

    You can look for that by pushing on the + in the windows designer part and
    see what if there is an orphaned dataset and delete that.

    I hope this helps.

    Cor


    Comment

    • Grumpy Aero Guy

      #3
      Re: Unable to create Dataset (HELLLLLLLLP! please)

      I have been playing with this for a while.....there are no orphaned
      datasets.....I think I may have stumbled across a bug or some anomaly unique
      to academic edition.

      I'm outta ideas.

      --


      Frank Bachman
      (Grumpy Aero Guy)


      "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
      news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...[color=blue]
      > Visual Studio .net Academic Edition:
      >
      > After creating a OLEdbDataadapte r, followed by an OLE DB Connection (all[/color]
      of[color=blue]
      > which occurs successfully, by the way), I am unable to create a Dataset.
      >
      > I consistently receive a dialogbox indicating that "there were errors
      > creating the dataset, rebuild the solution, fix any errors and try again".
      >
      > Upon (re)building the solution, there are no errors thrown and the dataset
      > can still NOT be created.
      >
      > I have tried:
      >
      > Reinstalling .net
      > Uninstalling .net completly and REinstalling .net
      > (framework---everything)---
      > Reinstallation from the ground up following complete uninstall.
      > Several Access 2003 databases (different ones...same .net error thrown)
      >
      > Problem remains........ ...
      >
      > Connecting to the same (simple Access 2003---Jet 4.0) databases on another
      > installation occurs flawlessly. Albeit, the other attempt was NOT the
      > academic version, but the professional version (worked fine)
      >
      > I'm outta ideas....
      >
      > Any wisdom out there? Thanks in advance.
      >
      > --
      >
      >
      > Frank Bachman
      > (Grumpy Aero Guy)
      >
      >
      >[/color]


      Comment

      • One Handed Man \( OHM - Terry Burns \)

        #4
        Re: Unable to create Dataset (HELLLLLLLLP! please)

        Does it create the XSD file FOR the DataSet, or not. If it does, does it NOT
        instantiate it ?




        --

        OHM ( Terry Burns )
        . . . One-Handed-Man . . .
        If U Need My Email ,Ask Me

        Time flies when you don't know what you're doing

        "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
        news:%23vR8bCgg EHA.3948@TK2MSF TNGP11.phx.gbl. ..[color=blue]
        > I have been playing with this for a while.....there are no orphaned
        > datasets.....I think I may have stumbled across a bug or some anomaly[/color]
        unique[color=blue]
        > to academic edition.
        >
        > I'm outta ideas.
        >
        > --
        >
        >
        > Frank Bachman
        > (Grumpy Aero Guy)
        >
        >
        > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
        > news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...[color=green]
        > > Visual Studio .net Academic Edition:
        > >
        > > After creating a OLEdbDataadapte r, followed by an OLE DB Connection (all[/color]
        > of[color=green]
        > > which occurs successfully, by the way), I am unable to create a Dataset.
        > >
        > > I consistently receive a dialogbox indicating that "there were errors
        > > creating the dataset, rebuild the solution, fix any errors and try[/color][/color]
        again".[color=blue][color=green]
        > >
        > > Upon (re)building the solution, there are no errors thrown and the[/color][/color]
        dataset[color=blue][color=green]
        > > can still NOT be created.
        > >
        > > I have tried:
        > >
        > > Reinstalling .net
        > > Uninstalling .net completly and REinstalling .net
        > > (framework---everything)---
        > > Reinstallation from the ground up following complete uninstall.
        > > Several Access 2003 databases (different ones...same .net error thrown)
        > >
        > > Problem remains........ ...
        > >
        > > Connecting to the same (simple Access 2003---Jet 4.0) databases on[/color][/color]
        another[color=blue][color=green]
        > > installation occurs flawlessly. Albeit, the other attempt was NOT the
        > > academic version, but the professional version (worked fine)
        > >
        > > I'm outta ideas....
        > >
        > > Any wisdom out there? Thanks in advance.
        > >
        > > --
        > >
        > >
        > > Frank Bachman
        > > (Grumpy Aero Guy)
        > >
        > >
        > >[/color]
        >
        >[/color]


        Comment

        • Grumpy Aero Guy

          #5
          Re: Unable to create Dataset (HELLLLLLLLP! please)

          The .xsd file IS created.....

          Is it instantiated... .BEATS ME.....

          I just get the "something' s wrong" message box after that...... ???

          --


          Frank Bachman
          (Grumpy Aero Guy)


          "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
          news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...[color=blue]
          > Visual Studio .net Academic Edition:
          >
          > After creating a OLEdbDataadapte r, followed by an OLE DB Connection (all[/color]
          of[color=blue]
          > which occurs successfully, by the way), I am unable to create a Dataset.
          >
          > I consistently receive a dialogbox indicating that "there were errors
          > creating the dataset, rebuild the solution, fix any errors and try again".
          >
          > Upon (re)building the solution, there are no errors thrown and the dataset
          > can still NOT be created.
          >
          > I have tried:
          >
          > Reinstalling .net
          > Uninstalling .net completly and REinstalling .net
          > (framework---everything)---
          > Reinstallation from the ground up following complete uninstall.
          > Several Access 2003 databases (different ones...same .net error thrown)
          >
          > Problem remains........ ...
          >
          > Connecting to the same (simple Access 2003---Jet 4.0) databases on another
          > installation occurs flawlessly. Albeit, the other attempt was NOT the
          > academic version, but the professional version (worked fine)
          >
          > I'm outta ideas....
          >
          > Any wisdom out there? Thanks in advance.
          >
          > --
          >
          >
          > Frank Bachman
          > (Grumpy Aero Guy)
          >
          >
          >[/color]


          Comment

          • One Handed Man \( OHM - Terry Burns \)

            #6
            Re: Unable to create Dataset (HELLLLLLLLP! please)

            Lets face it Frank, ur jinxed.



            --

            OHM ( Terry Burns )
            . . . One-Handed-Man . . .
            If U Need My Email ,Ask Me

            Time flies when you don't know what you're doing

            "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
            news:e45MALkgEH A.704@TK2MSFTNG P12.phx.gbl...[color=blue]
            > The .xsd file IS created.....
            >
            > Is it instantiated... .BEATS ME.....
            >
            > I just get the "something' s wrong" message box after that...... ???
            >
            > --
            >
            >
            > Frank Bachman
            > (Grumpy Aero Guy)
            >
            >
            > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
            > news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...[color=green]
            > > Visual Studio .net Academic Edition:
            > >
            > > After creating a OLEdbDataadapte r, followed by an OLE DB Connection (all[/color]
            > of[color=green]
            > > which occurs successfully, by the way), I am unable to create a Dataset.
            > >
            > > I consistently receive a dialogbox indicating that "there were errors
            > > creating the dataset, rebuild the solution, fix any errors and try[/color][/color]
            again".[color=blue][color=green]
            > >
            > > Upon (re)building the solution, there are no errors thrown and the[/color][/color]
            dataset[color=blue][color=green]
            > > can still NOT be created.
            > >
            > > I have tried:
            > >
            > > Reinstalling .net
            > > Uninstalling .net completly and REinstalling .net
            > > (framework---everything)---
            > > Reinstallation from the ground up following complete uninstall.
            > > Several Access 2003 databases (different ones...same .net error thrown)
            > >
            > > Problem remains........ ...
            > >
            > > Connecting to the same (simple Access 2003---Jet 4.0) databases on[/color][/color]
            another[color=blue][color=green]
            > > installation occurs flawlessly. Albeit, the other attempt was NOT the
            > > academic version, but the professional version (worked fine)
            > >
            > > I'm outta ideas....
            > >
            > > Any wisdom out there? Thanks in advance.
            > >
            > > --
            > >
            > >
            > > Frank Bachman
            > > (Grumpy Aero Guy)
            > >
            > >
            > >[/color]
            >
            >[/color]


            Comment

            • Grumpy Aero Guy

              #7
              Re: Unable to create Dataset (HELLLLLLLLP! please)

              You're right.......... .......

              I'm outta ideas..... Have no clue where to go from here. Maybe i'll call
              microshaft on monday and pay to get an answer/resolution.

              I teach VB, and it's a pain in the posterior not to be able to set up these
              db apps here at home prior to taking them to class.
              --


              Frank Bachman
              (Grumpy Aero Guy)


              "One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in message
              news:uxpih3qgEH A.2856@TK2MSFTN GP10.phx.gbl...[color=blue]
              > Lets face it Frank, ur jinxed.
              >
              >
              >
              > --
              >
              > OHM ( Terry Burns )
              > . . . One-Handed-Man . . .
              > If U Need My Email ,Ask Me
              >
              > Time flies when you don't know what you're doing
              >
              > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
              > news:e45MALkgEH A.704@TK2MSFTNG P12.phx.gbl...[color=green]
              > > The .xsd file IS created.....
              > >
              > > Is it instantiated... .BEATS ME.....
              > >
              > > I just get the "something' s wrong" message box after that...... ???
              > >
              > > --
              > >
              > >
              > > Frank Bachman
              > > (Grumpy Aero Guy)
              > >
              > >
              > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
              > > news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...[color=darkred]
              > > > Visual Studio .net Academic Edition:
              > > >
              > > > After creating a OLEdbDataadapte r, followed by an OLE DB Connection[/color][/color][/color]
              (all[color=blue][color=green]
              > > of[color=darkred]
              > > > which occurs successfully, by the way), I am unable to create a[/color][/color][/color]
              Dataset.[color=blue][color=green][color=darkred]
              > > >
              > > > I consistently receive a dialogbox indicating that "there were errors
              > > > creating the dataset, rebuild the solution, fix any errors and try[/color][/color]
              > again".[color=green][color=darkred]
              > > >
              > > > Upon (re)building the solution, there are no errors thrown and the[/color][/color]
              > dataset[color=green][color=darkred]
              > > > can still NOT be created.
              > > >
              > > > I have tried:
              > > >
              > > > Reinstalling .net
              > > > Uninstalling .net completly and REinstalling .net
              > > > (framework---everything)---
              > > > Reinstallation from the ground up following complete uninstall.
              > > > Several Access 2003 databases (different ones...same .net error[/color][/color][/color]
              thrown)[color=blue][color=green][color=darkred]
              > > >
              > > > Problem remains........ ...
              > > >
              > > > Connecting to the same (simple Access 2003---Jet 4.0) databases on[/color][/color]
              > another[color=green][color=darkred]
              > > > installation occurs flawlessly. Albeit, the other attempt was NOT the
              > > > academic version, but the professional version (worked fine)
              > > >
              > > > I'm outta ideas....
              > > >
              > > > Any wisdom out there? Thanks in advance.
              > > >
              > > > --
              > > >
              > > >
              > > > Frank Bachman
              > > > (Grumpy Aero Guy)
              > > >
              > > >
              > > >[/color]
              > >
              > >[/color]
              >
              >[/color]


              Comment

              • One Handed Man \( OHM - Terry Burns \)

                #8
                Re: Unable to create Dataset (HELLLLLLLLP! please)

                If u wanna post ur code, I'll try and run it here

                --

                OHM ( Terry Burns )
                . . . One-Handed-Man . . .
                If U Need My Email ,Ask Me

                Time flies when you don't know what you're doing

                "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                news:eDMkYbsgEH A.2468@TK2MSFTN GP12.phx.gbl...[color=blue]
                > You're right.......... .......
                >
                > I'm outta ideas..... Have no clue where to go from here. Maybe i'll call
                > microshaft on monday and pay to get an answer/resolution.
                >
                > I teach VB, and it's a pain in the posterior not to be able to set up[/color]
                these[color=blue]
                > db apps here at home prior to taking them to class.
                > --
                >
                >
                > Frank Bachman
                > (Grumpy Aero Guy)
                >
                >
                > "One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in[/color]
                message[color=blue]
                > news:uxpih3qgEH A.2856@TK2MSFTN GP10.phx.gbl...[color=green]
                > > Lets face it Frank, ur jinxed.
                > >
                > >
                > >
                > > --
                > >
                > > OHM ( Terry Burns )
                > > . . . One-Handed-Man . . .
                > > If U Need My Email ,Ask Me
                > >
                > > Time flies when you don't know what you're doing
                > >
                > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                > > news:e45MALkgEH A.704@TK2MSFTNG P12.phx.gbl...[color=darkred]
                > > > The .xsd file IS created.....
                > > >
                > > > Is it instantiated... .BEATS ME.....
                > > >
                > > > I just get the "something' s wrong" message box after that...... ???
                > > >
                > > > --
                > > >
                > > >
                > > > Frank Bachman
                > > > (Grumpy Aero Guy)
                > > >
                > > >
                > > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                > > > news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...
                > > > > Visual Studio .net Academic Edition:
                > > > >
                > > > > After creating a OLEdbDataadapte r, followed by an OLE DB Connection[/color][/color]
                > (all[color=green][color=darkred]
                > > > of
                > > > > which occurs successfully, by the way), I am unable to create a[/color][/color]
                > Dataset.[color=green][color=darkred]
                > > > >
                > > > > I consistently receive a dialogbox indicating that "there were[/color][/color][/color]
                errors[color=blue][color=green][color=darkred]
                > > > > creating the dataset, rebuild the solution, fix any errors and try[/color]
                > > again".[color=darkred]
                > > > >
                > > > > Upon (re)building the solution, there are no errors thrown and the[/color]
                > > dataset[color=darkred]
                > > > > can still NOT be created.
                > > > >
                > > > > I have tried:
                > > > >
                > > > > Reinstalling .net
                > > > > Uninstalling .net completly and REinstalling .net
                > > > > (framework---everything)---
                > > > > Reinstallation from the ground up following complete uninstall.
                > > > > Several Access 2003 databases (different ones...same .net error[/color][/color]
                > thrown)[color=green][color=darkred]
                > > > >
                > > > > Problem remains........ ...
                > > > >
                > > > > Connecting to the same (simple Access 2003---Jet 4.0) databases on[/color]
                > > another[color=darkred]
                > > > > installation occurs flawlessly. Albeit, the other attempt was NOT[/color][/color][/color]
                the[color=blue][color=green][color=darkred]
                > > > > academic version, but the professional version (worked fine)
                > > > >
                > > > > I'm outta ideas....
                > > > >
                > > > > Any wisdom out there? Thanks in advance.
                > > > >
                > > > > --
                > > > >
                > > > >
                > > > > Frank Bachman
                > > > > (Grumpy Aero Guy)
                > > > >
                > > > >
                > > > >
                > > >
                > > >[/color]
                > >
                > >[/color]
                >
                >[/color]


                Comment

                • Grumpy Aero Guy

                  #9
                  Re: Unable to create Dataset (HELLLLLLLLP! please)

                  No code to post.......

                  New Project..
                  Windows App...
                  (Make/find Access 2004 Database (1 table with example records))
                  Set up oledbdataadapte r pointing to the (Jet 4.0) Access Database
                  Use query builder to select all records in the one table in the
                  database
                  Make/Create oledbconnection
                  Click/Activate oledbdataadapte r
                  In property window, click "generate dataset" hyperlink

                  Read Error message in dialogbox....

                  that's it....



                  --


                  Frank Bachman
                  (Grumpy Aero Guy)


                  "One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in message
                  news:%23IB9pGtg EHA.3536@TK2MSF TNGP12.phx.gbl. ..[color=blue]
                  > If u wanna post ur code, I'll try and run it here
                  >
                  > --
                  >
                  > OHM ( Terry Burns )
                  > . . . One-Handed-Man . . .
                  > If U Need My Email ,Ask Me
                  >
                  > Time flies when you don't know what you're doing
                  >
                  > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                  > news:eDMkYbsgEH A.2468@TK2MSFTN GP12.phx.gbl...[color=green]
                  > > You're right.......... .......
                  > >
                  > > I'm outta ideas..... Have no clue where to go from here. Maybe i'll call
                  > > microshaft on monday and pay to get an answer/resolution.
                  > >
                  > > I teach VB, and it's a pain in the posterior not to be able to set up[/color]
                  > these[color=green]
                  > > db apps here at home prior to taking them to class.
                  > > --
                  > >
                  > >
                  > > Frank Bachman
                  > > (Grumpy Aero Guy)
                  > >
                  > >
                  > > "One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in[/color]
                  > message[color=green]
                  > > news:uxpih3qgEH A.2856@TK2MSFTN GP10.phx.gbl...[color=darkred]
                  > > > Lets face it Frank, ur jinxed.
                  > > >
                  > > >
                  > > >
                  > > > --
                  > > >
                  > > > OHM ( Terry Burns )
                  > > > . . . One-Handed-Man . . .
                  > > > If U Need My Email ,Ask Me
                  > > >
                  > > > Time flies when you don't know what you're doing
                  > > >
                  > > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                  > > > news:e45MALkgEH A.704@TK2MSFTNG P12.phx.gbl...
                  > > > > The .xsd file IS created.....
                  > > > >
                  > > > > Is it instantiated... .BEATS ME.....
                  > > > >
                  > > > > I just get the "something' s wrong" message box after that...... ???
                  > > > >
                  > > > > --
                  > > > >
                  > > > >
                  > > > > Frank Bachman
                  > > > > (Grumpy Aero Guy)
                  > > > >
                  > > > >
                  > > > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                  > > > > news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...
                  > > > > > Visual Studio .net Academic Edition:
                  > > > > >
                  > > > > > After creating a OLEdbDataadapte r, followed by an OLE DB[/color][/color][/color]
                  Connection[color=blue][color=green]
                  > > (all[color=darkred]
                  > > > > of
                  > > > > > which occurs successfully, by the way), I am unable to create a[/color]
                  > > Dataset.[color=darkred]
                  > > > > >
                  > > > > > I consistently receive a dialogbox indicating that "there were[/color][/color]
                  > errors[color=green][color=darkred]
                  > > > > > creating the dataset, rebuild the solution, fix any errors and try
                  > > > again".
                  > > > > >
                  > > > > > Upon (re)building the solution, there are no errors thrown and the
                  > > > dataset
                  > > > > > can still NOT be created.
                  > > > > >
                  > > > > > I have tried:
                  > > > > >
                  > > > > > Reinstalling .net
                  > > > > > Uninstalling .net completly and REinstalling .net
                  > > > > > (framework---everything)---
                  > > > > > Reinstallation from the ground up following complete uninstall.
                  > > > > > Several Access 2003 databases (different ones...same .net error[/color]
                  > > thrown)[color=darkred]
                  > > > > >
                  > > > > > Problem remains........ ...
                  > > > > >
                  > > > > > Connecting to the same (simple Access 2003---Jet 4.0) databases on
                  > > > another
                  > > > > > installation occurs flawlessly. Albeit, the other attempt was NOT[/color][/color]
                  > the[color=green][color=darkred]
                  > > > > > academic version, but the professional version (worked fine)
                  > > > > >
                  > > > > > I'm outta ideas....
                  > > > > >
                  > > > > > Any wisdom out there? Thanks in advance.
                  > > > > >
                  > > > > > --
                  > > > > >
                  > > > > >
                  > > > > > Frank Bachman
                  > > > > > (Grumpy Aero Guy)
                  > > > > >
                  > > > > >
                  > > > > >
                  > > > >
                  > > > >
                  > > >
                  > > >[/color]
                  > >
                  > >[/color]
                  >
                  >[/color]


                  Comment

                  • Grumpy Aero Guy

                    #10
                    Re: Unable to create Dataset (HELLLLLLLLP! please)

                    BTW....

                    Thanks for your help and hanging in there......

                    --


                    Frank Bachman
                    (Grumpy Aero Guy)


                    "One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in message
                    news:%23IB9pGtg EHA.3536@TK2MSF TNGP12.phx.gbl. ..[color=blue]
                    > If u wanna post ur code, I'll try and run it here
                    >
                    > --
                    >
                    > OHM ( Terry Burns )
                    > . . . One-Handed-Man . . .
                    > If U Need My Email ,Ask Me
                    >
                    > Time flies when you don't know what you're doing
                    >
                    > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                    > news:eDMkYbsgEH A.2468@TK2MSFTN GP12.phx.gbl...[color=green]
                    > > You're right.......... .......
                    > >
                    > > I'm outta ideas..... Have no clue where to go from here. Maybe i'll call
                    > > microshaft on monday and pay to get an answer/resolution.
                    > >
                    > > I teach VB, and it's a pain in the posterior not to be able to set up[/color]
                    > these[color=green]
                    > > db apps here at home prior to taking them to class.
                    > > --
                    > >
                    > >
                    > > Frank Bachman
                    > > (Grumpy Aero Guy)
                    > >
                    > >
                    > > "One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> wrote in[/color]
                    > message[color=green]
                    > > news:uxpih3qgEH A.2856@TK2MSFTN GP10.phx.gbl...[color=darkred]
                    > > > Lets face it Frank, ur jinxed.
                    > > >
                    > > >
                    > > >
                    > > > --
                    > > >
                    > > > OHM ( Terry Burns )
                    > > > . . . One-Handed-Man . . .
                    > > > If U Need My Email ,Ask Me
                    > > >
                    > > > Time flies when you don't know what you're doing
                    > > >
                    > > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                    > > > news:e45MALkgEH A.704@TK2MSFTNG P12.phx.gbl...
                    > > > > The .xsd file IS created.....
                    > > > >
                    > > > > Is it instantiated... .BEATS ME.....
                    > > > >
                    > > > > I just get the "something' s wrong" message box after that...... ???
                    > > > >
                    > > > > --
                    > > > >
                    > > > >
                    > > > > Frank Bachman
                    > > > > (Grumpy Aero Guy)
                    > > > >
                    > > > >
                    > > > > "Grumpy Aero Guy" <fbachman@beer_ me.com> wrote in message
                    > > > > news:eEBw9HagEH A.4092@TK2MSFTN GP10.phx.gbl...
                    > > > > > Visual Studio .net Academic Edition:
                    > > > > >
                    > > > > > After creating a OLEdbDataadapte r, followed by an OLE DB[/color][/color][/color]
                    Connection[color=blue][color=green]
                    > > (all[color=darkred]
                    > > > > of
                    > > > > > which occurs successfully, by the way), I am unable to create a[/color]
                    > > Dataset.[color=darkred]
                    > > > > >
                    > > > > > I consistently receive a dialogbox indicating that "there were[/color][/color]
                    > errors[color=green][color=darkred]
                    > > > > > creating the dataset, rebuild the solution, fix any errors and try
                    > > > again".
                    > > > > >
                    > > > > > Upon (re)building the solution, there are no errors thrown and the
                    > > > dataset
                    > > > > > can still NOT be created.
                    > > > > >
                    > > > > > I have tried:
                    > > > > >
                    > > > > > Reinstalling .net
                    > > > > > Uninstalling .net completly and REinstalling .net
                    > > > > > (framework---everything)---
                    > > > > > Reinstallation from the ground up following complete uninstall.
                    > > > > > Several Access 2003 databases (different ones...same .net error[/color]
                    > > thrown)[color=darkred]
                    > > > > >
                    > > > > > Problem remains........ ...
                    > > > > >
                    > > > > > Connecting to the same (simple Access 2003---Jet 4.0) databases on
                    > > > another
                    > > > > > installation occurs flawlessly. Albeit, the other attempt was NOT[/color][/color]
                    > the[color=green][color=darkred]
                    > > > > > academic version, but the professional version (worked fine)
                    > > > > >
                    > > > > > I'm outta ideas....
                    > > > > >
                    > > > > > Any wisdom out there? Thanks in advance.
                    > > > > >
                    > > > > > --
                    > > > > >
                    > > > > >
                    > > > > > Frank Bachman
                    > > > > > (Grumpy Aero Guy)
                    > > > > >
                    > > > > >
                    > > > > >
                    > > > >
                    > > > >
                    > > >
                    > > >[/color]
                    > >
                    > >[/color]
                    >
                    >[/color]


                    Comment

                    • Codo

                      #11
                      Re: Unable to create Dataset (HELLLLLLLLP! please)

                      Grumpy Aero Guy wrote:
                      [color=blue]
                      > No code to post.......
                      >
                      > New Project..
                      > Windows App...
                      > (Make/find Access 2004 Database (1 table with example records))
                      > Set up oledbdataadapte r pointing to the (Jet 4.0) Access Database
                      > Use query builder to select all records in the one table in the
                      > database
                      > Make/Create oledbconnection
                      > Click/Activate oledbdataadapte r
                      > In property window, click "generate dataset" hyperlink
                      >
                      > Read Error message in dialogbox....
                      >
                      > that's it....
                      >
                      >
                      >[/color]
                      Post your schema. The dataadapters/dataset creation in VStudio has some
                      bugs. I wouldnbe surprised youe falling into some of this. Make sure
                      you're not using reserved words in your field names. enclose them with '['
                      and ']'.

                      Comment

                      Working...