Error in connection: could not find installable ISAM

I have followed the solution my Microsoft and other sites none work.

here is my code

Code:

---

private void tbPunch_Click(object sender, System.EventArgs e)
                {
                       
                        String conString = " ";       
                        try
                        {
                                //contructor accepts the database path
                               
                                conString=@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Documents and Settings\Me\My Documents\Visual Studio Projects\DB\testDB.mdb";
                                                               
                                DataSet oDS = new DataSet();
                                con = new OleDbConnection(conString);
                                con.Open(); ***** this is where the error is
                                OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
                                myDataAdapter = new OleDbDataAdapter("Select * From clockTable", con);

                                OleDbCommandBuilder myCmdBuilder = new OleDbCommandBuilder(myDataAdapter);
                               
                                myDataAdapter.Fill(myDtPunch);
                                this.ShowCurrentRecord();
                        }
                        catch (Exception ex)
                        {
                                MessageBox.Show("conString = " + conString + " Error in connection : "+ex.Message);
                        }
                        finally
                        {
                                // dispose of open objects
                                if (con != null)
                                        con.Close();
                        } //finally
                }

                private void ShowCurrentRecord()
                {
                        if (myDtPunch.Rows.Count==0)
                        {
                                test1.Text = "No Entries";
                                test2.Text = "No Entries";
                                return;
                        }
                        test1.Text = myDtPunch.Rows[rowPosition]["IDnum"].ToString();
                        test2.Text = myDtPunch.Rows[rowPosition]["position"].ToString();
                }

---

Anyone know how to fix this, its put a huge halt in me continuing,

thanks

What's the error?

could not find installable ISAM

Solved Your Problem ?

Your Connection String is wrong ....

wrong :

Code:

---

conString = @"Provider=Microsoft.JET.OLEDB.4.0;DataSource=.....";

---

correct : --

Code:

---

conString = @"Provider=Microsoft.JET.OLEDB.4.0;Data Source=.....";

---

Ill give that a try.

A lot of the tutorial sites and books i read all say DataSource which is odd if it doesnt work. Plus the error generated suggests that it a wrong error should say something like : ERROR: invalid connection string.

Ill let you know how it works out.

BTW you have created one object and then another

Code:

---

OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();
myDataAdapter = new OleDbDataAdapter("Select * From clockTable", con);

---

Code:

---

OleDbDataAdapter myDataAdapter = new OleDbDataAdapter("Select * From clockTable", con);

---

Thanks again.

Im learning ADO.net from web tutorials, cant find a decent one yet so if anyone can recommend a good site to get me up to speed on using ADO.NET to do things such as

Query Selects
modify
insert
Remove
Display data
Display data in a dtagrid

anything else of importance.

Thanks

That did the trick thanks a ton.