Re: Does Oracle + VB is a good combination

From: Clifford Buetikofer <rcbuetikofer_at_comcast.net>
Date: Wed, 15 Oct 2003 07:09:29 -0400
Message-ID: <OcSdnUg1PeSfthCiRVn-vA_at_comcast.com>


vincent delft wrote:

> Thanks Jim, 
> 
> Does your OLE experience shows you that this must be reliable enough
> for 200 concurrent users connected via a WAN ?
> 
> Other options would be to install the VB part on a Citrix. Does this
> is possible with OLE?
> 
> 
> "Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in message news:<ZH1jb.769048$YN5.751574_at_sccrnsc01>...
> 

>>"vincent delft" <vincent_delft_at_yahoo.com> wrote in message
>>news:3f8c39ed$0$15646$ba620e4c_at_reader1.news.skynet.be...
>>
>>>Hello,
>>>
>>>I must set-up an application with an Oracle Database running on Unix and a
>>>GUI running on Windows 2000/XP machines.
>>>The size of the DB is about 5GB.
>>>The application will have about 1000 users and about 200 concurrent users
>>>connected via a WAN.
>>>
>>>My management propose the combination Oracle - ODBC - Visual Basic.
>>>
>>>Does this will be stable and reliable enough ?
>>>Must I propose an another architectur ? (PowerBuilder ?, Java ?, ...)
>>>Does web based application can be cheaper (to build and maintain) than VB
>>
>> ?
>>
>>>Thanks for your feedbacks.
>>>
>>>
>>>
>>>
>>>
>>
>>If you have to go with VB I would use Oracle's Ole Objects. Fast, easy to
>>use bind variables, easy to code, supports all the native types.
>>Jim

Vincent,

VB-Oracle can be very stable but like previous posters mentioned, you need a very tightly managed desktop. We have VB-Oracle apps running supporting 3500 users and the desktop is managed by SMS for a "standard" client and to auto-push deployments. If you don't have a tool, it'll be difficult to do deployments and DLL management.

Regarding using Citrix, the network footprint is about 24k per user so you need to make sure you have the bandwidth. Also, latency values can kill you if they're over 100ms. A GUI-driven app with bad latency will drive your users absolutely crazy or else they learn the accelerator keys REAL quick.

Cliff Received on Wed Oct 15 2003 - 13:09:29 CEST

Original text of this message