OleDbConnection ConnectionString, issue on opening multiple files

Question

My project is to extract some attributes from a folder with .mdb to .csv files. All functions are processing properly but I have an issue with the ConnectionString.

When run for the first time, it opens the connection for the first file in folder and extracts the .csv file and closes the connection. All good so far.

Afterwards, when it goes for the second file in the folder, it somehow opens again the ConnectionString for the first file but the function calls the second .mdb file. How can I make it open the second file?

static void Main()
{
    CreateFolder();

    string dst_fld = @"C:\csv\AllCsvFiles";
    string src_fld = @"C:\mdb";
    string dst_ext = ".mdb";

    string[] mdb_array = Directory.GetFiles(src_fld, "*" + dst_ext, SearchOption.TopDirectoryOnly); // Get all mdb files from a folder

    OleDbConnection cn = new OleDbConnection();

    foreach (string tname in mdb_array)
    {
        cn.ConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}",mdb_array);

        try
        {
            cn.Open(); // open the connection
            ExportFunction(cn, tname, dst_fld); // call function for export the csv file
        }
        finally
        {
            cn.Close();
        }
    }

    GetCSVFiles();
    DeleteFF();
}

What is the error message when cn.Open() executes for the second time? — Sujeet Sinha
– Sujeet Sinha, Commented Jun 21, 2016 at 10:27
The folder contains theses files: 27001DX.mdb 27002DX.mdb the error message: The Microsoft Jet database engine cannot find the input table or query '27002DX'. Make sure it exists and that its name is spelled correctly. — athanikos
– athanikos, Commented Jun 21, 2016 at 10:33
When run for the second time, using breakpoints, cn.ConnectionString "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\mdb\\27001DX.mdb" tname "C:\\mdb\\27002DX.mdb" string — athanikos
– athanikos, Commented Jun 21, 2016 at 10:36
....0;Data Source={0}",mdb_array); instead of mdb_array, you want tname here i think? — steve16351
– steve16351, Commented Jun 21, 2016 at 10:44

Sujeet Sinha · Accepted Answer · 2016-06-21 11:00:04Z

1

As pointed by @steve16351, you need to change the connection string as follows :

cn.ConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}", tname);

answered Jun 21, 2016 at 11:00

Sujeet Sinha

2,4332 gold badges20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

OleDbConnection ConnectionString, issue on opening multiple files

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related