在线等，C# 读取excel文件时报错 ”ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默“

[shiguangfeishi]

VS运行程序就会报错，如果IIS发布就不会
因为需要跟踪，必须要用VS运行，程序和错误如下

if (File.Exists(AppDomain.CurrentDomain.BaseDirectory
+ "UploadedFiles\\" + filename) == false)
{
throw new Exception("服务器目录找不到需要导入的文件");
}

DataTable dt = new DataTable();
string fileExtension = System.IO.Path.GetExtension(filename).ToLower();

try
{
OdbcConnection Connnection = new OdbcConnection();

String strExcelConn = "";

strExcelConn = "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);" +
"UID=admin;" +
"UserCommitSync=Yes;" +
"Threads=3;" +
"SafeTransactions=0;" +
"ReadOnly=1;" +
"PageTimeout=5;" +
"MaxScanRows=8;" +
"MaxBufferSize=2048;" +
"FIL=excel 12.0;" +
"DriverId=1046;" +
"DBQ=" + AppDomain.CurrentDomain.BaseDirectory + "UploadedFiles\\" + filename;

Connnection.ConnectionString = strExcelConn;

OdbcCommand cmd = new OdbcCommand();
cmd.Connection = Connnection;
cmd.CommandText = "SELECT * FROM [SHEET1$]";
Connnection.Open();

OdbcDataAdapter oda = new OdbcDataAdapter(cmd);
oda.Fill(dt);

Connnection.Close();
}
catch (Exception ex)
{
throw ex;
//throw new Exception("无法读取表格数据");
}

[_小黑_]

推荐使用 npoi 导入导出 excel

[homesos]

同楼上，我也推荐用NPOI，挺好用，对环境也没有依赖。

[秋的红果实]

没用过这种连接方式 strExcelConn = "DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);" + "UID=admin;" + "UserCommitSync=Yes;" + "Threads=3;" + "SafeTransactions=0;" + 检查下你当前程序所在位置，会不会是文件访问权限问题 检查你的程序要想运行，需要哪些IIS级的配置 从错误提示看，是连接excel的问题，还要检查excel文件是不是已经打开