Re: Oracle Novice trying to access external data

Basically, you can't.....

SqlPlus ( which you are using when querying the Oracle database ) can only connect to Oracle databases....

You can, using ODBC, connect your dBase data to Oracle data using whatever Query or Import utilities provided with the Visual dBase product...

Also using ODBC and Oracle's Developer/2000, you can create reports and forms that use the dBase data - but it is more difficult than using Oracle data....

If possible export your dBase data and create Oracle tables out of them, and say goodbye to the legacy systems....

khooker_at_tecman.demon.co.uk (Keith Hooker) wrote:

>Having become familiar with SQL I am now trying to access some of the
>data that already exists in my legacy databases ie in Visual dBase 5.5
>and 7.0. These reside on a Novell 3.12 server and the Oracle is on a
>connected NT4 server.
>
>I have tried various methods of telling SQL what the pathway is but it
>always throws a wobbler.
>
>Keith
>khooker_at_tecman.demon.co.uk
>Whitstable, Kent, UK
>

To reply please remove the 'nospam' part of the address Received on Wed Jan 27 1999 - 10:07:16 CST