When I tried to connect with Toad to SQL Server 2008 R2 SP1, I get the following error:
**********************************************************************
Exception Information
**********************************************************************
Exception: System.InvalidOperationException
Message : ExecuteReader: CommandText property has not been initialized
Stack Trace:
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Quest.Toad.SqlServer.Registration.SqlServerDbSearchForm.worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
Toad for SQL Server 5.0.0.444 lists the following supported SQL Server.
SQL Server 2000 (Service Pack 3 or later), 2005 (Service Pack 2 or later), 2008
Note: SQL Server Compact Edition is not supported.
Toad for SQL Server 5.6.0.568 lists the following supported SQL Server.
SQL Server 2000 (Service Pack 3 or later)
SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express
SQL Server 2008 and SQL Server 2008 Express
SQL Server 2008 R2 and SQL Server 2008 R2 Express
Note: SQL Server Compact Edition is not supported.
Toad for SQL Server 5.6.0.568 explicitly lists SQL Server 2008 R2. Please download Toad for SQL Server 5.6.0.568 from the following site and try that first?
