He ik wil een site plaatsen hier lokaal werkt het wel maar online niet .
Fout.run time error.
Nu ligt de fout bij de instelling van de olledb van de database
maar ik heb dit niet gemaakt en kan er niet aan uit in het bestand staan deze gegevens.
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
DataTable dt = new DataTable();
da.Fill(dt);
da.Dispose();
conn.Close();
return dt;
en dit heb ik als probleem of oplossing gekregen maar ik weet niet juist welke regel en hoe deze moet worden aangepast .
Kan iemand mij helpen.
Selected collating sequence not supported by the operating system.
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.Data.OleDb.OleDbException: Selected collating sequence not supported by the operating system.
Source Error:
Line 147: OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, conn);
Line 148: DataTable dt = new DataTable();
Line 149: da.Fill(dt);
Line 150: da.Dispose();
Line 151: conn.Close();
Source File: d:\accounts\b\e\becanchicom\www\App_Code\BlogLib.cs Line: 149
Stack Trace:
[OleDbException (0x80004005): Selected collating sequence not supported by the operating system.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1002464
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +116
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +4
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115
BlogLib.DataTableBinder(String sqlstr, String tablename) in d:\accounts\b\e\becanchicom\www\App_Code\BlogLib.cs:149
_Default.BindServices() in d:\accounts\b\e\becanchicom\www\Default.aspx.cs:54
_Default.Page_Load(Object sender, EventArgs e) in d:\accounts\b\e\becanchicom\www\Default.aspx.cs:28
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627