I am running the Oracle 9.02 driver in development, which is working fine
with the following statement.

#region Add Inbound Transaction
// for valid requests, insert transaction into table: INBOUNDTRANSACTIONS
// returns boolean indicating success
public bool addInboundTransaction(string structureID, string msgIn, string
status, string lastUpdatedBy, string originatingID, string hostSystem)
{
OleDbConnection cn = new OleDbConnection(DataSource);

string sql = "INSERT INTO TABLENAME (TABLEROWID, STRUCTUREID, STATUS,
LASTUPDATEDBY, MSGIN, ORIGINATINGID, HOSTSYSTEM) VALUES (IBTXN_SEQ.NEXTVAL,
:1,:2,:3,:4,:5,:6)";

OleDbCommand cmd = new OleDbCommand();
cmd.CommandTimeout = CommandTimeOut;
cmd.CommandText = sql;
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;

OleDbParameter p1 = cmd.Parameters.Add("strucID", OleDbType.VarChar,50);
p1.Direction = ParameterDirection.Input;
p1.Value = structureID.Trim();

OleDbParameter p2 = cmd.Parameters.Add("status", OleDbType.VarChar,50);
p2.Direction = ParameterDirection.Input;
p2.Value = status.ToUpper().Trim();

OleDbParameter p3 = cmd.Parameters.Add("lastUpdatedBy",
OleDbType.VarChar,50);
p3.Direction = ParameterDirection.Input;
p3.Value = lastUpdatedBy.ToUpper().Trim();

byte[] ba = stringToByteArray(msgIn);
OleDbParameter p4 = cmd.Parameters.Add("blobData", OleDbType.Binary,
ba.Length);
p4.Direction = ParameterDirection.Input;
p4.Value = ba;

// the ip/dns address of the system making the request (like http_referrer)
OleDbParameter p5 = cmd.Parameters.Add("originatingID",
OleDbType.VarChar,50);
p5.Direction = ParameterDirection.Input;
p5.Value = originatingID.ToUpper().Trim();

// the name of the host system (http, websvcs)
OleDbParameter p6 = cmd.Parameters.Add("hostSystem", OleDbType.VarChar,50);
p6.Direction = ParameterDirection.Input;
p6.Value = hostSystem.ToUpper().Trim();


cn.Open();
cmd.ExecuteNonQuery();
cn.Close();

return true;
}
#endregion

But, when trying to run this same code from test system, which is running
Oracle driver 8.01.07, I am receiving this error: "ORA-01036: illegal
variable name/number"

Is there something I can do to fix my SQL so it runs properly using the 8.01
driver? Or is it possible to install the 9.02 driver on test without
disrupting the current apps that are using 8.01? - not a highly supported
solution by other developers on my team. Or can I run these drivers side by
side on the same machine? Ideally, I can identify what is causing this code
to fail using the 8.01 driver and just redo the SQL.

Thanks for the assistance!