无法从链接服务器"(null)"的OLEDB访问接口"MSDASQL"获取列信息。链接服务器"(null)"的OLEDB访问接口"MSDASQL"返回了消息"[Microsoft][ODBCVisualFoxProDriver]File'2012-05-17-08-41-...

无法从链接服务器 "(null)" 的 OLE DB 访问接口"MSDASQL"获取列信息。

链接服务器"(null)"的 OLE DB 访问接口 "MSDASQL" 返回了消息 "[Microsoft][ODBC Visual FoxPro Driver]File '2012-05-17-08-41-00-482590894.dbf' does not exist."。

c#代码如下：

protected void Button1_Click(object sender, EventArgs e)

{

String fileName = FileUpload1.FileName;

String fileType = fileName.Substring(fileName.IndexOf(".") + 1);

if (!fileType.ToLower().Equals("dbf"))

{

Js.WarningMsg("请选择正确的文件类型！");

return;

}

Random random = new Random();

uploadFileFullName = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-") + random.Next(100000000, 999999999) + "." + fileType;

//Js.InfoMsg(uploadFileFullName);

FileUpload1.SaveAs(Server.MapPath("/UploadFile/YJSXX/") + uploadFileFullName);

div_upload.Visible = false;

div_daoru.Style.Clear();

}

protected void Button2_Click(object sender, EventArgs e)

{

string xxkyjgm = Session["XXKYJGM"].ToString();

string xxkyjg = commonHelper.GetXXKYJGMC(xxkyjgm);

string toTableName = "T_YJSXX_TEMP_" + xxkyjg;

string fileSource = Server.MapPath("/UploadFile/YJSXX/");

string intoTableName = "T_YJSXX_" + xxkyjg;

int flagNum = studentHelper.ToTempTable(toTableName, uploadFileFullName, fileSource);

if (flagNum > 0)

{

studentHelper.ToZSTable(toTableName, intoTableName);

commonHelper.DeleteTempTable(toTableName);

Js.InfoMsg("数据导入成功！");

//Js.GoToInfoMsg("数据导入成功", "../InsertStudentInfo.aspx");

}

else

{

commonHelper.DeleteTempTable(toTableName);//此处加上，判断表是否存在

Js.ErrorMsg("从数据表vf表导入到SqlServer数据库出错！");

return;

}

div_upload.Visible = true;

}

上传dbf文件到mssql，结果出错

vfpodbc也装好了，sql连接字符串也没错，错在哪里？

展开