Hi Shimon,
Try to change the SQL statement
FROM
Select * From Table
TO
Select field1, field2, field3 From Table
If it works, this problem may be related to a certain field in the table.
Also, try to create a query in the Access database. The query has same SQL
statement as the code. Does the same problem occur?
Sincerely,
Kevin
Microsoft Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! -
www.microsoft.com/security
--------------------
| From: "(E-Mail Removed)" <(E-Mail Removed)>
| References: <(E-Mail Removed)>
<(E-Mail Removed)>
| Subject: Re: ADO.NET and access
| Date: Tue, 15 Jul 2003 22:40:30 -0400
| Lines: 70
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uaO#(E-Mail Removed)>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: 127.newark-05rh16rt.nj.dial-access.att.net
12.89.169.127
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:55800
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| It seems to me that it is problem with database. I tried to do similar
tasks
| with other databases and it seems to be ok. Or if there were problems
there
| were easy to track. But it this case I just don't know were to start. I am
| doing C# Windows application. and I try to get through OleDbAdapter
wizard.
| But after I specify query (it is were simple: Select * From Table) it
gives
| me an error. IErrorInfo .Description E_FAIL . I have three tables and I am
| creating 3 adaptors on one form. The error always appear on the same
tables
| and the order I am adding adapters doesn't make a difference. The 2
tables
| in the beginning were child tables (had foreign key) after I removed them
| (and upgraded to Pack 7 so I am not sure what did it. May be upgrade) I
| managed to configure adapters but I cam not create Dataset base on this
| information. the system troughs me the same exception. And application
| doen't run if I just use uptyped Dataset again the same exception. I tried
| to do the same action on othe database (wasn't created by me) and it seems
| to work. I compared DBs - do not see anything that would make my app fail.
| Thanks
| Shimon
|
|
| "Kevin Sun [MS]" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
| > We need to narrow down this problem as below:
| >
| > 1. Identify whether or not this problem is related to the Access
databse.
| > You can test this in a new database or Northwind sample database.
| >
| > 2. Identify whether or not this problem is related to the ADO.NET code.
| You
| > can show us the code snippet, especially, let us know which line of code
| > fails.
| >
| >
| > Sincerely,
| >
| > Kevin
| > Microsoft Support
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| > Get Secure! -
www.microsoft.com/security
| >
| > --------------------
| > | From: "(E-Mail Removed)" <(E-Mail Removed)>
| > | Subject: ADO.NET and access
| > | Date: Mon, 14 Jul 2003 09:07:11 -0400
| > | Lines: 5
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <(E-Mail Removed)>
| > | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | NNTP-Posting-Host: 217.piscataway-06rh15rt.nj.dial-access.att.net
| > 12.89.74.217
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.framework.adonet:55615
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > |
| > | I get E_FAIL erreo when I try to retreave dataset info for some tables
| in
| > my
| > | access database. does anyone know why?
| > | Thanks, Shimon.
| > |
| > |
| > |
| >
|
|
|
Similar Threads
