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 All Rows 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.

Report this post to a moderator

Hi Nevzat,

It seems that the error is a known issue when opening a long running view
in the Enterprise Manager (EM). The default query time-out is 30 seconds in
EM and not configurable. You can query the view in the Query Analyzer and
it is successful per your previous post. For more information, please refer
to http://support.microsoft.com/defaul...;en-us;q247070.

Sincerely,

Linda Deng
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.

Report this post to a moderator