Loading ...

Unable to connect csv file using oledb provider

Who is online?  0 guests and 0 members
home  »  forums   »  asp.net topics   »  data access   » Unable to connect csv file using oledb provider

Unable to connect csv file using oledb provider

Posts under the topic: Unable to connect csv file using oledb provider

Posted: 12/28/2011

Lurker 5  points  Lurker
  • Joined on: 12/27/2011
  • Posts: 1

Hi,

I am using this function to get dataset from csv file:

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();
             }
}

But, I am getting following error on server while reading csv file using oledb provider

Message: Unspecified error
StackTrace: at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at DB.GetDataset(String filePathName, String fileName, String fieldNames)


tags ASP.NET, C#, csv, oledb
Page 1 of 1 (1 items)