Re: Visual Basic 4 & Oracle 7

Rick Root wrote:
>
> I'm currently getting into programming at my company with Visual Basic
> 4.0
>
> We have an Oracle 7.1 database running at 16-bit due to Peoplesoft
> recommendations (we're using Peoplesoft 3, and they only certify
> Oracle at 16-bit for some reason).
>
> I am unable to install the Visigenic 32-bit driver that comes with
> Visual Basic 4.0 for Oracle databases due to some missing files,
> which it claims are required.
>
> I am, however, able to use the 16-bit Oracle drivers that I have
> installed on my system (through Crystal Reports Professional) when
> I'm running 16-bit Visual Basic 4.0. That's not particularly
> acceptible, because I want to run 32-bit Visual Basic.
>
> I'm also unable to find any particularly good information about
> 3rd party controls to access Oracle directly (we have a control
> provided by Apex Software to access Oracle directly - it worked
> under Visual Basic 3.0, but doesn't seem to work under VB4.0 - or
> perhaps it's not working with the current database version we have.)
>
> Anyway.. I've heard about something called "OCI" (Oracle Call
> Interface?) which may be helpful, but if anyone out there can
> recommend a plan of action for me to be able to access our
> Oracle database from 32-bit Visual Basic 4.0, I would appreciate the
> help! OCI, 3rd party controls, solutions to using the Visigenic
> ODBC driver.. whatever..
>
> - Rick Root
> BookCrafter's, Inc.

1. You probably have the Windows 3.1 RSF (required support files) for Oracle. You need the W95 or the NT (depending upon which one you are running) RSF for Oracle.
2. Install item #1 with the correct protocol (probably TCP/IP).
3. You should be able to use the Visigenic ODBC driver.
4. You may want to get a copy of Oracle's Ole Objects (I believe for windows 95 and NT it is in Beta). I have found from Access and VB it is signifigantly faster than ODBC from those programs. (I did NOT use Visigenic's driver; I used the ones from Oracle, the one from MS, and from Intersolv.) It is similar to (but not as complex to use) as the OCI. Anyway I like it and the syntax is fairly strainght forward.

Jim Kennedy Received on Fri Aug 16 1996 - 00:00:00 CEST