机器环境：服务器+IIS7：winserver 2008 R2 Enterprice

软件平台：Sharepoint 2010（moss2010）     系统安装office 2010 （64bit）标准版

开发的sharepoint 2010 可视webpart，在服务器本机运行一切正常。可以正常导入指定的excel（32位）制作的数据源。在局域网内PC机在进行数据导入时候报错。

已做操作：

1、应用程序池里设置“启用32位应用程序”为TRUE，或者生成项目时候any CPU 改为 X86；这样的话，moss2010应用程序池会自动停止或者无法使用；不可行。

2、权限设置：服务器上关闭简单共享，并把%system%/windows/temp权限加入everyone并给与完全控制权限，同时，服务器虚拟目录（上传的位置）也给与同样的权限；不可行。

代码如下：

public DataSet ExecleDs(string filepath,string tablename)
{
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn);
DataSet ds = new DataSet();
odda.Fill(ds, tablename);
conn.Close();
return ds;
}
/// <summary>
/// 导入运单号excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnInPut_Click(object sender, EventArgs e)
{
if (FileUploadXls.HasFile == false)
{
Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('请选择excel文件');</script>");
return;
}
string IsXls = System.IO.Path.GetExtension(FileUploadXls.FileName).ToString().ToLower();
if (IsXls != ".xlsx" )
{
Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('只可选择excel 2007以后版本');</script>");
return;
}
string filename = FileUploadXls.FileName;
string savepath = FileUploadXls.PostedFile.FileName;
DataSet ds = ExecleDs(savepath,filename);
DataRow[] dr = ds.Tables[0].Select();
int insertcount = 0;//记录插入信息条数
int exitcount = 0;//记录已存在信息条
if (ds.Tables[0].Rows.Count == 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('excel为空表，无数据！');</script>");
}
else
{
for (int i = 0; i < dr.Length; i++)
{
string StrSql = "select BillMainInfo.BillNo from BillMainInfo where BillNo='" + dr[i]["BillNo"].ToString() + "'";
DataTable dt = Conn.GetTable(StrSql);
string BillNo = dr[i]["BillNo"].ToString();
string BillStatus = "未完成";
string LastDate = SysDatetime;
string LastOperator = UserName;
if (dt.Rows.Count == 0 && dr[i]["BillNo"].ToString() != "")
{
string Sql = "insert into BillMainInfo (BillNo,BillStatus,LastDate,LastOperator) values ('" + BillNo + "','" + BillStatus + "','" + LastDate + "','" + LastOperator + "')";
Conn.ExNoQuery(Sql);
insertcount++;
}
if (dt.Rows.Count > 0 && dr[i]["BillNo"].ToString() != "")
{
exitcount++;
}
}
}
string message = insertcount + "条数据导入成功！" + exitcount + "条数据重复未导入成功！";
Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('" + message + "');</script>");
BindGv();
}

错误如下：

“/”应用程序中的服务器错误。

未指定的错误

说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.OleDb.OleDbException: 未指定的错误

源错误:

堆栈跟踪:

[OleDbException (0x80004005): 未指定的错误]
   System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1828554
   System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +100
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +45
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +6264718
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6265031
   System.Data.OleDb.OleDbConnection.Open() +47
   WPDocumentManage.VisualWebPart1.VisualWebPart1UserControl.ExecleDs(String filepath, String tablename) +210
   WPDocumentManage.VisualWebPart1.VisualWebPart1UserControl.BtnInPut_Click(Object sender, EventArgs e) +251
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +115
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +140
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981