Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing database via ODBC vs Net8 (sqlnet)
Hi Jim,
There must be some misunderstanding here.
First of all, RDO is an ODBC replacement, you shouldn't need to use ODBC if
you are using ODBC.
Secondly, ODBC still needs sqlnet.
The best alternative to this setup would be using Oracle Objects for OLE. This comes with every Oracle client, is a RDO/DAO like interface to Oracle, and calls sqlnet *directly*. No ODBC, no RDO, and more native Oracle features.
So, reconfigure sqlnet: a big no, no
Coding changes using Oracle Objects for OLE: yes, probably some.
Hth,
Sybrand Bakker, Oracle DBA
"Jim Day" <day_at_nettally.com> wrote in message
news:8lo9ar$792$1_at_server.cntfl.com...
> Currently our developers write VB6 apps to access our Oracle database
(8.0.5
> running on Solaris 2.6). They are using RDO and the Oracle ODBC drivers.
> Someone recently told me that at their site they were using VB apps to
> access their Oracle database and using the native Net8 (SQL*Net) drivers
to
> access the database and that it was "orders of magnitude faster than
ODBC".
>
> Can someone send me in the right direction to read more about this and/or
> send a link to any documents on this? Also, if you know of any docs that
> discuss the Net8 interface and how to install/configure this so our apps
can
> access Oracle in this fashion. I have installed the Oracle client on our
> PCs (which is using Net8, right?), but what else has to be done. I'm sure
> the programmers don't want to have to make any coding changes but I
believe
> the person that gave me the information about Net8 native access to Oracle
> that they did not have to make any programming changes. I hope all this
> makes sense...
>
> Any help/suggestions are appreciated!
>
> --
> Jim Day
> day_at_nettally.com
>
>
Received on Thu Jul 27 2000 - 00:00:00 CDT