RE: Error when saving Profile

Ben Chase — Tue, 12 Sep 2006 08:08:24 GMT

No, your application only has one connection. Rather, there is a design-time connection that is used by the Visual Studio AddIn (BOMapper), the DDT, and the Messaging Editor to communicate with the StrataFrame database. The StrataFrame database is where the StrataFrame stores all of the design-time information (meta-data, BOMapper config, messages & localization values, etc). To change the design-time connection, you go through the Database Connection option under the StrataFrame menu in Visual Studio. To change your program's connection (runtime), you change it within the SetDataSources() method in the AppMain.vb or Program.cs file.

RE: Error when saving Profile

Flavelle Ballem — Mon, 11 Sep 2006 18:33:37 GMT

Ben:

Must be my confusion. I gather that I am dealing with two connections - a StrataFrame connection and a connection that my application requires to access the 'real' data.

Over time, I will get there, but clearly some patience is required.

Thanks,

Flavelle

RE: Error when saving Profile

Ben Chase — Mon, 11 Sep 2006 08:11:42 GMT

Howdy, Flavelle,

Looks like your StrataFrame design-time data source (connection string) has been changed to something else.

You can change the connection string through the "Database Connection" option under the StrataFrame menu within Visual Studio. Changing the database connection within this option does not change the database connection for your application, but for the SF design-time components.

Error when saving Profile

Flavelle Ballem — Sat, 09 Sep 2006 16:28:25 GMT

BusinessLayerException
An error occurred while saving an the data to the server.
BusinessLayerException
An error occurred while saving the data to the server.
SqlException
Invalid object name 'dbefilegroups'.

Source : MicroFour StrataFrame Business

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.ExecuteScalar()
at MicroFour.StrataFrame.Data.DbDataSourceItem.ExecuteScalar(DbCommand Command)
at MicroFour.StrataFrame.Business.BusinessLayer.ExecuteScalar(DbCommand CommandToExecute)
at MicroFour.StrataFrame.Business.DBEFileGroupsBO.GetFileGroupsCount(String FileGroupName, Int32 DatabasePK)
at MicroFour.StrataFrame.Business.DBEFileGroupsBO.DBEFileGroupsBO_CheckRulesOnCurrentRow(CheckRulesEventArgs e)
at MicroFour.StrataFrame.Business.BusinessLayer.raise_CheckRulesOnCurrentRow(CheckRulesEventArgs e)
at MicroFour.StrataFrame.Business.BusinessLayer.OnCheckRulesOnCurrentRow(CheckRulesEventArgs e)
at MicroFour.StrataFrame.Business.BusinessLayer.CheckRules(Boolean RaiseCheckedEvent)
at MicroFour.StrataFrame.Business.BusinessLayer.Save(Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.Data.DataLayer.SaveByForm(DataTable TableToSave, Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.Business.BusinessLayer.SaveByForm(Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save(Boolean Transactional, String TransactionKey)
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save()
at MicroFour.StrataFrame.Data.DatabaseProperties.cmdSave_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.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)

StrataFrame Forum / StrataFrame Database Deployment Toolkit / Issues / Error when saving Profile / Latest Posts

RE: Error when saving Profile

RE: Error when saving Profile

RE: Error when saving Profile

Error when saving Profile