Issue refreshing catalog to SQL 2012

Posts   
 
    
vmanne
User
Posts: 3
Joined: 23-Dec-2013
# Posted on: 23-Dec-2013 20:02:00   

I'm seeing ExecutiveReader: CommandText property has not been initialized when refreshing the catalog.

I'm using V2.6

I made a data type change in the database for a field from int to money type and would like to change the same in generated code for LLBL and unable to proceed.

Please help.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 23-Dec-2013 21:20:35   

Please post the exact Designer Release Date (Help/About), and the exact error text.

vmanne
User
Posts: 3
Joined: 23-Dec-2013
# Posted on: 23-Dec-2013 21:59:35   

Walaa wrote:

Please post the exact Designer Release Date (Help/About), and the exact error text.

Version 2.6 Final Released on October 9th 2009

I have the attachment which has the screen shot in my original post. Here's the full error

Error is :

Message ExecuteReader: CommandText property has not been initialized

Stack Trace -----[Core exception]-------------------- 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerCatalogRetriever.RetrieveSchemas(String connectionString, IDBCatalog catalogToRetrieve, SchemaFetchFlags fetchFlags) at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.PopulateSelectedCatalogs(Hashtable callBacks, Hashtable connectionElements, SchemaFetchFlags fetchFlags, Hashtable properties) at SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshCatalogs(Boolean unattended, Hashtable catalogsToRefresh) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.ToolStripDropDown.WndProc(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)

Source System.Data

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 24-Dec-2013 05:41:38   

Are you using SQL Server 2012?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 24-Dec-2013 09:44:13   

You have an outdated driver. The one for sql server 2012 is to be found here: http://www.llblgen.com/tinyforum/GotoMessage.aspx?MessageID=120516&ThreadID=21348

It's recommended you first download the latest build from the customer area and they apply this updated driver.

Frans Bouma | Lead developer LLBLGen Pro
vmanne
User
Posts: 3
Joined: 23-Dec-2013
# Posted on: 03-Jan-2014 00:44:57   

After downloading the new dll, it worked. Thanks.