RDO And Oracle Odbc Driver.
Palle -
We had this same problem in our test lab with both Intersolv and
Visigenics connecting to Sybase. But Simba Technologies'
(www.simbatech.com) SimbaExpress product DOES support parameterized
statements and queries using RDO! And you're right, it is a problem
with SQLDescribeParam support in ODBC. Simba Tech has been the only one
we have found that does fully support the extensions to ODBC level 3. I
have not used it for Oracle, but I am sure they too support them.
Since we are in the middle of testing this ODBC driver, I cannot comment
on their speed. But I will let you know how the tests come out.
Stuart McClure
InfoWorld
Quote:
> To get RDO working you have to use a "better" odbc-driver than the
> Oracle driver - it does not support the required (by RDO) ODBC functions
> - and btw it's slow too.
> I have been using Intersolv's driver - it works with one exception:
> prepared statements with parameters - due to the drivers incapability to
> support the SQLDescribeParam ODBC function.
> Currently I haven't heard of any driver for Oracle7 that fully supports
> RDO! (If anyone does, please tell!)
> -Palle Toftlund
> > Hello there.
> > I'm using an oracle workgroup server database 7.3 and a visual basic
> > front-end application with RDO to access this database via ODBC.
> > I'm having problems when i try to use an OpenResultSet method. I get the
> > errors: "Driver does not suppor this funcion" and "Driver not capable".
> > The curious yhing is that i can access the database and open a recordset
> > using DAO.
> > Does anyone know what i might be doing wrong.
> > I would really appreciate some answers.
> > Thank you very much.
> > Aguiar.
