ORA-01455 Error using VB4 and dbGrid

I am trying to display Oracle tables using the VB4 32-bit, the Apex dbGrid, and the VB data control. This all seems to be working well with the following exception. In one of the tables a field is defined as Number(5). When I run the refresh on the data control (datCntl.Refresh) I get the following error:

[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01455: converting column overflows integer datatype.

I know what this means and I have tested it. I only get the error if the column in question has a value greater than the magical 32,767 (and I assume < -32768).

Here's some more info on the environment:

DB: Oracle 7.3
ODBC: Oracle ODBC driver supplied with the 7.3 upgrade. Server: Windows NT
Client: Windows 95

Here's the mystery (I just love a good mystery!):

If I run the same process using the Intersolv 2.12 32-bit Oracle7 ODBC driver, everything works OK even when the values are greater than 32,767.

Any suggestions on how to resolve this and still use the Oracle driver would be appreciated.

Thanks for your time.

Richard Liechty
richard.liechty_at_eds.com Received on Thu Jul 10 1997 - 00:00:00 CEST