using msquery\office 10.x need to see sql views not tables

[Steve]

I have just downloaded all the latest and greatest versions of office,
msquery and openlink odbc driver single tier. The problem that I'm having is
when creating a new ms query no views appear in the list box only tables
appear. I did a trace on the sql server side and found that the command is
only querying tables and not views. We use views to allow our users to
access data. If a user queries a saved query it works. Is this a driver
problem or a Microsoft problem or both? Does anyone else have this
problem?

 

[Jim Gordon MVP]

Hi Steve,

It is my understanding that ODBC only connects with data tables and that you
can use saved queries (.iqy) files with ODBC. Other saved objects such as
reports & graphs are not accessible via ODBC. It's been a while, but isn't a
view simply a table query? Why not extract the query and save it as .iqy
file and use that?

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Steve]

We provide a data warehouse for the University, We use views to filter the
results of a table depending on security. In using views we can also do
data intergration of two or more tables. In the past Microsoft would return
a list of views and tables to ms query. The warehouse has more then 600
views and changing the warehouse just for the Mac users is not an option.