09-15-2000, 02:50 PM
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?
09-15-2000, 03:37 PM
It is my understanding that it should function the same (table/view) so check the spelling of the view name first.
Quote of the moment....
"My job is so top secret even I don't know what I'm doing!"
09-15-2000, 04:32 PM
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.