January 26, 2002 at 1:26 am
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
January 26, 2002 at 5:35 am
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
January 26, 2002 at 7:53 am
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
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