Views and odbc

[dtrumbower]

When I log into mssql 2000 with crystal 9 using odbc, I don't get a full list of views. Using the same odbc connection and access, I get a listing of all the views. So it can't be permissions.

SQL Query Analyzer shows them all too.

First time I've seen this.

Thanks

 

[synapsevampire]

Perhaps you did not rigth click the database connection and select Options and check Views?

-k

 

[dtrumbower]

Well that would turn on and off views, I get some of the views. This isn't a normal situation. Considering earlier in the day the views showed up. Just something weird.

 

[synapsevampire]

Then it sounds like a permissions problem.

Is the Access database using the same ODBC connection, user and PW?

You might also try changing to a SQL Server native connection and see what is returned.

-k

 

[dtrumbower]

Permissions it isn't. As stated in the first message, using Access with same ODBC connection returns everything. SQL connection does work, but that doesn't help me.

This isn't a typical problem. It is happenning on two machines with two different users.


I just did a check and when I don't show the tables, I get all the views. Must be some kind of full buffer when crystal uses ODBC connections. Interesting.