OLE DB Times Out

  • Hello,

    Ever since we moved from

    MDAC 2.5 to MDAC 2.6

    We have been facing this problem of all DTS, Queries timimg out.

    The same queries, DTS packages used to work.

    These do work some times.

    But the max number of times they time out.

    Is there a way of setting the time out for OLE DB?

    At the same time, we had moved Servers Also.

    Is there anything on the server side that I can ask my DB hosting firm to do?

    I Tried installng SPs, Going back to 2.5.

    None Of them have worked.

    Regards,

    Rahul

  • I've had no problems with MDAC 2.6. Using ADO you can set both the connection timeout and/or the command timeout. Before you spend much time there you need to explore WHY the timeout is happening. Might be blocking, server load, network traffic, query plan, etc. Can you connect ok each time with Query Analyzer? What version of SQL and what service pack?

    Andy

  • What caught my eye was the following:

    quote:


    At the same time, we had moved Servers Also.


    You've changed two things from the previous environment, the MDAC level and the network "path" both changed. Since you went back to 2.5 and still got the timeouts, I would be very suspicious of how the network path.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply