please check the code.. there's an error in adding a record in the database...
-
OleDbConnection connect=new OleDbConnection(); connect.ConnectionString="Provider=DB2OLEDB; initial catalog=SAMPLE;integrated security=SSPI,user id=db2admin;password=eugene09"; connect.Open(); OleDbCommand cmd_save =new OleDbCommand("INSERT INTO test(name,year,course)"+"VALUES("+"'"+textBox1.Text+"'"+","+"'"+textBox2.Text+"'"+","+"'"+textBox3.Text+"'"+")",connect); int intRow=cmd_save.ExecuteNonQuery(); if(intRow>0) { MessageBox.Show("Record added"); } connect.Close(); this is a program i created adding a record in the database but their is no error but an exception, saying " DB2OLEDB is not existing in the local machine." i think the problem is in the insert command. thanks for all the help!
-
OleDbConnection connect=new OleDbConnection(); connect.ConnectionString="Provider=DB2OLEDB; initial catalog=SAMPLE;integrated security=SSPI,user id=db2admin;password=eugene09"; connect.Open(); OleDbCommand cmd_save =new OleDbCommand("INSERT INTO test(name,year,course)"+"VALUES("+"'"+textBox1.Text+"'"+","+"'"+textBox2.Text+"'"+","+"'"+textBox3.Text+"'"+")",connect); int intRow=cmd_save.ExecuteNonQuery(); if(intRow>0) { MessageBox.Show("Record added"); } connect.Close(); this is a program i created adding a record in the database but their is no error but an exception, saying " DB2OLEDB is not existing in the local machine." i think the problem is in the insert command. thanks for all the help!
icesha wrote:
an exception, saying " DB2OLEDB is not existing in the local machine." i think the problem is in the insert command. thanks for all the help!
The error message (incorrectly copied as it is) suggests the connection in the source of the problem. Have you installed DB2 on your local machine?
Upcoming events: * Glasgow: Geek Dinner (5th March) * Edinburgh: Web Security Conference Day for Windows Developers (12th April) My: Website | Blog | Photos