http://singup-1.at.vwdhosting.net
这个站点
为什么在本地自己机器运行一点问题都没有 上传到这个站点就出现了问题 高手给点指点
我的WEB.config文件如下:
<?xml version="1.0"?>
<!--
注意: 除了手动编辑此文件以外,您还可以使用
Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的
“网站”->“Asp.Net 配置”选项。
设置和注释的完整列表在
machine.config.comments 中,该文件通常位于
\Windows\Microsoft.Net\Framework\v2.x\Config 中
-->
<configuration>
<appSettings/>
<connectionStrings>
<add name="databaseConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\database.mdb;" providerName="System.Data.OleDb"/>
</connectionStrings>
<system.web>
<!--
设置 compilation debug="true" 将调试符号插入
已编译的页面中。但由于这会
影响性能,因此只在开发过程中将此值
设置为 true。
-->
<customErrors mode="Off"/> <compilation debug="true"/>
<!--
通过 <authentication> 节可以配置 ASP.NET 使用的
安全身份验证模式,
以标识传入的用户。
-->
<authentication mode="Windows"/>
<!--
如果在执行请求的过程中出现未处理的错误,
则通过 <customErrors> 节可以配置相应的处理步骤。具体说来,
开发人员通过该节可以配置
要显示的 html 错误页
以代替错误堆栈跟踪。 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
-----------------------------------------------------------------------
浏览站点的错误:
Server Error in '/' Application.
--------------------------------------------------------------------------------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 5032: this.Adapter.SelectCommand = this.CommandCollection[3];
Line 5033: BATABASE.articleDataTable dataTable = new BATABASE.articleDataTable();
Line 5034: this.Adapter.Fill(dataTable);
Line 5035: return dataTable;
Line 5036: }
Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a43efdb5\a2f00bbb\App_Code.puwhmves.1.cs Line: 5034 Stack Trace:
[OleDbException (0x80004005): Selected collating sequence not supported by the operating system.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +111
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) +141
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
BATABASETableAdapters.articleTableAdapter.GetDataBytop4() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a43efdb5\a2f00bbb\App_Code.puwhmves.1.cs:5034
zuijingenxin.Page_Load(Object sender, EventArgs e) in d:\Users\singup-1\zuijingenxin.ascx.cs:21
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
--------------------------------------------------------------------------------
注意 前提是我在本地机器上可以运行的
在首页我检索了数据库中的几行数据!
急盼高手出现
这个站点
为什么在本地自己机器运行一点问题都没有 上传到这个站点就出现了问题 高手给点指点
我的WEB.config文件如下:
<?xml version="1.0"?>
<!--
注意: 除了手动编辑此文件以外,您还可以使用
Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的
“网站”->“Asp.Net 配置”选项。
设置和注释的完整列表在
machine.config.comments 中,该文件通常位于
\Windows\Microsoft.Net\Framework\v2.x\Config 中
-->
<configuration>
<appSettings/>
<connectionStrings>
<add name="databaseConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\database.mdb;" providerName="System.Data.OleDb"/>
</connectionStrings>
<system.web>
<!--
设置 compilation debug="true" 将调试符号插入
已编译的页面中。但由于这会
影响性能,因此只在开发过程中将此值
设置为 true。
-->
<customErrors mode="Off"/> <compilation debug="true"/>
<!--
通过 <authentication> 节可以配置 ASP.NET 使用的
安全身份验证模式,
以标识传入的用户。
-->
<authentication mode="Windows"/>
<!--
如果在执行请求的过程中出现未处理的错误,
则通过 <customErrors> 节可以配置相应的处理步骤。具体说来,
开发人员通过该节可以配置
要显示的 html 错误页
以代替错误堆栈跟踪。 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
-----------------------------------------------------------------------
浏览站点的错误:
Server Error in '/' Application.
--------------------------------------------------------------------------------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 5032: this.Adapter.SelectCommand = this.CommandCollection[3];
Line 5033: BATABASE.articleDataTable dataTable = new BATABASE.articleDataTable();
Line 5034: this.Adapter.Fill(dataTable);
Line 5035: return dataTable;
Line 5036: }
Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a43efdb5\a2f00bbb\App_Code.puwhmves.1.cs Line: 5034 Stack Trace:
[OleDbException (0x80004005): Selected collating sequence not supported by the operating system.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +267
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +192
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +48
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +106
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +111
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) +141
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107
BATABASETableAdapters.articleTableAdapter.GetDataBytop4() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\a43efdb5\a2f00bbb\App_Code.puwhmves.1.cs:5034
zuijingenxin.Page_Load(Object sender, EventArgs e) in d:\Users\singup-1\zuijingenxin.ascx.cs:21
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
--------------------------------------------------------------------------------
注意 前提是我在本地机器上可以运行的
在首页我检索了数据库中的几行数据!
急盼高手出现
---------------------------------------------------------------------
web.config中<configuration>
<appSettings>
<add key="AccessString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="></add>
<add key="DataBase" value="../Data/Data.mdb"></add>
</appSettings >
<connectionStrings/>
------------------------------------------------------------------------------------
使用方法: protected void Button1_Click(object sender, EventArgs e)
{
string AccessString = ConfigurationManager.AppSettings["AccessString"].ToString();
string DataBase2 = ConfigurationManager.AppSettings["DataBase"].ToString();
OleDbConnection myconnection = new OleDbConnection(AccessString + System.Web.HttpContext.Current.Server.MapPath(DataBase));
myconnection.Open();
........
}
有两个猜测,一、数据库路径问题;二、this.Adapter.SelectCommand = this.CommandCollection[3]; 这句话中某些技术vwdhosting.net的空间暂不支持问题
<appSettings/ >
<connectionStrings >
<add name="databaseConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ¦DataDirectory ¦\database.mdb;" providerName="System.Data.OleDb"/ >
</connectionStrings >
<system.web > 这样的 在本地机器上也可以啊没什么问题啊 要是放到空间里面这里面的Data Source= 应该怎么写?
<appSettings/ >
<connectionStrings >
<add name="databaseConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ¦DataDirectory ¦\database.mdb;" providerName="System.Data.OleDb"/ >
</connectionStrings >
<system.web >
路径这样写不可以么 怎么写?
<connectionStrings>
<add name="BBSConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\BBS.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
</connectionStrings>
可以这么写啊。
但是你应该看看你服务器上的目录结构是不是和你自己电脑上一样啊。
例如我的域名就指向ip/wwwroot/
那么目录WWWROOT就是根目录,不管WWWROOT在硬盘的什么目录下面!