Posted on 19/11/2008 10:05:10
ks wrote:
np wrote:
ks wrote:
I have heard that it becomes possible to port Language.mdb to SQL server as a seperate SQL Server Database and then be able to run solutions in IIS running 64bit mode.
When is this released? Since I have a customer who only waits for this feature.
Hi Kevin
Its part of the release that comes out now. The build you can download from developer actually have this feature. It has not been fully tested in production yet and we have not said that much about it. I've made some tests though on W2008 x64 with IIS 7 in integrated pipeline mode, and it seems fine.
To activate, upsize /Admin/Language.mdb to a SQL-Server database and add the following to your /Files/Globalsettings.aspx <Database> section:
Translation> <ConnectionString> </ConnectionString> <UserName>uid</UserName>
<Password>pwd</Password>
<Database>db</Database>
<SQLServer>transdbserver</SQLServer>
</Translation>
<
Perfect, I'll try test it on W2003 x64 in IIS 6 and provide you with some feedback.
I get an exception when trying to access /admin
[InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.]
System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) +3008024
System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +13
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +189
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +138
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +35
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +220
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +25
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +21
Dynamicweb.Backend.Translate.SetLanguage(Int32 LanguageID, Boolean blnResetLanguage) +1093
Dynamicweb.Backend.Translate.GetWord(String Key, Int32 intAlternative, Boolean blnJs) +1420
Dynamicweb.Backend.Translate.JsTranslate(String Key, Int32 intAlternative) +61
ASP.admin_default_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +162
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115
System.Web.UI.Page.Render(HtmlTextWriter writer) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4592
Here some more debug info:
ExecuteReader requires an open and available Connection. The connection's current state is closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.
Source Error:
Line 7: <head>
Line 8: <title>
Line 9: <%=Base.IIf(Trim(Base.GetGs("/Globalsettings/Settings/CommonInformation/SolutionTitle")) <> "", Base.GetGs("/Globalsettings/Settings/CommonInformation/SolutionTitle") & " - " & Translate.JSTranslate("Dynamicweb administration"), Translate.JSTranslate("Dynamicweb administration"))%>
Line 10: </title>
Line 11:
|
Source File: E:\Dynamicweb.NET\Application\Admin\Default.aspx Line: 9
Stack Trace:
[InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is closed.]
System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) +3008024
System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +13
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +189
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +138
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +35
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +220
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +25
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +21
Dynamicweb.Backend.Translate.SetLanguage(Int32 LanguageID, Boolean blnResetLanguage) +512
Dynamicweb.Backend.Translate.GetWord(String Key, Int32 intAlternative, Boolean blnJs) +754
Dynamicweb.Backend.Translate.JsTranslate(String Key, Int32 intAlternative) +12
ASP.admin_default_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in E:\Dynamicweb.NET\Application\Admin\Default.aspx:9
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115
System.Web.UI.Page.Render(HtmlTextWriter writer) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4592
|
