Search found 14869 matches

by jvierra
Mon Jul 26, 2021 3:28 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

Removing Connections The connection pooler removes a connection from the pool after it has been idle for approximately 4-8 minutes, or if the pooler detects that the connection with the server has been severed. Note that a severed connection can be detected only after attempting to communicate with ...
by jvierra
Mon Jul 26, 2021 3:02 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

The issue is likely caused by running multiple sessions. If you use IPs directly this will tell you if it is a session issue or if it is an access issue. Also using an IP directly will eliminate any cache conflicts as what is cached will be cached by IP. Also note that SQLServer uses different metho...
by jvierra
Mon Jul 26, 2021 2:36 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

Clearly you are now adding many more layers of complexity to the issue which is why I suggest a consultant as you have left out the majority of your configuration until the last post. There is no way for me or anyone else to guess this. If you were network and database trained you would have given t...
by jvierra
Mon Jul 26, 2021 2:04 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

One other note isa that the "hosts" file will not override the DNS in most situations. Trying to override DNS with a host file will cause all manner of odd conflicts. If you have to switch between networks then the DNS on the new network will give you the cor4rect name translation without any need t...
by jvierra
Mon Jul 26, 2021 1:52 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

Clearly you have little technical training in databases and networking so understanding the issue will require that you may need a consultant to help you. PSS is not a replacement for technical training, it is a professional toolbox intended to be used by people trained in the technology. Also your ...
by jvierra
Fri Jul 23, 2021 5:01 pm
Forum: PowerShell
Topic: Script Help
Replies: 4
Views: 3868

Re: Script Help

I just told you the better way. YOu also don;t need to select and convert as the selector alreadyt does all of that. YOu are enumerating the results repeatedly when you don't need to enumerate anything. WHat most people who have not learned Power5Shell miss is that PowerShell is an enumerator althou...
by jvierra
Fri Jul 23, 2021 1:28 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

WHy do you have to change the hostname? WHy are you using SQLCMD in a GUI? Changing a hostname after starting an app will not change it foro the app unless you exit the app and restart it. Overal I see that you have no programming experience and you are just guessing at how to do this. Normally we w...
by jvierra
Thu Jul 22, 2021 11:09 am
Forum: PowerShell
Topic: Script Help
Replies: 4
Views: 3868

Re: Script Help

To do that the selector and formatter have to be outside of the data loop.
by jvierra
Wed Jul 21, 2021 2:13 am
Forum: PowerShell GUIs
Topic: How to Clear Hostname Variable
Replies: 11
Views: 787

Re: How to Clear Hostname Variable

Sorry but it is impossible to know what you are asking. Without some idea of what variable you are asking about there is no way to suggest an answer. WHat are teh "host/ip pairs" There is no such technical variable or thing. Without some clear idea of what you have and how you are proceeding then we...
by jvierra
Fri Jul 16, 2021 6:36 am
Forum: PowerShell GUIs
Topic: Size box not taking entered values
Replies: 3
Views: 796

Re: Size box not taking entered values

It is good that that was the issue as there could be other causes. Your issues have nothing to do with Sapien. PSS is just a frame that uses Microsoft Net tools to design forms. Sapien inforces nothing and doesn't alter any default behaviors. Everything you see is Microsoft WinForms. The issue is th...