OleDbException

Question

User-183221118 posted

OleDbConnection

con1 = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;data source=H://WebSite2/database/Database1.mdb;persist security info=false"

);

String insertcmd = @"INSERT INTO TPD(T_ID,T_name,T_desg,T_dep,T_email,T_cont,T_gen) Values(stnm,stnm, stbr, stdpt, stem, stct, stgn)"

;

con1.Open();

OleDbCommand cmd1 = new OleDbCommand

(insertcmd, con1);

cmd1.ExecuteNonQuery();

con1.Close();

 

Error Show at con1? what i Do

Answer 1

User1366487642 posted

what the error? please give error message that you are getting..

Answer 2

User-183221118 posted

in database no entry shows

plz send solutiion as soon as possible

error occour ASM??

Answer 3

User-183221118 posted

Error is: :  Could not find installable ISAM.

Answer 4

User3866881 posted

Hello OP：）

Change your db connstr to this——

 Provider = Microsoft.Jet.OLEDB.4.0;data source=H:\\WebSite2\\database\\Database1.mdb;persist security info=false

Answer 5

User1698673233 posted

KAILASHASERISGNR HI,

CHANGE YOUR CONNECTION

String sConn = "provider=sqloledb;server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
    
   

    OleDbConnection oConn = new OleDbConnection(sConn);
    oConn.Open();

THANKS

Answer 6

User-1199946673 posted

CHANGE YOUR CONNECTION

String sConn = "provider=sqloledb;server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
    
   

    OleDbConnection oConn = new OleDbConnection(sConn);
    oConn.Open();

SQL Express??? He is using a MDB file...

Answer 7

User-183221118 posted

i also try this but could not work

now i make data base in sql2000 and using visual studio 2010.

my code does not work no error comes to me?

but no updation on data base.

is that any one have a sample of connecting database (SQL2000 or Acess 2007 using VS2010)plz send me!!!!!!!

this my code:::

using

System;

using

System.Collections.Generic;

using

System.Linq;

using

System.Web;

using

System.Web.UI;

using

System.Web.UI.WebControls;

using

System.Data;

//SQL Database

using

System.Data.SqlClient;

//SQL Database

public

partial class Default4 : System.Web.UI.

Page

{

protected void Page_Load(object sender, EventArgs

e)

{

}

SqlConnection

con;

SqlCommand

cmd;

protected void Button1_Click(object sender, EventArgs

e)

{

string Query1;

//Query String

// Textbox1 is Student id

Query1 =

"INSERT INTO SPD (S_ID,S_name,S_branch,S_dept,S_email,S_cont,S_gen) VALUES ('" + TextBox1.Text + "','" + TextBox1.Text + "','" + DropDownList1.SelectedItem + "','" + DropDownList2.SelectedItem + "''" + TextBox4.Text + "','" + TextBox5.Text + "','" + RadioButton1.Text + "')"

;

con =

new SqlConnection("Server=.;Database=Data;uid=sa;pwd=sa;");

//Connection String

cmd =

new SqlCommand

(Query1, con);

con.Open();

//Connection Open Here

try

{

cmd.ExecuteNonQuery();

//Execute Query

con.Close();

// Close Connection

}

catch (SqlException

ex)

{

Response.Write(ex.Message);

}

Response.Redirect(

"Default.aspx"

);

}

protected void ImageButton1_Click(object sender, ImageClickEventArgs

e)

{

}

protected void Button2_Click(object sender, EventArgs

e)

{

//string stnm, stbr, stdpt, stem, stct, stgn, stedug, stedgd, stedpg, stum, stuug, stugd, stupg, stprm, stprug, stprgd, stprpg, stpym, stpyug, stpygd, stpypg, stspm, stspug, stspgd, stsppg;

//stnm = TextBox1.Text;

//stbr = DropDownList1.SelectedValue;

//stdpt = DropDownList2.SelectedValue;

//stem = TextBox4.Text;

//stct = TextBox5.Text;

//stgn=RadioButton1.Text;

//stedug = TextBox23.Text;

//stedgd = TextBox24.Text;

//stedpg = TextBox25.Text;

//stum = TextBox7.Text;

//stuug = TextBox11.Text;

//stugd = TextBox12.Text;

//stupg = TextBox13.Text;

//stprm = TextBox8.Text;

//stprug = TextBox14.Text;

//stprgd = TextBox15.Text;

//stprpg = TextBox16.Text;

//stpym = TextBox9.Text;

//stpyug = TextBox17.Text;

//stpygd = TextBox18.Text;

//stpypg = TextBox19.Text;

//stspm = TextBox10.Text;

//stspug = TextBox20.Text;

//stspgd = TextBox21.Text;

//stsppg = TextBox22.Text;

//Response.Write(stnm + stbr + stdpt + stem + stct + stgn + stedug + stedgd + stedpg + stum + stuug + stugd + stupg + stprm + stprug + stprgd + stprpg + stpym + stpyug + stpygd + stpypg + stspm + stspug + stspgd + stsppg);

}

protected void TextBox18_TextChanged(object sender, EventArgs

e)

{

}

}

Answer 8

User3866881 posted

Hello again：）

Your codes seem to be right in logic. So have you checked what's in your db?

It's an inserting statement instead of an update one, I think.

Answer 9

User-821857111 posted

or Acess 2007

The connection string for an Access 2007 (accbd file) database is:

"Provider = Microsoft.ACE.OLEDB.12.0;data source=H://WebSite2/database/Database1.mdb"