connecting to a universe database

cwmJeff
cwmJeff used Ask the Experts™
on
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?
Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Got it!  I was missing a set of odbc drivers for .net.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial