Re: Oracle Drivers
- From: "Uwa Agbonile [MSFT]" <uwaag@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 May 2005 14:54:47 -0700
What Oracle provider are you using? The Microsoft OLEDB provider for Oracle
is not guranteed to work with the Oracle 9 client due to known issues at the
Oracle OCI layer.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Uwa Agbonile[MSFT]
"Chris Fink" <ChrisFink@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C3C3824-4E09-4385-8541-EEB09864D533@xxxxxxxxxxxxxxxx
> 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!
>
>
.
- Follow-Ups:
- Re: Oracle Drivers
- From: dpasella
- Re: Oracle Drivers
- References:
- Oracle Drivers
- From: Chris Fink
- Oracle Drivers
- Prev by Date: Inserting data into a password protected Access database.
- Next by Date: Autonumber field alway set to 0 using OLEDB? Using ODBC works fi
- Previous by thread: Oracle Drivers
- Next by thread: Re: Oracle Drivers
- Index(es):
Relevant Pages
|
|
