Is MDAC2.1 working with Oracle 7.3.4 ?

From: Sheldon Wang <swang_at_online-can.com>
Date: Thu, 30 Mar 2000 11:41:54 -0700
Message-ID: <38e39fc0_6@news.cadvision.com>

I ran into an interesting problem with my VB5.0 app that uses MDAC2.1 to connect to Oracle 7.3.4. The app uses an ADODB.RECORDSET to update a table in Oracle 7.3.4. However, it seems that the RECORDSET can not update a number field in the table if the number had decimals. For instance, the field is defined as NUMBER(4.2), the following update causes error: ORA-01722 invalid number.

recordset.Fields(FieldName).Value = 1.01 (no problem if this value is a whole number, say, 29)

recordset.Update

Strangely, previously I was using MDAC2.0. Everything worked fine. The version of msorcl32.dll in MDAC2.0 is 2.573.2927.0 which works. The version of msorcl32.dll in MDAC2.1 is 2.573.4202.0 which does not work.

Thanks very much in advance.

Sheldon Wang Received on Thu Mar 30 2000 - 12:41:54 CST