Re: Remote Oracle Access

In article <3bfj9p$e74_at_merlion.singnet.com.sg> lowcelg_at_merlion.singnet.com.sg (Low Chee Leong) writes:
>From: lowcelg_at_merlion.singnet.com.sg (Low Chee Leong)
>Subject: Remote Oracle Access
>Date: 30 Nov 1994 00:02:01 +0800
 

>Hi,
 

>I have a situation where I need to have online transactions and batch
>uploads/downloads from a front-end UNIX workstation to a remote Oracle7
>database server (UNIX machine), which are connected via leased lines
>(TCP/IP over X.25). The front-end workstation receives on-line
>transaction data from a number of PC Point-of-Sales systems, and in-turn
>updates the remote backend database with the transaction data.
 

>Would appreciate very much if anyone could provide some suggestions as to
>how I could configure the system in terms of software (SQL*Net, CDE tools,
>C programs,UNIX or other utilities?) on both the front-end workstation
>and the backend host machine. I'm particularly concerned about
>feasibility in terms of response/turnaround time and ease of implementation.
>If you have experiences in implementing or using systems with similar
>requirements, could you also share your experience?
 

>Thanks a million!
>
>Chee Leong

I'd recomend SQLNet on the front end machine and a Pro-C application. The application on the front depends to some extent on how you are getting the transactions from the POS systems. You can address the performance issue if it comes up by using arrays for your inserts.

Lawrence.... Received on Thu Dec 01 1994 - 12:47:55 CET