Accessing SQL Views

I am attempting to grab data from an view in my sql server db? it errors out saying it can not grab the connection trhough odbc. if i replace the sql that i am calling with a table (instead of calling the view) it works fine.

is there a special way to access the views?

It is my understanding that it should function the same (table/view) so check the spelling of the view name first.

HTH


Quote of the moment....
"My job is so top secret even I don't know what I'm doing!"

I agree. I would think that it should function the same. I have checked the spelling several times. I have also tried it with different views. It just fails everytime.