水晶报表提示要输入用户名密码?我用的是access数据库

[wyjhyf85583826]

代码:
public void dbSelect()
{
//string strSql = "SELECT cxpx.ID, cxpx.sname, cxpx.sex, cxpx.age, cxpx.address, cxpx.idcard, cxpx.tel, format(cxpx.pxdate,'yyyy-mm-dd') as pxdate,cxpx.pxtime , pxadd.name FROM (cxpx RIGHT OUTER JOIN pxadd ON cxpx.pxadd = pxadd.code)";
string strSql = "SELECT sname,sex,idcard,age,address,pxllcj,pxsccj,pxkno,pxhgzno FROM cxpx";
if (ViewState["start"].ToString() != "" && ViewState["end"].ToString() != "")
{
strSql += " where cxpx.pxdate between #" + ViewState["start"].ToString() + "# and #" + ViewState["end"].ToString() + "#";
}
OleDbConnection conn = new OleDbConnection(connString);
try
{
conn.Open();
DataSet ds = new DataSet();
OleDbCommand comm = new OleDbCommand(strSql,conn);
OleDbDataAdapter adp = new OleDbDataAdapter(comm);
adp.Fill(ds,"cxpx");
CrystalReportSource.ReportDocument.Load(Server.MapPath("cxpxCountPrintReport.rpt"));
Show(this, Server.MapPath("cxpxCountPrintReport.rpt"));
CrystalReportSource.ReportDocument.SetDataSource(ds.Tables["cxpx"]);
CrystalReportSource.DataBind();
CrystalReportViewer1.ReportSource = CrystalReportSource;
CrystalReportViewer1.DataBind();
}
catch(Exception ex)
{
Show(this,ex.ToString());
}
finally
{
conn.Close();
}
}

[zhaoxiaoyang5156]

楼上正解。 换成相对路径吧。

[xwdd129]

OleDbConnection conn = new OleDbConnection(connString);

你的connString里要把用户名信息加上，如：
Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=你的数据库路径;User ID=Admin;Password=;

[wyjhyf85583826]

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|xgzg.mdb;Persist Security Info=True" providerName="System.Data.OleDb

我的OleDbConnection如上,在debug下是可以显示的,可是发布到服务器上就显示加载路径错误.我的代码中用的是绝对路径.现在不知道该怎么办?