S
shimonsim
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.
access database. does anyone know why?
Thanks, Shimon.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin Sun [MS]
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 address removed)" <[email protected]>
| 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: <[email protected]>
| 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.
|
|
|
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 address removed)" <[email protected]>
| 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: <[email protected]>
| 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.
|
|
|
S
shimonsim
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
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
K
Kevin Sun [MS]
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 address removed)" <[email protected]>
| References: <[email protected]>
<[email protected]>
| 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#[email protected]>
| 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
|
|
| | > 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 address removed)" <[email protected]>
| > | 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: <[email protected]>
| > | 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.
| > |
| > |
| > |
| >
|
|
|
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 address removed)" <[email protected]>
| References: <[email protected]>
<[email protected]>
| 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#[email protected]>
| 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
|
|
| | > 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 address removed)" <[email protected]>
| > | 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: <[email protected]>
| > | 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.
| > |
| > |
| > |
| >
|
|
|