无法使用oledb为csv文件打开连接

本文关键字：文件 连接 csv oledb | 更新日期: 2023-09-27 18:18:51

我使用这个函数从csv文件获取数据集:

public static DataSet GetDataset(string filePathName, string fileName, string fieldNames)
    {
        OleDbConnection CSVConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePathName + ";Extended Properties='text;HDR=Yes;FMT=Delimited(,)';");
        OleDbCommand CSVCommand = new OleDbCommand(@"SELECT " + fieldNames + " FROM [" + fileName + "]", CSVConnection);
        OleDbDataAdapter CSVAdapter = new OleDbDataAdapter(CSVCommand);
        DataSet CSVDataSet = new DataSet();
        try
        {
            CSVConnection.Open();
            CSVAdapter.Fill(CSVDataSet);
            return CSVDataSet;
        }
        catch(Exception ex)
        {
            return CSVDataSet;
        }
        finally
        {
            CSVConnection.Close();
            CSVConnection.Dispose();
        }
    }

但是，我在服务器上使用oledb提供程序读取csv文件时出现以下错误

消息:未指定错误StackTrace:在System.Data.OleDb.OleDbConnectionInternal.constr, OleDbConnection连接)System.Data.OleDb.OleDbConnectionFactory.CreateConnection (DbConnectionOptions对象池groupproviderinfo, DbConnectionPool池，DbConnection owningObject) atSystem.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection (DbConnectionowningConnection, DbConnectionPoolGroupSystem.Data.ProviderBase.DbConnectionFactory.GetConnection (DbConnectionowningConnection)System.Data.ProviderBase.DbConnectionClosed.OpenConnection (DbConnectionouterConnection, DbConnectionFactory, connectionFactory)System.Data.OleDb.OleDbConnection.Open() at DB。GetDataset(字符串filePathName, String fileName, String fieldNames)

无法使用oledb为csv文件打开连接

查看连接字符串的模板将有助于找出问题。试着看看这里的连接字符串格式

相关文章：