Visual Basic&database, Help with ORACLE ODBC drivers

Help with ORACLE ODBC drivers

Author	Message
Rick Pittar #1 / 3	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

Mark Wagon #2 / 3	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

Richard Borr #3 / 3	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

Page 1 of 1

[ 3 post ]