That is just a question of common sense:confused: rahul

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

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!

thanks.. its now running. But the problem is that i cant save data on the database. The exception is that the provider=DB2OLEDB is not available in the local machine. it highlights the statement where i insert values. thanks.

Within Visual Studio, if you have more than one project in your solution, and hit the icon (or the key combination) to run, it will execute the one project "set as startup project" (context menu item in solution explorer pane). Maybe you have forgotten to set it to the one you want to run ? :) Luc Pattyn [My Articles]