OleDbDataAdapter

  • Thread starter Thread starter db_from_mn
  • Start date Start date
D

db_from_mn

Could someone give me a clue why I get the following
failure when I try to configure an object of this type,
using the Data Adapter Configuration Wizard, using a
connection to an Access database?

Generated SELECT Statement:

IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Thanks in advance,
Dennis
 
Dennis,

Can you provide the Access data base, as well as the steps you selected
when using the Wizard? It could be any number of things, and the
information provided is not much to go on.
 
Hello Nicholas,
Thanks for the help.
I could send the database, but perhaps a few basic
comments would be in order. You might see a fundamental
issue with my approach.
My Access database consists of several tables. Of course
there are several relationships established between the
tables. In the final implementation, my database will
also include linked tables from another database, but my
problem exists without this condition.
In Visual Studio, I create a connection to the database,
by viewing the Server Explorer, right-clicking the Data
Connections Icon, adding the connection, and configuring
the Properties. I select the Microsoft JET 4.0 OLE DB
Provider, and I specify a path to my database.
Then, I create an OleDbDataAdapter, and go through the
setup wizard. When I use the Query Builder, and I add
more than one table, then I start getting errors. If I
only have one table, then I can create the Adapter, and a
corresponding data set, with no problem.
Does this shed any light?
By the way, I notice that if I add more than one table in
the Query Builder, the table relationships are incorrect.
I've manually fixed these, with no success. Should table
relationships be preserved in the Adapter/Connection?
Thanks again,
Dennis

-----Original Message-----
Dennis,

Can you provide the Access data base, as well as the steps you selected
when using the Wizard? It could be any number of things, and the
information provided is not much to go on.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Could someone give me a clue why I get the following
failure when I try to configure an object of this type,
using the Data Adapter Configuration Wizard, using a
connection to an Access database?

Generated SELECT Statement:

IErrorInfo.GetDescription failed with E_FAIL (0x80004005).

Thanks in advance,
Dennis
Click to expand...


.
Click to expand...
 
Dennis,

You still aren't being specific about *what* errors you are getting.
Also, it would help to have the actual database, as everything that you have
stated doesn't indicate that you are doing anything that should present a
problem, so my guess is that the Access database is corrupted in some way
perhaps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

db_from_mn said:
Hello Nicholas,
Thanks for the help.
I could send the database, but perhaps a few basic
comments would be in order. You might see a fundamental
issue with my approach.
My Access database consists of several tables. Of course
there are several relationships established between the
tables. In the final implementation, my database will
also include linked tables from another database, but my
problem exists without this condition.
In Visual Studio, I create a connection to the database,
by viewing the Server Explorer, right-clicking the Data
Connections Icon, adding the connection, and configuring
the Properties. I select the Microsoft JET 4.0 OLE DB
Provider, and I specify a path to my database.
Then, I create an OleDbDataAdapter, and go through the
setup wizard. When I use the Query Builder, and I add
more than one table, then I start getting errors. If I
only have one table, then I can create the Adapter, and a
corresponding data set, with no problem.
Does this shed any light?
By the way, I notice that if I add more than one table in
the Query Builder, the table relationships are incorrect.
I've manually fixed these, with no success. Should table
relationships be preserved in the Adapter/Connection?
Thanks again,
Dennis

-----Original Message-----
Dennis,

Can you provide the Access data base, as well as the steps you selected
when using the Wizard? It could be any number of things, and the
information provided is not much to go on.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Could someone give me a clue why I get the following
failure when I try to configure an object of this type,
using the Data Adapter Configuration Wizard, using a
connection to an Access database?

Generated SELECT Statement:

IErrorInfo.GetDescription failed with E_FAIL (0x80004005).

Thanks in advance,
Dennis
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top