Object Browser fails to open!
Posted: Mon May 06, 2013 8:14 am
Hello *,
I've bought a license of PowerShell Studio 2012 and actually I'm evaluating PrimalSQL 2012, too.
But unfortunately I get stuck because the Object Browser does not open and show tables, views and procedures of a database Connection to a remote MS SQL Server 2008R2 Standard instance but idles indefinitely.
But ...
+ "Test Connection" is successful.
+ The connection string is working quite well in PowerShell scripts.
+ "Quering with SQL Text" using right-click at the instance Name opens a Windows where all SQL queries succeeds.
+ Exported query forms or PowerShell scripts DO work from the PowerShell comd line or PowerShell Studio 2012 even if I do an Export as an .exe
By the way - the Object Explorer of PowerShell Studio 2012 does act the same as PrimalSQL 2012 and tries to open the DB object tree indefinitely
The DB Connection is also working fine from MS SQL Server Management Studio 2008R2, too.
The instance I'm trying to connect is a remote MS SQL Server database instance. Connecting to a local SQLEXPRESS 2008R2 default demo DB instance does work and expands correctly.
Any help to get the DB Ojbect Explorer of PrimalSQL 2012 and the PowerShell Studio 2012 up and running is greatly appreciated.
Thank you very much in advance for any advise and help.
Best regards from Germany
Matthias
I've bought a license of PowerShell Studio 2012 and actually I'm evaluating PrimalSQL 2012, too.
But unfortunately I get stuck because the Object Browser does not open and show tables, views and procedures of a database Connection to a remote MS SQL Server 2008R2 Standard instance but idles indefinitely.
But ...
+ "Test Connection" is successful.
+ The connection string is working quite well in PowerShell scripts.
+ "Quering with SQL Text" using right-click at the instance Name opens a Windows where all SQL queries succeeds.
+ Exported query forms or PowerShell scripts DO work from the PowerShell comd line or PowerShell Studio 2012 even if I do an Export as an .exe
By the way - the Object Explorer of PowerShell Studio 2012 does act the same as PrimalSQL 2012 and tries to open the DB object tree indefinitely
The DB Connection is also working fine from MS SQL Server Management Studio 2008R2, too.
The instance I'm trying to connect is a remote MS SQL Server database instance. Connecting to a local SQLEXPRESS 2008R2 default demo DB instance does work and expands correctly.
Any help to get the DB Ojbect Explorer of PrimalSQL 2012 and the PowerShell Studio 2012 up and running is greatly appreciated.
Thank you very much in advance for any advise and help.
Best regards from Germany
Matthias