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" <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
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