search

jspraul / sql-dbdiff

Automatically exported from code.google.com/p/sql-dbdiff
0 stars 0 forks source link

Invalid object name 'sys.databases'. #9

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. enter source database user/pw
2. click database dropdown list

What is the expected output? What do you see instead?
Expecting list of databases to select from.  Instead, getting following 
error:

Invalid object name 'sys.databases'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, 
Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException 
exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, 
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet 
bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader 
ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior 
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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.Front.SqlServerConnectFront.FillDatabase
()
   at 
DBDiff.Schema.SQLServer.Generates.Front.SqlServerConnectFront.cboDatabase_D
ropDown(Object sender, EventArgs e)
   at System.Windows.Forms.ComboBox.OnDropDown(EventArgs e)
   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
   at System.Windows.Forms.ComboBox.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)

What version of the product are you using? On what operating system?
0.3 on win2003 server SE SP2

Please provide any additional information below.

Original issue reported on code.google.com by mayno...@gmail.com on 24 Mar 2010 at 10:12

GoogleCodeExporter commented 9 years ago 
This is a strange one, what version of SQL?

Original comment by dean.tho...@gmail.com on 24 Mar 2010 at 11:50

GoogleCodeExporter commented 9 years ago 
MSSQL 2000

Original comment by mayno...@gmail.com on 25 Mar 2010 at 1:48

GoogleCodeExporter commented 9 years ago 
Found the problem, will be fixed soon. I Need to get a SQL 2000 test box, MSDE 
should do.

Original comment by dean.tho...@gmail.com on 25 Mar 2010 at 12:58

GoogleCodeExporter commented 9 years ago 
Issue 13 has been merged into this issue.

Original comment by dean.tho...@gmail.com on 28 Mar 2010 at 2:10

GoogleCodeExporter commented 9 years ago

Original comment by dean.tho...@gmail.com on 28 Mar 2010 at 2:10

GoogleCodeExporter commented 9 years ago 
I am seeing this as well, and also when I click Comp[are, I keep getting 
messages 
like the following, several times while the app is attempting to compare:

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)
   at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process()
   at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e)
   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)

Original comment by dstrat...@kwiktrip.com on 1 Apr 2010 at 2:10

GoogleCodeExporter commented 9 years ago 
With SQL 2000?

Original comment by dean.tho...@gmail.com on 1 Apr 2010 at 2:17

GoogleCodeExporter commented 9 years ago 
Dropping support for 2000 outright.

Original comment by dean.tho...@gmail.com on 21 Jul 2010 at 4:13