Re: Clipper---Oracle

In <steinber.29_at_cc.und.ac.za> steinber_at_cc.und.ac.za (Michael Steinberg) writes:

>Hi,
 

>I am looking for info on the best way to use
>my Oracle files in Clipper applications.
 

>Is SQL Net the way to go, what options are there ???

I am new to Oracle but have used Clipper for many years. I have just finished installing the sqlnet for my workstation so that I can test the Gupta frontend  (windows) using an Oracle backend on unix (wowa, what a memory hog... SQL net that is).

It comes with utilities to move data back and forth between oracle and PC apps files but unless you write some C code to talk to the SQL*NET api you probably will have a hard time accessing the data directly from your clipper app.

Rather than working with SQL LOADER to move data from clipper to oracle I wrote some code to figure out the structure and create all the SQL statements in clipper to move the data from clipper to the unix box. At this point you could use SQLplus (talking sqlnet to the server )_ to send the data up. Because of the overhead with using sqlnet I FTP the file up to the unix box and run the script there.

    2
-- C --
chris.claborne_at_sandiegoca.ncr.com Received on Thu Mar 19 1992 - 03:56:15 CET