No connection code, i just dragged the table and dropped into the form , i created the data adapter, and in data adapter properties if you click on generate dataset i get the error.

Thanks for looking into this


>Hi
>
>I will require more info than that, like your connection code?
>
>Kev
>
>>Thanks i received your email, i created a data connection in VS.net and tried to configure the data adapater,but i get
>>
>>Data adapter configuration Error
>>
>>Error in SELECT clause: expression near '['.
>>Error in FROM clause: near '['.
>>Unable to parse query text.
>>
>>What am i missing ?
>>
>>txs
>>
>>
>>>>Manipulating data.
>>>
>>>I haven't had any problems with the version of OLE DB releassed with version 8.0, do you want me to mail you a copy?
>>>
>>>Kev