February 6, 2002 at 5:07 am
Start SQL Server profiler and look at the connection from the begining to the point of failure watching how many connections are created and destroyed. You may also want to run performance monitor on the web server looking at "SQLServer:Gerneral Statstics" with UserConnections to see if anything specifically happens to connections. May be maxing out the connections so check you license on the SQL Server as well. Could even be a problem with the data access components. so you may want to try installing a fresh copy of the MDAC from Microsoft on the web server.
February 6, 2002 at 7:36 am
I would agree with James in that you should probably run a profile trace and watch carefully as you get close to the estimated time. However, since there are a whole slew of reasons the connection could be interrupted, I would hold off on installing or reinstalling MDAC.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply