473,287 Members | 1,613 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Unable to create Dataset (HELLLLLLLLP! please)

Visual Studio .net Academic Edition:

After creating a OLEdbDataadapter, 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)

Nov 21 '05 #1
10 1522
Grumpy,

I assume that you are creating the dataset using the rightclick on the
OleDbdataadapter 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
Nov 21 '05 #2
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:eE**************@TK2MSFTNGP10.phx.gbl...
Visual Studio .net Academic Edition:

After creating a OLEdbDataadapter, 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)

Nov 21 '05 #3
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:%2****************@TK2MSFTNGP11.phx.gbl...
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:eE**************@TK2MSFTNGP10.phx.gbl...
Visual Studio .net Academic Edition:

After creating a OLEdbDataadapter, 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)


Nov 21 '05 #4
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:eE**************@TK2MSFTNGP10.phx.gbl...
Visual Studio .net Academic Edition:

After creating a OLEdbDataadapter, 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)

Nov 21 '05 #5
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:e4*************@TK2MSFTNGP12.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:eE**************@TK2MSFTNGP10.phx.gbl...
Visual Studio .net Academic Edition:

After creating a OLEdbDataadapter, 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)


Nov 21 '05 #6
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:ux**************@TK2MSFTNGP10.phx.gbl...
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:e4*************@TK2MSFTNGP12.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:eE**************@TK2MSFTNGP10.phx.gbl...
Visual Studio .net Academic Edition:

After creating a OLEdbDataadapter, 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)



Nov 21 '05 #7
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:eD**************@TK2MSFTNGP12.phx.gbl...
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:ux**************@TK2MSFTNGP10.phx.gbl...
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:e4*************@TK2MSFTNGP12.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:eE**************@TK2MSFTNGP10.phx.gbl...
> Visual Studio .net Academic Edition:
>
> After creating a OLEdbDataadapter, 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)
>
>
>



Nov 21 '05 #8
No code to post.......

New Project..
Windows App...
(Make/find Access 2004 Database (1 table with example records))
Set up oledbdataadapter 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 oledbdataadapter
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:%2****************@TK2MSFTNGP12.phx.gbl...
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:eD**************@TK2MSFTNGP12.phx.gbl...
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:ux**************@TK2MSFTNGP10.phx.gbl...
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:e4*************@TK2MSFTNGP12.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:eE**************@TK2MSFTNGP10.phx.gbl...
> > Visual Studio .net Academic Edition:
> >
> > After creating a OLEdbDataadapter, 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)
> >
> >
> >
>
>



Nov 21 '05 #9
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:%2****************@TK2MSFTNGP12.phx.gbl...
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:eD**************@TK2MSFTNGP12.phx.gbl...
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:ux**************@TK2MSFTNGP10.phx.gbl...
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:e4*************@TK2MSFTNGP12.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:eE**************@TK2MSFTNGP10.phx.gbl...
> > Visual Studio .net Academic Edition:
> >
> > After creating a OLEdbDataadapter, 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)
> >
> >
> >
>
>



Nov 21 '05 #10
Grumpy Aero Guy wrote:
No code to post.......

New Project..
Windows App...
(Make/find Access 2004 Database (1 table with example records))
Set up oledbdataadapter 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 oledbdataadapter
In property window, click "generate dataset" hyperlink

Read Error message in dialogbox....

that's it....

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 ']'.
Nov 21 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: pei_world | last post by:
the following codes are error occurs. basically, I set a breakpoint at BuildingTN, I trace it, and it come up my intended table, but when I run the program, in my component cobInside, it always...
2
by: Calvin KD | last post by:
Hi everyone, I know the solution to my problem is probably very simple but I just can't seem to figure out how to do it. My problem is, I have an XML file as a datastore, I read it into a dataset...
8
by: ssdangelo | last post by:
Dear Sir - I have spent several days (p/t) trying to create a Dataset using V.B. Net on my Laptop Sony. I have tried using both a Access and a SQL Server database and the same problem occurs. I...
1
by: yopy | last post by:
i have developed a web service which return dataset on dev machine, when i invoke the web service from the same machine it works fine, but when i deploy the web service to another machine, and...
1
by: ad | last post by:
I use vs2005. I wnat to create a dataset in design time. I have a connection string in web.config. At the first step of DataAdapter wizard, it prompt me to enter a new connection, At the last...
3
by: irnbru irnbru | last post by:
Hi I am learning ADO.NET, I use DOTNET 2003, I wanted to know when you create a dataset objet and fill it with data from Data Base with DataAdapter fill method, the fill method only creates a...
4
by: Lee Moore | last post by:
I am trying to develop a threaded function to create a dataset from an Oracle database. When querying an elaborate view, queries take a while. I would like to place and animated wait dialog up...
4
by: Abby | last post by:
Hi all, I have a datagrid which i am using for updating the data to the database. It works fine for single row data however when i have multiple rows(records) associated with the same...
1
by: donet programmer | last post by:
I have a requirement where I need to create a dataset that consists of a table inside a table ( a child table inside a parent table). I am not really familiar with the data relations and not sure...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.