Setup error

Mar 12, 2011 at 11:46 PM


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?



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

Mar 13, 2011 at 6: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.

Mar 13, 2011 at 10: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 13, 2011 at 11:26 PM

Spot on, x86 works perfectly, thanks!

Mar 14, 2011 at 9:56 AM

Checked OracleIse still running on x64.