Oracle three tier / OLE thoughts and questions

From: <rossk_at_ihug.co.nz>
Date: 1997/03/11
Message-ID: <858075978.29137_at_dejanews.com>#1/1


Hello again

[Quoted] I am very interested to hear from and swap ideas with anyone who has experience of implementing a three tier client server solution using Oracle 7 on Windows NT and Visual Basic 4 remote OLE objects.

As another post explains, I am moving data from an Access application to Oracle. ODBC isn't working too well so we may be moving to the next step, a three tier solution, quicker than we had planned.

Does remote OLE really work properly?

Is Oracle OLE Objects the best simplicity / performance tradeoff for communicating with the database? My initial experience suggests that it is quite stable and reliable and, of course, designed specifically for Oracle. Some things could be coded in PL/SQL for performance.

Our server is currently running NT 3.51. Is there much advantage in going to NT 4 so we can use DCOM?

Is an object pool manager the way to go? I've seen what looks like a good article in VBPJ which describes a pool manager written in VB 4.

We want to do some operations remotely via modem. It is mainly requesting a report (a spreadsheet generated with Excel using OLE automation) or telling the system to start a process. My thoughts are to email a request (we have MS Exchange) to the server which emails back the result rather than trying to do remote OLE via RAS. The time delay is acceptable and any old SMTP email package would work at the client.

Any good books, white papers etc on the subject?

Another alternative is an http based intranet approach. Any thoughts?

Thanks for any advice

Ross Keatinge
Auckland, New Zealand
rossk_at_ihug.co.nz

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Tue Mar 11 1997 - 00:00:00 CET

Original text of this message