Re: Is MDAC2.1 working with Oracle 7.3.4 ?

Sheldon Wang wrote:
>
> 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

Try looking at these kb article: q216978, q188574.

The latter one suggests that you need to set the NumericScale property correctly for the column that contains the decimal value. Received on Thu Mar 30 2000 - 14:56:21 CST