Re: How analagous is Personal Oracle 7.1 to the other Oracles

James Allore <allorej_at_riscan.com> wrote:

>Hi!
>
>I have a client who has asked me to look into taking their
>established MS Access program and linking it to an Oracle
>backend (they like the front end interface and want to keep
>it). I set up Personal Oracle 7 (PO7) on a Windows for
>Workgroups 3.11 machine, exported some tables from Access
>into Oracle, then reattached these tables to the Access
>program. After fighting with the combination for a while, I
>began to wonder how analagous PO7 is to other Oracle
>versions. The client is using an Oracle database on a UNIX
>box, and running it across a WAN. My PO7 seems to be limited
>to the local (Intel) computer.

That is why it is called Personal Oracle 7...

  Also, it seems like Oracle
>requires Oracle client/server software to share it across a
>network, you can't just reach across the network and connect?
>I don't know much about Oracle, but PO7 seems to be limited
>in features in comparison to other database products (i.e no
>triggers?), is it limited in comparison to "full blown"
>Oracle as well?

Stored procedures and triggers are available within the PO7 database...

My belief is that PO7 was designed to allow a developer to have a stand alone Oracle database not as a fully fledged replacement for something like Access.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_acslink.net.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year

Pink Floyd Received on Mon Aug 05 1996 - 00:00:00 CEST