Hello,
I am currently experiancing a problem with and OleDB connection to a CSV
file using C#. The file is in a folder with permissions set full to eveyone
and when users other that the administrator try to execute the following
code it returns "unspecified error" at the line containing "da.Fill(dt);".
When an admin user tries there is not a problem.
-------------------------------------------------------------
FileInfo fi = new FileInfo(@"E:\CSVFile\output.csv");
DataTable dt = new DataTable();
string optOutConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
fi.DirectoryName + ";Extended Properties='text;HDR=Yes;FMT=Delimited'";
using (OleDbConnection _OptOut = new OleDbConnection(optOutConStr))
{
string sqlTxt = "SELECT * FROM [" + fi.Name + "] WHERE [CompCounter] is
NOT NULL";
OleDbCommand cm = new OleDbCommand(sqlTxt, _OptOut);
OleDbDataAdapter da = new OleDbDataAdapter(cm);
da.Fill(dt);
}
-------------------------------------------------------------
Thanks,
-Scott