1

Closed

Execute Reader: CommandText property has not been initialized.

description

I am trying to compare 2 databases on the same server but different instances. SQL version is 2008. Server os is SBS 2008. I am logged in as the domain administrator on the box. Below is the full error....

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized
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 DBDiff.Schema.SQLServer.Generates.Generates.GenerateDatabase.Get(Database database) in c:\dev\open-dbdiff\DBDiff.Schema.SQLServer2005\Generates\GenerateDatabase.cs:line 44
at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process() in c:\dev\open-dbdiff\DBDiff.Schema.SQLServer2005\Generates\Generate.cs:line 79
at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e) in c:\dev\open-dbdiff\DBDiff\Front\ProgressForm.cs:line 63
at System.Windows.Forms.Form.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4247 (VistaSP2GDR.050727-4200)

CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

DBDiff
Assembly Version: 0.8.6.0
Win32 Version: 0.8.6.0

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/DBDiff.exe

System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4236 (VistaSP2GDR.050727-4200)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4235 (VistaSP2GDR.050727-4200)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4235 (VistaSP2GDR.050727-4200)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

DBDiff.Schema.SQLServer
Assembly Version: 0.8.0.0
Win32 Version: 0.8.0.0

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/DBDiff.Schema.SQLServer.DLL

DBDiff.Front
Assembly Version: 0.8.0.0
Win32 Version: 0.8.0.0

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/DBDiff.Front.DLL

DBDiff.Schema
Assembly Version: 0.8.0.0
Win32 Version: 0.8.0.0

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/DBDiff.Schema.DLL

Ascend.Windows.Forms
Assembly Version: 1.0.0.6
Win32 Version: 1.0.0.6

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/Ascend.Windows.Forms.DLL

Ascend
Assembly Version: 1.0.0.6
Win32 Version: 1.0.0.6

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/Ascend.DLL

System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4246 (VistaSP2GDR.050727-4200)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

System.Data.SQLite
Assembly Version: 1.0.65.0
Win32 Version: 1.0.65.0

CodeBase: file:///C:/Users/administrator.THECALIBRATIONS/Desktop/OpenDBDiff/OpenDBDiff/System.Data.SQLite.DLL

System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4246 (VistaSP2GDR.050727-4200)

CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)

CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Closed Jun 2 at 6:42 PM by jspraul

comments

jspraul wrote Mar 27 at 3:23 AM

Thanks for taking the time to create an account to create this issue.

I put off making the latest code the 'release' version for way too long, but it's out there officially now... let me know if you still have problems with this version:

https://opendbiff.codeplex.com/releases

BBENNE wrote Mar 27 at 2:02 PM

That took care of the problem! Thanks for the rapid response!