Help with ORACLE ODBC drivers 
Author Message
 Help with ORACLE ODBC drivers

I am trying to use Oracle ODBC driver to access stored
procedures and get values returned from those procedures.  
From reading the documentation, it appears that Oracles
ODBC drivers are only level 1 compliant and to get
the out parameters requires level 2 support.

Does anyone know if this is correct, and if so what work
around is there?  Are there other ODBC drivers available?  
I am using version 1.11.0.2

Thanks for any feedback.



Fri, 18 Dec 1998 03:00:00 GMT  
 Help with ORACLE ODBC drivers

Quote:

>I am trying to use Oracle ODBC driver to access stored
>procedures and get values returned from those procedures.  
>From reading the documentation, it appears that Oracles
>ODBC drivers are only level 1 compliant and to get
>the out parameters requires level 2 support.
>Does anyone know if this is correct, and if so what work
>around is there?  Are there other ODBC drivers available?  
>I am using version 1.11.0.2
>Thanks for any feedback.

Yes, you are right.  Supposedly, version 2 of the Visigenic driver
(not the one that ships with Vb4) works with stored procedures.  But I
haven't tried it personally.

--
Mark Wagoner



Sat, 19 Dec 1998 03:00:00 GMT  
 Help with ORACLE ODBC drivers

Quote:

>I am trying to use Oracle ODBC driver to access stored
>procedures and get values returned from those procedures.  
>From reading the documentation, it appears that Oracles
>ODBC drivers are only level 1 compliant and to get
>the out parameters requires level 2 support.

If you mean returning data (as opposed to return codes) I don't think
it is possible to get an Oracle stored procedure to return data.  This
is just Oracle and nothing to do with VB.  But I may be wrong !

As for ODBC drivers we have been trying for the last 6 months to get a
reliable and fast ODBC driver - you know, like MS do for SQL Server -
so that we can get VB and our web server hooked up to Oracle.  Oracle
can't even spell ODBC.  I don't think they are interested unless you
are using their development tools.

Regards

Richard



Mon, 21 Dec 1998 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Oracle ODBC driver / Microsoft ODBC driver for Oracle

2. HELP on connection to Oracle with Microsoft ODBC for Oracle Driver

3. Help with ODBC Driver for Oracle

4. Help regarding Quotemarks inserted by the MS ODBC Driver for Oracle

5. Need help finding reliable Oracle ODBC driver

6. help odbc oracle driver

7. 16bit Odbc driver for Oracle

8. Where Can I Get Oracle ODBC driver

9. Oracle ODBC Driver

10. problem with odbc driver for oracle 2.5

11. High-Performance ODBC Drivers For Oracle

12. From ODBC driver to Oracle

 

 
Powered by phpBB® Forum Software