We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Error in DataAdapter

Thread ID:

Created:

Updated:

Platform:

Replies:

324 Jun 3,2002 09:39 AM UTC Aug 11,2003 11:58 AM UTC Windows Forms 6
loading
Tags: FAQ
jolly
Asked On June 3, 2002 09:39 AM UTC

I have already created several data adapters and I haven't had any problems. I dragged another data adapter (WorkDataAdapter), configure it to point to my db and it's fine. Then when I try to generate the dataset for the WorkDataAdapter, I get this error corresponding to the new data adapter i added. "Retrieving the schema for WorkDataAdapter failed" Unspecified Error: E_fail (0X80004005)! What does this mean? Pls. help. I know that it has nothing to do with my database b/c i only have four fields with two primary keys.

Automatichawk
Replied On October 2, 2002 06:44 PM UTC

> I have already created several data adapters and I haven't had any problems. I dragged another data adapter (WorkDataAdapter), configure it to point to my db and it's fine. Then when I try to generate the dataset for the WorkDataAdapter, I get this error corresponding to the new data adapter i added. "Retrieving the schema for WorkDataAdapter failed" Unspecified Error: E_fail (0X80004005)! What does this mean? Pls. help. I know that it has nothing to do with my database b/c i only have four fields with two primary keys.

Automatichawk
Replied On October 2, 2002 06:48 PM UTC

I'm having the same problem I think we have too many data adapters, but I too only know a little.

Administrator [Syncfusion]
Replied On October 18, 2002 01:41 PM UTC

Check the names of the fields in your database tables. I had a field named "Usage" and I was getting the same error. I changed the name to "Usag" and it worked fine. I'm not sure if this will work for you or not, but it might.

Jima
Replied On June 19, 2003 11:41 AM UTC

You may also close all the fiels names within the SQL statement into [] like [tableName.fieldName] instead of renaming the fields.

senthil
Replied On July 8, 2003 11:50 AM UTC

Avoid using reserved names like 'date', 'day', 'time', even 'Language' as column names in the database. It seems that these words can only used my microsoft, and not others.

Victor Wynnytsky
Replied On August 11, 2003 11:58 AM UTC

THANK YOU AUTOHAWK you alone bailed me out I had to add another "data" project to my solution because I hit some limit on the number of adapters (probably 255) allowed in a project. Thank god it's not a solution limit. > I'm having the same problem I think we have too many data adapters, but I too only know a little.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;