unable to connect to Access DataBase

[ezhar]

try
        {
            OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ikcit.mdb");
            OleDbDataAdapter da = new OleDbDataAdapter();
            da.InsertCommand = new OleDbCommand("Insert into student values(@name,@address,@spno,@smail,@domain,@course)", con);
            da.InsertCommand.Parameters.Add("@name", OleDbType.VarChar).Value = TextBox1.Text;
            da.InsertCommand.Parameters.Add("@address", OleDbType.VarChar).Value = TextBox2.Text;
            da.InsertCommand.Parameters.Add("@spno", OleDbType.Numeric ).Value = TextBox3.Text;
            da.InsertCommand.Parameters.Add("@smail", OleDbType.VarChar).Value = TextBox4.Text;
            da.InsertCommand.Parameters.Add("@domain", OleDbType.VarChar).Value = DropDownList1.Text ;
            da.InsertCommand.Parameters.Add("@course", OleDbType.VarChar).Value = DropDownList2.Text ;
            con.Open();
            da.InsertCommand.ExecuteNonQuery();
            con.Close();
 
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }

When I am trying to insert some data I am getting error.


Could not find file 'C:\WINDOWS\system32\ikcit.mdb'.

Unable to understand Why??
Thanx in advance

[Frinavale]

Change your Connection String so that Data Source is pointing to the path where the ikcit.mdb file is located.

-Frinny

[ezhar]

Is it not possible to add virtual path rather then physical path?

[Frinavale]

I don't know...
Sorry.


-Frinny

[pod]

you could setup your path in the project properties under the Settings tab, and call for it by name:

OLEconn.ConnectionString = My.Settings.MyDatabase

Project->Properties->Settings->ConnectionString :

..but you would still have to provide either a relative or absolute path to your database... I think it is better practice to use an absolute path ...although, if you do not wish, try removing the double backslash from your path

"Data Source=ikcit.mdb"

[ezhar]

Thanx for the reply
but i got the answer and it is bit simple
http://csharpbyansari.blogspot.com/