I've also been having problems with Oracle using
both DAO and RDO in VB 6.
Connecting seems to work ok, but UPDATEing
recordsets (and resultsets) with the Oracle ODBC
Driver version 8.000.0500 always seems to give
the following error:
S1C00 ODBC Library not Capable.
The solution I found was to change over to
Microsoft's ODBC for Oracle driver (version
2.573.292700). Maybe this will work for you as
well.
Mike Fasano
Invision Research
Quote:
> Dear All:
> I am trying to use RDO to connect to Oracle
database, but I always have
Quote:
> errors with ODBC. I am using Visual Basic
6.0. Does it matter which
Quote:
> version of ODBC drive I am using? (mine is
1.15, the older one).
Quote:
> I appreciate all your responses.
> Kind regards
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---