I created a Business Object Library within the Web Solution and selected to run the Business Object Mapper ... the following error occurs.  I have also uninstalled and reinstalled SF 1.4.1 and still get the error message.  I also tried to run the Business Object Mapper from within the Example Web Application, same result.

Help!

Error Message is as follows:

SqlException
 Invalid object name 'DTEprojects'.

Source     : .Net SqlClient Data Provider

Stack Trace:
   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.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 MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)
   at MicroFour.StrataFrame.AddIns.DTEprojectsBO.FillProjects(String[] ProjectPaths)
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.BuildProjectNode(PartialClassBuilderVSProject Prj)
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.BuildTreeView()
   at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.InitForm()


Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com

Joe,

Check the StrataFrame database connection within Visual Studio and make sure it is configured propertly.  Open the Database Connection option from the StrataFrame menu within Visual Studio and edit the one that has a checkmark on it.  It should be pointed to the location where you have your StrataFrame database installed.

I have 2 database connections.  One for StrataFrame and one for Northwind (my testing DB).  The Northwind connection was the only one with the green checkmark on it.  I deleted and recreated my connection for Northwind and edited the StrataFrame connection.  I changed both servers from Localhost to the server name (shouldn't make any difference, but tried it anyway) and saved the connections.  The connection info is correct, the server is up and running, and is available. 

After doing the above, I'm still getting the original exception.

Since I was getting nowhere with the 1.4.1 release, I deinstalled everything again, dropped the StrataFrame databases, and verified that everything was deleted.  I then installed the 1.4.0 release, verified the StrataFrame databases were created, verified the StrataFrame database connection exists and points to the correct database.  I then created a new StrataFrame Windows application project in VS2005.  Then I went to the Business Object Mapper and clicked on it.  I am still getting the same error as before.  The StrataFrame database does have a table named DTEprojects, and that table is empty.  

I do NOT have the Database Deployment ToolKit.  Since this an optional product, could this problem be a dependency issue?  When I was playing with the trial license, I did have this tool loaded and I didn't have any problems with Business Object Mapper.

OK, the reason you're getting that exception is that the Northwind connection is the active connection.  The Database Connection option in the StrataFrame menu is not used for your application's connections.  The only connection that should be listed within the Database Connections is the StrataFrame connection.  Your application's connection string is configured through the SetDataSources() method of the AppMain.vb (or program.cs file).  So, the StrataFrame design-time components were trying to use the Northwind connection to find the StrataFrame tables (which is, of course, not going to work ).  So, delete that Northwind connection and configure it within the SetDataSource() and set the active StrataFrame Database Connection as the correct one within the Database Connections dialog.  The BOMapper will come back to life.

That did it!  Thanks!

Excellent glad to hear it.