ADO 2.0: Problem with numeric fields

From: <emunyoz_at_icr.es>
Date: Wed, 10 Feb 1999 10:32:42 GMT
Message-ID: <79rn8a$5t9$1@nnrp1.dejanews.com>

Hi everybody!

I had an ASP application running with the next config:

NT4.0 + SP3
Oracle8 Odbc Driver 8.0.5.2.0
MSDAC 1.5
IIS 4.0 Recently, I decided to update to MSDAC 2.0, and my efforts has been rewarded with a critical problem: I cannot retrieve (simple) numeric values from any table. For example, the next table

create table Weird (
nField number(10) constraint pk_Weird primary key, sField varchar(40)
);

I can do "Select sField From Weird", but I cannot do nor "Select nField From Weird" neither "Select * From Weird". EOF is True in both cases.

Update to MDAC 2.1 has no effect. I was consulting the news archive, and my problem seems related to other problems with ADO 2.0 and native ODBC drivers (Oracle, Sybase). The question is: is there any solution, workaround, fix or SP, or am I doing something wrong?

Thanks
Esther.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 10 1999 - 04:32:42 CST