Hopefully someone can help me in here, the problem is with access 2003, and using an OleDBDataAdapter.

I set my Provider as "M.S Jet 4.0..." and when i press test connection it says connection established.

On the query type screen i have "Use sql statement selected" as thats the only one that will let me choose.

NOw in the generate SQL Statement i choose "query builder" and select the table i want to use (the DB has only got one table and thats the one i am using) so i select all and my query is like

SELECT
    Names.*
FROM
    Names
when i press the screen says:

Generated SELECT statement
Unspecified error: E_FAIL (0*80004005).

So can someone tell me what i am doing wrong please.

Thanks

Plz post ur code! all stories r teh same here.
ur problem is in Code! Where do u get error & what is it?!

Always:),
Hovik Melkomian.

There is no code, what i am trying to do is basically set up a connection using OleDBDataAdapter.

let me check ur steps again:
1_ u creat an Connection & its ok!
2_ u add a DataAdapter, set its connection to Okeyed Coonnection & then use query builder to create ur SELECT.

u use Visual Stedio's Wizards & u get error?!?!
dear friend, be sure Computers r much stupid than us but they do their assigned jobs PERFECT & greatly.
So I suggest to check ur all steps (even drop all & go again)
u should be wrong in a step.

Keep it touch.

Always:),
Hovik Melkomian.

Hello
Well i figured out the problem, everything i was doing was totally correct, but i had to download the latest MS Jet 4.0 Service Pack 8.

But thats anyways for the help.