Re: [Microsoft][ODBC SQL Server Driver] Timeout expired

From: Gary W. Hinkel (GaryWHinkel_at_discussions.microsoft.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 06:25:03 -0800

Unfortunately, there is no error number, and the error message is the subject
line of this post. Also, I am not specifying any parameters at all, as this
is happening in Enterrpise Manager, Views, right-click on view, Open View,
Return Top.

"AnthonyThomas" wrote:

> What is the exact error number and message? There are several types of
> timeouts. If you are not specifying the correct parameter, it will continue
> to timeout on that type.
>
> Sincerely,
>
>
> Anthony Thomas
>
>
> --
>
> "Gary W. Hinkel" <GaryWHinkel@discussions.microsoft.com> wrote in message
> news:E43E35ED-809B-4DF4-8869-0EE3A49F9EEF@microsoft.com...
> I am getting this error when I try and look at the Top 1000 records of a
> view
> that I have created, in Enterprise Manager. If I copy the SQL for the View
> into Query Analyzer, it returns results fine (in approx. 2 minutes). In the
> Enterprise Manager Properties Advanced window, I have set Query timeout to
> both 0 (never times out?) and 60000 (100 minutes?) to no avail. Any
> suggestions would be greatly appreciated.
>
>
>

Relevant Pages

  • Re: Connection
    ... The default login timeout in Enterprise Manager is 4 secs ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: timing input!
    ... to enter something just a few second and if user didnt enter anything ... specifying a timeout. ... errordlg(), warndlg, questdlgdialog, uigetprefall create new ...
    (comp.soft-sys.matlab)
  • Re: [Microsoft][ODBC SQL Server Driver] Timeout expired
    ... If you've changed the SQLEM, Tools, Options, Advanced Tab, Query Timeout ... Advanced Window does not exist for SQLEM. ... >> Enterprise Manager Properties Advanced window, I have set Query timeout to ...
    (microsoft.public.sqlserver.server)
  • Re: mysql_connect_timeout problem when using times less than 1 sec
    ... I have looked at the code for DBD::mysql and DBI.pm but cannot workout where ... the timeout is implemented or where the default is specified. ... which is the same as not specifying mysql_connect_timeout at all. ... > The DBI module when connecting to a mysql database seams to only support ...
    (perl.dbi.users)
  • Re: Timeout Expired during backup
    ... You need to set the Query Timeout to Zero on your Command Object ... > command (as with Enterprise Manager) that I can use in a Windows Form? ...
    (microsoft.public.sqlserver.msde)