Setup error

Mar 13, 2011 at 12:46 AM

Hi,

After installing SQLPSX some functions work OK (e.g. Format), but others fail as per below. This is running on Windows Server 2008 R2 with SQL Server 2008 R2 - any idea what I'm doing wrong or how to troubleshoot it?

Thanks!

 

PS C:\Users\Administrator #[SQL]--- #[Oracle]--- > Connect-Sql
Set-Property : Property 'Visibility' cannot be found on this object; make sure it exists and is settable.
At C:\Users\Administrator\Documents\WindowsPowerShell\Modules\WPK\GeneratedControls\PresentationFramework.ps1:14730 char:21
+         Set-Property <<<<  -property $psBoundParameters -inputObject $Object
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Set-Property
 _____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
PS C:\Users\Administrator #[SQL]--- #[Oracle]--- > Invoke-ParseSql
Test-SqlScript : Cannot validate argument on parameter 'InputScript'. The argument is null or empty. Supply an argument that is not null or empty and then try the command again.
At C:\Users\Administrator\Documents\WindowsPowerShell\Modules\sqlise\sqlise.psm1:73 char:32
+     Test-SqlScript -InputScript <<<<  $inputScript -QuotedIdentifierOff:$($options.QuotedIdentifierOff) -SqlVersion:$($options.SqlVersion)
    + CategoryInfo          : InvalidData: (:) [Test-SqlScript], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,SQLParser.TestSqlScript

Coordinator
Mar 13, 2011 at 7:38 PM

This looks like an issue using SQL ISE or Oracle ISE, which due to WPK (or WPF) restrictions only run under the x86 version of PowerShell ISE. All other modules work within x86 or x64. On a Windows 2008 R2 systems (which is only x64) you'll find two version of PowerShell ISE installed, try running the Ise modules within the x86 version.

Developer
Mar 13, 2011 at 11:14 PM

I remember the problem of SQLIse not running on x64 originated with the introduction of the user isolated storage. OrcaleIse still was running on x64 then.

I'll recheck if it still does. As I don't use this feature in OracleIse, I suppose it still does.

 

Mar 14, 2011 at 12:26 AM

Spot on, x86 works perfectly, thanks!

Developer
Mar 14, 2011 at 10:56 AM

Checked OracleIse still running on x64.