Problem connecting to Oracle using OLEDB for Oracle

From: <sunny076_at_yahoo.com>
Date: 10 May 2005 14:21:28 -0700
Message-ID: <1115760088.177015.180540@o13g2000cwo.googlegroups.com>

Hi,

I am trying to connect to Oracle database using OLEDB for Oracle but I got error "ORA-01008: not all variables bound".

The following is my code:
string conString ="Provider=MSDAORA;"+

                        "Data Source=ORATEST.SOFTWARE-LABS.N­ET;User

ID=scott;Password=tiger";

using (OleDbConnection oledbConn = new OleDbConnection(conString)){

    oledbConn.Open();
    OleDbCommand cmd = new OleDbCommand("INSERT INTO \"TEST\" (\"TESTID\", \"TESTNAME\") VALUES (:TESTID,:TESTNAME)",oledbConn­);

    cmd.Parameters.Add( new
OleDbParameter("TESTID",System­.Data.OleDb.OleDbType.Integer)­);

    cmd.Parameters.Add( new
OleDbParameter("TESTNAME",Syst­em.Data.OleDb.OleDbType.VarCha­r));

    cmd.Parameters["TESTID"].Value = 12;     cmd.Parameters["TESTNAME"].Val­ue= "Test12";     try {

        cmd.ExecuteNonQuery();
    }catch(Exception e) {

}

Can anyone tell me what was wrong and how I can solve this problem?

Thank you in advance,

Sunny Received on Tue May 10 2005 - 16:21:28 CDT