Re: Number fields - Addition 2 Solution

And just downloaded and installed MDAC v2.0 SP2 from

http://www.microsoft.com/data/

and it also started working with numeric fields, as well as the old ASP 0115 trappable error, when opening recordset with RS.Open sql, Conn, 3, 1
was also eliminated even on Win95 Personal Web Server 1.0a (PWS)

driver version is Microsoft ODBC for Oracle 2.573.292700

>
>
> Had the same trouble and in the same situation as Esther, when using
> DAO 2.0
>
> Solved by installing DAO 1.5c on top of it.
> ODBC: Microsoft driver for Oracle v2.573
>
> Regs,
> D.Buzkoff
>
> > Esther,
> >
> > As far as I know I do use ADO 2.03 (Comes with VB6) But either way it should
> be
> > anything ADO 2.xx
> >
> > Someone else recommended that I use RDO iso ADO. I have not tried it but it
> could
> > solve your problem. It is just a suggestion.
> >
> > Derick
> >
> > emunyoz_at_icr.es wrote:
> >
> > > Are you using ADO 2.0? I had the same problem with Oracle 8.0.5.2 Odbc
> driver
> > > when I updated from ADO 1.5c to 2.0.
> > >
> > > Esther
> > >
> > > Derick Burger <radimpe_at_hotmail.com> wrote:
> > > > Problem solved. The Oracle 8.00.0500 ODBC driver does not go well with
the
> > > > required fields. (does that make sence?) Instead I reverted to the MS
ODBC
> > > > for Oracle and, for the moment, it works. Could anyone explain this?
> > > >
> > > > Derick Burger
> > > >
> > > > Derick Burger wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I'm trying to extract data from a table in Oracle. There is data in
the
> > > > > table when using the Oracle SQL engine. However once I try to extract
> > > > > the data using VBScript in ASP all the tables containing fields of
type
> > > > > Number return 0 records.
> > > > >
> > > > > Are there any suggestions as to what the problem might be?
> > > > >
> > > > > Derick Burger
> > > > > radimpe_at_hotmail.com
> > > >
> > > >
> > >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 12 1999 - 15:46:01 CST