I have an odbc connection to a universe database. I can use it to retrieve data using microsoft query in excel, but I need to be able to use it in visual studios .net. I add a dataset to my project, create an odbc connection that suceeds in the "test connection" area, but as soon as I try to add tables, I get the error "You might not have permission to perform this operation, or the object tp_truck might no longer exist in the database." Permissions should be fine and the table is definately there.
Any ideas how to do this or what the problem might be?