Click here to Skip to main content
15,887,485 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
Questionpassword is in clear text after implementing SSL Pin
demoninside920-Aug-14 23:50
demoninside920-Aug-14 23:50 
AnswerRe: password is in clear text after implementing SSL Pin
Eddy Vluggen21-Aug-14 0:33
professionalEddy Vluggen21-Aug-14 0:33 
GeneralRe: password is in clear text after implementing SSL Pin
demoninside921-Aug-14 0:48
demoninside921-Aug-14 0:48 
GeneralRe: password is in clear text after implementing SSL Pin
Eddy Vluggen21-Aug-14 2:59
professionalEddy Vluggen21-Aug-14 2:59 
QuestionDll injection VB.NET Pin
3a©roub20-Aug-14 13:29
3a©roub20-Aug-14 13:29 
AnswerRe: Dll injection VB.NET Pin
Dave Kreskowiak20-Aug-14 13:44
mveDave Kreskowiak20-Aug-14 13:44 
AnswerRe: Dll injection VB.NET Pin
Richard MacCutchan20-Aug-14 21:24
mveRichard MacCutchan20-Aug-14 21:24 
Question.Net Remotting and SQL connection Pin
Juan Topo13-Aug-14 8:35
Juan Topo13-Aug-14 8:35 
Good afternoon, I wanted to share with you a problem I'm having, which you can not find a convincing answer.

What is the problem?

It is that database connections are many active and AWAITING COMMAND status SLEEPING, and every time I run a new query to the database, a new connection is added, I see this with sp_who2 from Management Studio.

What is the scenario?

An application of three layers (BUSINESS, DATA and PRESENTATION) which, because it is a client-server application, data is accessed by a Windows service that raises a
console application that instantiates a class that encapsulates access to data and records on the server so it can be accessed through Net Remotting.

Proper operation, can access data and execute everything correctly. At each attempt to access data, I end with Connection.close () method.

The problem is that despite using Connection.close () connections do not die and are all state SLEEPING, and there comes a time when you can no longer accumulate more
and SQL SERVER rejects the connection attempt, because limit was reached in the POOL.

Even if I close the main application, connections are maintained, but if I close the application that instantiates the object, all connections are closed.

Anyone has been in a similar situation? any suggestions?
QuestionRe: .Net Remotting and SQL connection Pin
Eddy Vluggen13-Aug-14 9:12
professionalEddy Vluggen13-Aug-14 9:12 
AnswerRe: .Net Remotting and SQL connection Pin
Juan Topo13-Aug-14 10:27
Juan Topo13-Aug-14 10:27 
GeneralRe: .Net Remotting and SQL connection Pin
Dave Kreskowiak13-Aug-14 12:29
mveDave Kreskowiak13-Aug-14 12:29 
GeneralRe: .Net Remotting and SQL connection Pin
Juan Topo14-Aug-14 1:42
Juan Topo14-Aug-14 1:42 
GeneralRe: .Net Remotting and SQL connection Pin
Juan Topo14-Aug-14 4:45
Juan Topo14-Aug-14 4:45 
GeneralRe: .Net Remotting and SQL connection Pin
Eddy Vluggen14-Aug-14 2:57
professionalEddy Vluggen14-Aug-14 2:57 
GeneralRe: .Net Remotting and SQL connection Pin
sankarsan parida27-Aug-14 20:47
professionalsankarsan parida27-Aug-14 20:47 
QuestionVisual Studio Online or Express? Pin
adamhill911-Aug-14 6:24
adamhill911-Aug-14 6:24 
QuestionRe: Visual Studio Online or Express? Pin
Eddy Vluggen11-Aug-14 7:44
professionalEddy Vluggen11-Aug-14 7:44 
AnswerRe: Visual Studio Online or Express? Pin
adamhill912-Aug-14 1:44
adamhill912-Aug-14 1:44 
GeneralRe: Visual Studio Online or Express? Pin
Eddy Vluggen12-Aug-14 5:15
professionalEddy Vluggen12-Aug-14 5:15 
GeneralRe: Visual Studio Online or Express? Pin
adamhill912-Aug-14 5:49
adamhill912-Aug-14 5:49 
GeneralRe: Visual Studio Online or Express? Pin
Eddy Vluggen12-Aug-14 7:24
professionalEddy Vluggen12-Aug-14 7:24 
GeneralRe: Visual Studio Online or Express? Pin
adamhill913-Aug-14 0:21
adamhill913-Aug-14 0:21 
GeneralRe: Visual Studio Online or Express? Pin
Richard MacCutchan12-Aug-14 20:55
mveRichard MacCutchan12-Aug-14 20:55 
GeneralRe: Visual Studio Online or Express? Pin
adamhill913-Aug-14 0:22
adamhill913-Aug-14 0:22 
AnswerRe: Visual Studio Online or Express? Pin
PIEBALDconsult11-Aug-14 8:01
mvePIEBALDconsult11-Aug-14 8:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.