Query on SqlConnection of ADO.NET

[Guest]

Hi,

I have an sql server on seperate system and my application runs on another
dedicated server - both the machines works on Windows 2003 server OS. From
last 2-3 days one of the .net application which has been working fine for the
last 1 year suddently start giving timeout error when querying one of the
tables. Please note that this application could connect to the database
successfully using Windows Authentication. Also there is not much of change
in data volume during the last one week. The machine where the .NET
application runs does not have any SQL instances. It is connecting to the
other server with only SQL server. My query returns around 24000+ rows only -
also both the servers have the best hardware configuration.

My query is that, when we connect to SQL server from .NET application using
data.sqlclient library, does it uses tcp/ip or named pipes for communication
by default ? Is there any way to find this out and change it ? I have used
object viewer to find this out, but could not succeed.

Could some one help ?

Thanks
Suhas

 

[W.G. Ryan - MVP]

Suhas - is it a command timeout or a connection timeout?

 

[Guest]

Hi,

It is giving command time out. Also what is the default connection
mechanisam - tcp/ip or named pipes ?

Thanks
Suhas