Teodorico Morell
4/10/2002 10:24:00 PM
Using ODBC or OleDB, all the fields that are NUMBER(x) are returned as
Decimal.
The problem is that I'm writing a program that might connect to SQL Server,
Oracle and Access.
Some matches:
ORACLE SQL Server Access .net
=====================================
NUMBER(10) int long Int32
NUMBER(2) tinyint byte Byte
The .net dataype is the same for Access and SQL Server and match the
database type, but it is always Decimal for Oracle.
Any idea about how to handle a common routine to deal with this.
Thanks,
Teo