select error

[fanor]

Hi all,
I can't configure a data adapter for one file. I'm using the data
adapter configuration wizard.

It showed the message :

generated SELECT statement

Unspecified error : E_FAIL(0x80004005)



the XML code is :

<xs:element name="housecl">
<xs:complexType>
<xs:sequence>
<xs:element name="phone" type="xs:string" />
<xs:element name="levels" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="bedrooms" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="restrooms" type="xs:float" minOccurs="0" />
<xs:element name="size" type="xs:short" minOccurs="0" />
<xs:element name="frequency" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="ini_date" type="xs:dateTime" minOccurs="0" />
<xs:element name="pets" type="xs:boolean" minOccurs="0" />
<xs:element name="amount" type="xs:decimal" minOccurs="0" />
<xs:element name="description" type="xs:string" minOccurs="0" />
<xs:element name="type" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="refrigerator" type="xs:boolean" minOccurs="0" />
<xs:element name="oven" type="xs:boolean" minOccurs="0" />
<xs:element name="rooms" type="xs:unsignedByte" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>

I have other files and i didn't have any problem.
I'm using an access database and OLEDB

ANy help will be apreciated

 

[Miha Markic [MVP C#]]

Hi,

What's your select? How are you configuring wizard?

 

[fanor]

I did in this order

1. select a conection to be used by the adapter
2. Use SQL statements
3. Query builder
4. choose the table, mark all columns

There is where I got the error message

For some reason, the wizard can't create the select command.

 

[Miha Markic [MVP C#]]

Hi fanor,

I would suggest you to manually add select statement into sqlcommand object
(CommandText).