Help!! error message "Data provider or other service returned an E_FAIL status"

[anthoy]

if i run my view in the Designer at hte Enterprise manager i get that error message.. but if i run it through the SQL analyzer it's fine it wont have any errors.. :confused::confused:

[Chetan Patel]

You are Using any field which is keyword so use all field name with [] ex// Select name,group from employee Select [name],[group] from [employee]

Best Regards, Chetan Patel

[anthoy]

ei tnx so much.. at least now i got a hint cause i dont know where to start fixing that error..