reading Html file through OLEDB fails

Question

i am trying to read html file through OLEDB reader using following code

DataTable dTable;
string strDataSource = "";
string strDBFile = "";
long intPos = 0;
strDataSource = mstrFilePath;
dTable = new DataTable();
mCon = new System.Data.OleDb.OleDbConnection();
mCon.ConnectionString  = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + openFileDialog1.FileName + ";Extended Properties=\"HTML Import;HDR=NO;IMEX=1\";");     
if (mCon.State == ConnectionState.Closed)
{
    mCon.Open(); // gettting failed here
}
dTable = mCon.GetSchema("Tables");
        bSelectionChanged = true;
        lstTables.Items.Clear();
        foreach (DataRow DRow in dTable.Rows)
        {

            if (DRow["TABLE_TYPE"].ToString() == "TABLE" || DRow["TABLE_TYPE"].ToString() == "VIEW")
            {
                intPos = DRow["TABLE_NAME"].ToString().LastIndexOf("FilterDatabase");
                lstTables.Items.Add(DRow["TABLE_NAME"]);
            }
        }
        if (lstTables.Items.Count == 1)
        {
            lstTables.Visible = false;
            grdSampleDataControl.Dock = DockStyle.Fill;
        }
        else
        {
            lstTables.Visible = true;
            grdSampleDataControl.Dock = DockStyle.None;
        }
        bSelectionChanged = true;
        dTable.Dispose();
        mCon.Close();
        openFileDialog1.Dispose();

It is getting failed here wiht exception\

The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

But file is not opened anywhere ??

Edit

On debug, When it throws exception at mCon.Open(), If i press F10 compiler moves to next statement and run the programm succesfully. why it is so ??

could it be the `openFileDialog1` that maybe needs to be disposed? — Jens Kloster, May 28 '13 at 05:47
@FurkanEkinci i am not opening it anywhere using `openFileDialog1`.. I am using `openFileDialog1` to just read file name. File is not opened anywhere — Rajeev Kumar, May 28 '13 at 05:47
@FurkanEkinci access means what ?? Are you talking about Connection !!! — Rajeev Kumar, May 28 '13 at 05:48
@FurkanEkinci File Path is `D:\Projects\CDR_RAW_FILES\8435921487.htm` — Rajeev Kumar, May 28 '13 at 05:50
@RajeevKumar I mean MS Access. Sometimes people close all windows in MS Access and guess closed access file. — Furkan Ekinci, May 28 '13 at 05:50
Can you try to use hard code path? Use **D:\Projects\CDR_RAW_FILES\8435921487.htm** instead of **openFileDialog1.FileName** — Furkan Ekinci, May 28 '13 at 05:57
openFileDialog may be causing the error like @JensKloster said. — Furkan Ekinci, May 28 '13 at 06:00
I'm trying to get same error, so what kind data your html file store? — Furkan Ekinci, May 28 '13 at 06:23
@FurkanEkinci Is there any option of attaching file in stackoverflow. So i can attach sample html — Rajeev Kumar, May 28 '13 at 06:25
@RajeevKumar I found a sample data from [here](http://ewbi.blogs.com/develops/2006/12/reading_html_ta.html) and tried to open connection. It worked correctly. Does you data format look like in link? — Furkan Ekinci, May 28 '13 at 06:26
@RajeevKumar you can share here (in question) an instance of your data format. — Furkan Ekinci, May 28 '13 at 06:28
@FurkanEkinci Just like that. But in my case, Why compiler on pressing F10 Ignore that exception ?? — Rajeev Kumar, May 28 '13 at 06:28
@FurkanEkinci try to reopen some other file or same file multiple times .. — Rajeev Kumar, May 28 '13 at 06:29
@FurkanEkinci I have added some more code. have a look at edited question — Rajeev Kumar, May 28 '13 at 06:32
Actually if you get error in **mCon.Open();** line, I think below codes are not important for now. — Furkan Ekinci, May 28 '13 at 06:37
@FurkanEkinci It is not failing in first 2-3 times actually. But if i keep on doing it for some other files it fails randomly for any file. — Rajeev Kumar, May 28 '13 at 06:39
[Here](http://screencast.com/t/BDQ5Nx5Amq) is my screencast. — Furkan Ekinci, May 28 '13 at 06:44

score 0 · Answer 1 · answered May 28 '13 at 05:51

0

This is happening because your Acccess Database file is open.

You can not keep file open, and do changes on that file dynamically.

While the program using that file is running, it tries to open that file.

But, if file is already open exclusively by user, then it fails.

Close the file, and then try to open the connection.

For other details on it, follow this DISCUSSION.

answered May 28 '13 at 05:51

Freelancer

9,008
7
42
81

But i am not openning any access database here. I am just reading HTML file ?? may be i am not getting you – Rajeev Kumar May 28 '13 at 05:52

reading Html file through OLEDB fails

1 Answers1