Search found 30 matches

by akrofly
Tue Feb 13, 2018 7:09 am
Forum: Trial Software / Pre-sales Technical Questions
Topic: Upgrading cost from Suite 2017 -> 2018
Replies: 1
Views: 16230

Upgrading cost from Suite 2017 -> 2018

Product, version and build: SAPIEN Software Suite 2017
32 or 64 bit version of product: 64 bit
Operating system: Windows 10
32 or 64 bit OS: 64 bit

In conjunction with a new project, I need to update my Suite 2017 to 2018.
What would it cost me to do such an upgrade if at all possible?

Thank you.
by akrofly
Mon May 22, 2017 11:19 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

Importing the dll in the proposed manner worked.
But since transcription is not possible when compiled, we have to continue running it as a script in STA mode.
by akrofly
Mon May 22, 2017 6:07 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

Thank you for the information, I did not even think that transcription was not available in WHv2. I am more leaning towards your suspicions regarding the snap-ins not working in Windows Forms Host. I have not attempted to load the dll as you suggested, I will attempt that once I am back in the offic...
by akrofly
Mon May 22, 2017 5:25 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

2 error scenarios that I have experienced with the STA depending on how the script is formulated. 1) Transcription fails ( an output that gets manipulated later) Start-Transcript : This host does not support transcription. Used to retrieve the output of a T-query on the SQL 2008r2 servers, some sql ...
by akrofly
Mon May 22, 2017 4:46 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

Same error with the 32 bits as well.
by akrofly
Mon May 22, 2017 2:13 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

My mistake, my attempt with the snapshot was to show you the STA setting configuration that I have chosen.
I have also chosen the correct "Windows Forms Hosts" and it does not work, it fails.
by akrofly
Mon May 22, 2017 1:35 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

I thought I did, attached a snapshot of the settings.
by akrofly
Mon May 22, 2017 1:08 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

Upgrading the PowerShell on 100+ servers is not an option at this point in time since they are being migrated and phased out. For those servers, the SQLPS cannot be imported as a module and the need for the snapins arises. So I conclude from our discussion that either an upgrade or to continue using...
by akrofly
Mon May 22, 2017 12:17 am
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

SQLPS as an imported module is only supported in SQL 2012 or newer.
In 2008R2 versions it cannot be imported as a module, it is only a host, hence the need to add the pssnapins for certain operations.
by akrofly
Sun May 21, 2017 11:59 pm
Forum: PowerShell GUIs
Topic: Issues running in STA
Replies: 18
Views: 2266

Re: Issues running in STA

Thanks for that tip, but that will not work in this case.
I forgot to mention, the script checks the SQL version, if the SQL cluster is running a 2012 or newer, SQLPS is imported, but if the SQL is an older version then the pssnapins are added.