Brian Donahue wrote:Hello,
Even though you can adjust the timeout at the connection string, this is only the connection timeout - you are more than likely wanting to set the query timeout, which is actually hard-coded.
You can also consider avoiding Named Pipes connections, as they are an additional level of complexity over TCP/IP. If you don't need to use Named Pipes, you can force the connection to use TCP by prefacing the server name with "TCP:", for instance, use TCP:localhost for the server name.
The obvious answer is, fix the problems with the network. But that could be a complicated endeavor.
Users browsing this forum: No registered users and 2 guests