PC Review


Reply
Thread Tools Rate Thread

2 connections instead of 1

 
 
Nick Carter
Guest
Posts: n/a
 
      27th Aug 2003
When I execute the following code:-

SqlConnection connection = new SqlConnection("Server=(local); Integrated
Security=SSPI;Database=Northwind");
Connection.Open();

it appears to create 2 connections instead of 1. I say two connections
because this is what Performance Monitor reports and also the
PerformanceCounter component when the Category is "SQLServer:General
Statistics" and CounterName is "User Connections". AFAICS this only happens
the first time it is executed. Why is there 2 connections ? What is the
other connection for ?

Thanks.

Nick Carter


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lingering Idle Oracle Connections? Persistent connections? jobs Microsoft ASP .NET 2 16th Nov 2007 03:37 AM
PPPOE connections created show up as Dial-up connections =?Utf-8?B?amFja2ll?= Windows Vista Networking 0 6th Oct 2007 07:20 AM
Inbound connections fail, outbound connections are fine - firewall shut off, very strange wwworldwideweb@gmail.com Windows XP General 0 18th Aug 2007 05:28 PM
Disappearing Dial-up connections in the network connections folder Effegy Windows XP Networking 0 9th Jun 2004 08:45 PM
>My Network Connections window does not have anything called Incoming Connections lhd_5113 Windows XP Networking 1 26th Nov 2003 08:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:29 PM.