Hello,



I moved my translation strings from xml to a sql-table, using the DDT. No error so far, all went well. Also the translation works pretty well on every single form with the standard language. But the framework seems to miss a column called 'lng_eventid' when I change the language at runtime.



Any hint?



Thanks in advance and friendly greetings,



Ralph





Errormessage:



SqlException

Ungültiger Spaltenname 'lng_eventid'.



Source : .Net SqlClient Data Provider



Stack Trace:

bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

bei System.Data.SqlClient.SqlDataReader.get_MetaData()

bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(QueryInformation QueryInfo, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.UI.Localization.LoadLanguageTable(Boolean IgnoreExceptions)

bei MicroFour.StrataFrame.UI.Localization.SetActiveLanguageButtonText(Int32 LocaleID)

bei MicroFour.StrataFrame.UI.Localization.SetActiveLanguage(String ApplicationKey, Int32 LocaleID, String UserName)

bei MicroFour.StrataFrame.UI.LanguageSelectionDialog.cmdSelect_Click(Object sender, EventArgs e)

bei System.Windows.Forms.Control.OnClick(EventArgs e)

bei System.Windows.Forms.Button.OnClick(EventArgs e)

bei System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

bei System.Windows.Forms.Control.WndProc(Message& m)

bei System.Windows.Forms.ButtonBase.WndProc(Message& m)

bei System.Windows.Forms.Button.WndProc(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)

bei System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Hello Trent,



it seemed to work. But now, as soon as I try to start the DDT from menu, I get the following error message (invalid object name 'dbo.DBEProfile', thus no way to do any thing with the DDT:



SqlException

Ungültiger Objektname 'dbo.DBEProfile'.



Source : .Net SqlClient Data Provider



Stack Trace:

bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

bei System.Data.SqlClient.SqlDataReader.get_MetaData()

bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)

bei MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)

bei MicroFour.StrataFrame.Business.DBEProfileBO.FillAllByCategory()

bei MicroFour.StrataFrame.Data.ProfileOpen..ctor()

bei MicroFour.StrataFrame.Data.DatabaseMain.ShowProfileOpenDialog()

bei MicroFour.StrataFrame.Data.DatabaseMain.cmdOpen_Click(Object sender, EventArgs e)

bei System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)

bei System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)

bei System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)

bei System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)

bei System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)

bei System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)

bei System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)

bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

bei System.Windows.Forms.Control.WndProc(Message& m)

bei System.Windows.Forms.ScrollableControl.WndProc(Message& m)

bei System.Windows.Forms.ToolStrip.WndProc(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)

bei System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)





Thanks a lot and friendly greetings,



Ralph

Anytime that you see this message (regarding DBEProfile) it means that your StrataFrame connection is invalid.  Make sure that your connection is pointing to the database where StrataFrame resides.  In short, we are trying to load all of the profiles from the DBEProfiles table and it cannot find it.  To modify your connection, click the StrataFrame -> Database Connection and make sure that you point to the server with the StrataFrame database.  Once this is done, go back into Database Deployment Toolkit.