Re: ADO dataset always empty

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 18 Dec 2001 00:22:51 -0800
Message-ID: <a20d28ee.0112180022.1e559599@posting.google.com>

sboone_at_advparadigm.com (SomeGuyInAmerica) wrote in message news:<7d434f77.0112171406.7a88771d_at_posting.google.com>...
> I am using the oracle ODBC drivers that came with oracle 8.0.5 and
> ADO 2.6 on Win2000
>
> I don't have any trouble on my old win95 and NT4.0 machines all of
> which use Oracle7 drivers.
>
> When I create a recordset I get records returned as long as I ask only
> for VarChar fields. Any time I include a field of type Number(1) the
> recordset comes back EOF true. Has anyone else seen this
> behaviour???? (Select * also returns an eof true.)

Oracle 8.0.5 = (desupported) + (not certified on Win2k and higher)

So you can expect anything

Either : upgrade to 8.1.7

downgrade the O/S to Win NT4 sp6

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Dec 18 2001 - 02:22:51 CST