AnsweredAssumed Answered

vrf VRF - Reading from an Oracle Database

Question asked by VRFuser on Sep 25, 2001
Scott,

I found an old message from the reflector describing the solution:

<start quote>
VEE can get to Oracle 7.3.4 and 8.x through a utility that is free from
Oracle.

Oracle calls this utility Oracle Objects For OLE, (oo4o for short).

It is an automation reference library that shows up in the VEE ActiveX
Automation References list as OracleInProcServer 2.3 Type Library.

Get to the Oracle web site and search for this utility.

Download the one that is appropruate for your version of Oracle.

I use Execute SQL statements in VEE to Insert records, Update fields,
Select field values, and Delete records.

That's all the functionality I needed from the Oracle database.  Decisions
based on the data can be made in VEE or special context that better
utilizes the functions and power and speed of Oracle can be programmed in
Oracle.
<end quote>

Hope this helps,

        Georg Nied
   Software-Development
Hansestr.7 - 51149 Cologne
        Germany
Mail: info@gn-software.de


> -----Original Message-----
> From: owner-vrf@lvld.agilent.com [mailto:owner-vrf@lvld.agilent.com]On
> Behalf Of Anderson, Scott
> Sent: Friday, September 21, 2001 7:31 PM
> To: Vrf (E-mail)
> Subject: vrf VRF - Reading from an Oracle Database
>
>
> Hello all,
>
> Has anyone used VEE to read from an Oracle database?
> I believe it would be something like reading from Excel using an
> ODBC link?
>
> Is there anything I should watch for that might trick me up?
> An example would be helpful.
>
> thanks,
>
> Scott Anderson
> Quality Analyst II
> ADC  Broadband Connectivity Group
> Tel : 952.403.8311
> Fax : 952.403.8560
> MS : 509
>
> scott_anderson@adc.com
>
> Learn about ADC - The Broadband Company at www.ADC.com
>
> > Mailing Address:  P.O. Box 1101, Minneapolis, MN  55440-1101
> > Office Address:  1187 Park Place, Shakopee, MN  55379
> >
> ---------------------------------------------------------------------
> This is the "vrf" maillist, managed by Majordomo.  To send messages to
> this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
> unsubscriptions are done through the address
> "vrf-request@lvld.agilent.com".
> If you need details, just send a message containing the text "help"
> to "vrf-request@lvld.agilent.com".
> ---------------------------------------------------------------------
---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.agilent.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.agilent.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.agilent.com".
---------------------------------------------------------------------

Outcomes