Re: ODBC Drivers error '80040e31'

From: Alper (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 14:41:14 -0700

Thanks Aaron!
     
I've changed the connection string and am connecting with OLE DB provider now...we'll see if it makes any difference...

But I have a feeling it will start throwing time outs any way... May be our tables, queries, etc. need to be optimized...

Thanks,

- A l p e r

     
     ----- Aaron Bertrand - MVP wrote: -----
     
     Maybe some information here:
     http://www.aspfaq.com/2287
     
     --
     Aaron Bertrand
     SQL Server MVP
     http://www.aspfaq.com/
     
     
     
     
     "Alper" <anonymous@discussions.microsoft.com> wrote in message
     news:3F1AC249-81D0-498F-AB81-E8F628A1F98C@microsoft.com...
>> We moved our SQL Server 2000 onto a Win 2003 box (with SQL
> SP3a applied).
>> Lately, we have been experiencing intermittent ADO
> timeouts on our webpages displaying the following error:
>> Microsoft OLE DB Provider for ODBC Drivers
> error '80040e31'
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>> If anyone has any ideas as to possible reasons, it would be immensely
     appreciated?
>> Any help would be greatly appreciated.
>> Thank you.
>> - A l p e r
>

Relevant Pages

  • RE: Database Lookup Functoid Connection String
    ... A OLE DB provider is a COM component which implement a number of COM ... And connection string is a way to initialize a OLE DB provider. ... accessed by the BizTalk server account, ...
    (microsoft.public.biztalk.general)
  • Re: Delphi 7, MySQL and ADO
    ... The problem lies in the fact that the OLE DB ... provider from www.MySQL.com is from year 2001 and does not work correctly. ... want to use MySQL with ADO you'll have to do it through the ODBC, ... To be more concrete, when you create your connection string, you should ...
    (borland.public.delphi.database.ado)
  • DBPROP_INIT_PROMPT implementation
    ... goto EXIT; ... "Format of the initialization string does not conform to the OLE DB ... It works fine if I pass connection string removing last property, ... OUR provider returns DBPROMPT_NOPROMPT ...
    (microsoft.public.data.oledb)
  • Extended Properties of Microsoft.Jet.4.0 Provider
    ... Where can I get a detailed reference pertaining to the Extended Properties in ... the Connection String regarding the Microsoft.Jet.4.0 OLE DB ... Provider i.e. what the available parameters are for dealing with ...
    (microsoft.public.data.oledb)
  • Linked server to as400 - for the love of god please help.
    ... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
    (microsoft.public.sqlserver.server)