无法从链接服务器"(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连接字符串也没错,错在哪里?
展开