I have a view that is join between a table in the SQL database and a view in the SQL database. When I try to open it via Open View, Return Top (10) the following error message appears:
[Microsoft] [ODBC SQL Server Driver] Timeout expired
When I click on the help button it shows the following:
ODBC error: <0s>.
An ODBC error has been generated. You might have deleted a record that has a foreign key value related to it, or you might have violated a check constraint.
For details, refer to your ODBC documentation.
Why this is an ODBC error I don't understand since the source data is all directly in SQL Server.
Also when I run the select statement used to create the view in Query Analyzer it runs without a problem.