Error in connection: could not find installable ISAM

[Ctwizzy]

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

here is my 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

[Krzemo]

What's the error?

[Ctwizzy]

could not find installable ISAM

[Amit_Roy]

Solved Your Problem ?

Your Connection String is wrong ....

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

correct : --

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

[Ctwizzy]

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.

[Amit_Roy]

BTW you have created one object and then another



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




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

[Ctwizzy]

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

[Ctwizzy]

That did the trick thanks a ton.