CommandText property has not been initialized sql2012 2.6

Posts   
 
    
tvoss avatar
tvoss
User
Posts: 192
Joined: 07-Dec-2003
# Posted on: 25-Jun-2014 22:47:11   

Hello

With v2.6 works with sql2008 databases, but with sql2012 databases I get the error: CommandText property has not been initialized after trying to read entities from database.

Thanks, Terry

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 26-Jun-2014 04:13:51   

What LLBLGen v2.6 build are you using? Be sure to update to the latest build.

See this: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=21348&StartAtMessage=0&#120516

David Elizondo | LLBLGen Support Team
tvoss avatar
tvoss
User
Posts: 192
Joined: 07-Dec-2003
# Posted on: 26-Jun-2014 16:54:50   

Downloaded latest 2.6, installed, ran, same error: (I noted that the .exe was sept 2012 date which was the new one right?)

ExecuteReader: CommandText property has not been initialized

-----[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.NewProjectWizard.CreateNewProject()

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39899
Joined: 17-Aug-2003
# Posted on: 26-Jun-2014 18:07:54   

You need the driver which is attached to the post linked by David above.

Frans Bouma | Lead developer LLBLGen Pro
tvoss avatar
tvoss
User
Posts: 192
Joined: 07-Dec-2003
# Posted on: 27-Jun-2014 18:32:29   

Otis,

Hello, I read the link and saw a driver mentioned, but don't know how drivers fit into llblgen pro at all, what kind of file, how I would install such.

I see the file attached: SD.LLBLGen.Pro.DBDrivers.SqlServerDBDriver.dll

I've downloaded it, but where do I put it to allow it to have an effect? in main folder where exe is?

Terry

tvoss avatar
tvoss
User
Posts: 192
Joined: 07-Dec-2003
# Posted on: 27-Jun-2014 18:42:01   

Otis,

Okay, putting the drivers file into the sql drivers folder did it. simple_smile

Thanks,

Terry