Unable to create Dataset (HELLLLLLLLP! please)

  • Thread starter Thread starter Grumpy Aero Guy
  • Start date Start date
G

Grumpy Aero Guy

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.
 
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
 
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.
 
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
 
The .xsd file IS created.....

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

I just get the "something's wrong" message box after that...... ???
 
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
 
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.
 
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
 
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....
 
Grumpy said:
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....
Click to expand...
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 ']'.
 
Back
Top