OdbcDataAdapter.Fill Scientific Notation

From: Matthew Schwarz <matthew.schwarz_at_gmail.com>
Date: 3 Aug 2005 08:31:57 -0700
Message-ID: <1123083117.896806.97310@g14g2000cwa.googlegroups.com>

Hello,

I am writing a VB.NET application which uses the System.Data.ODBCDataAdapter to query data from an Oracle database.

There is a column in the database defined as NUMBER(19,4). I am attempting to use ODBCDataAdapter.Fill() to select all of the values from this column. However, I run into a problem when the values are very large and Oracle starts returning the values in Scientific Notation (i.e. 1.000E+14).

When using the Oracle ODBC driver version 9.02.00.54, this throws a "Input String Was Not In A Correct Format" error. However on another computer, connecting to the same database, executing the query in the same manner, only using driver version 9.02.00.00, the query works perfectly.

Is there any way to change the way the value is returned with 9.02.00.54 so that the value is returned in the same way as with 9.02.00.00?

Thank you,
Matt Received on Wed Aug 03 2005 - 10:31:57 CDT