Re: Multiple PC's and PO7?

John Thompson wrote in message <35ad5af4.854500150_at_news.mindspring.com>...
>I've developed a PO7 application on a stand alone PC. The application
>is running at a remote site (about 125 miles away). Recently, the
>site installed a small LAN, three Win95 PC's sharing drives peer to
>peer. I've been given to understand, both by Oracle and readers of
>these newsgroups, this it is technically feasible to access the PO7
>database from more than one PC. This assumes that a listener is
>running on the "server" and that the "client" PC's are properly
>configured relative to tnsnames and sql*net. I also understand that I
>would only be able to have one active connection at a time.
>

This is not true. Although _officially_ Oracle consider this as a "bug", you may always have more than one connection at a time. It simply works (at your own risk, as this is _definitely_ not supported by Oracle).

<snip>
>
>Here are my issues:
>
>Do I subject my users to a sub-optimum environment (no concurrent
>users) or do I subject myself to an administrative nightmare (trying
>to be a DBA from 125 miles away)?
>

IMHO, concurrent users.

>Would administering an enterprise version of the database really BE an
>administrative nightmare? So far the entire database is only 2000
>records (.5 MG) and will grow by only several thousand records per
>year.

No.

>Should I explore PO8?
>

Yes. Of course.

>Opinions? Suggestions? Pearls of wisdom? Flames? (Uh, on second
>thought, no flames.)

For getting multi-user support from Oracle, you should try a version of 7.3 or 8.0,8.1 instead of PO7, PO8.

>Thanking you in advance,

NP

>
>John Thompson
>
>

Thanos Tsakonas Received on Thu Jul 16 1998 - 16:44:16 CEST