wait3264
asked on
Invalid column name error
I am having a problem with an error message.
When I try to drag the last name field from the table under Cottages(this is the name of the database on SQL Server from MSDE it was taken from a student files disk), I get an error message:
Data Adapter Configuration Error
The wizard detected the following problems when configuring the data adapter for "Guests".
Details:
Generated SELECT statement
Invalid column name 'Last'
I can cancel or click OK
When I click OK, I get the Connection and Data Adapter Components in the component tray. I can name them.
But when I try to generate the dataset, I get another error message.
Microsoft Development Environment
Retrieving the schema for daLastName failed
Invalid column name 'Last'
I can click cancel or OK
When I click OK I get the Generate Dataset box
I can name the dataset, but there are no tables to choose from in the box below
I am in the design view of the guests( I will be adding textboxes and a combo box to display info from the database) form. The guests form is a child form
What am I doing wrong
Thanks, Kay
When I try to drag the last name field from the table under Cottages(this is the name of the database on SQL Server from MSDE it was taken from a student files disk), I get an error message:
Data Adapter Configuration Error
The wizard detected the following problems when configuring the data adapter for "Guests".
Details:
Generated SELECT statement
Invalid column name 'Last'
I can cancel or click OK
When I click OK, I get the Connection and Data Adapter Components in the component tray. I can name them.
But when I try to generate the dataset, I get another error message.
Microsoft Development Environment
Retrieving the schema for daLastName failed
Invalid column name 'Last'
I can click cancel or OK
When I click OK I get the Generate Dataset box
I can name the dataset, but there are no tables to choose from in the box below
I am in the design view of the guests( I will be adding textboxes and a combo box to display info from the database) form. The guests form is a child form
What am I doing wrong
Thanks, Kay
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.