Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Best way to access Oracle databases with VB4???
I inherited a project that uses VB4-16bit with Oracle 7.x via ODBC
recently.
We are having problems with connections not releasing. My predecessor
researched the problem thoroughly but to no avail. I am still determined
to
solve this problem. If anyone has a solution for this well known problem,
please let me in on it.
Wayne Larimore
dwljr_at_ionet.net
>
> I have been doing some work with Oracle 7.3 and VB/VBA
> I have installed the Oracle ODBC driver 7.3 and the SQL*Net 2 from the
> Oracle CD.
>
> The SQL*Net 2 needs the connect information in the directory
> /ORAxx/Network/Admin. The files tnsnames.ora, sqlnet.ora and tnsnav.ora
> must be created. Consult for those your Oracle administrator. You can
> also try the SQL Net Easy configurator that comes with the Oracle
software.
>
> In VB you should use the DAO 2.5/3.x compatibility version.
> You can retrieve data from Oracle through Jet Engine with
> dbSQLPassthough set and you can make modifications to the database with
the
> ExeclueSQL command.
>
> This is enough if you intend to make reports e.g directly to Excel.
>
> Everything else seems to fail in one way or other. I have even tried the
> new VBA5 libraries with Excel 97 and the same is true there. Perhaps The
> Oracle
> link works better with the driver that Microsoft provides with VB4
> (Visigenic).
> I have used that driver too but I don't have it any more. The Visigenic
> driver fails
> after a number (about 50) of connects to Oracle.
>
> RDO cannot manage Oracle. DAO with ODBC directcannot do that either.
>
> Kaarle
>
> PS! If anybody out there knows any better ways to manage the VB/Oracle
> link I would like to hear from you. It seems that Oracle has no interest
in
> VB from MS and MS has no interest in a database from Oracle or at least
> they dont seem to have the same notes.
>