Re: VB/Access frontend access to Oracle over ODBC

Space used at time for
Datas ap. 4,5 GB
Indexes ap. 800 MB
(without space in temporary, rollback or system Tablespaces)

In article <38E1B0BC.D43E11D4_at_logica.com>, Andre Kerstens <kerstensa_at_logica.com> wrote:
> What's approx. the size of the database your using?
>
> efflerch_at_my-deja.com wrote:
>
> > In article <38E0597F.FEC1C736_at_logica.com>,
> > Andre Kerstens <kerstensa_at_logica.com> wrote:
> > > Hi,
> > >
> > > Does anybody have any experience in using VB/Access frontends
> > connecting
> > >
> > > to an Oracle db over ODBC? I'm especially interested in the
> > performance
> > > of
> > > this combination... Maybe other possibilities here? Client likes
to
> > keep
> > > its MS frontends, but wants to migrate to Oracle on unix.
> > >
> > > Cheers
> > >
> > > Andre
> > >
> > >
> > we re using Clientsoftware (app 100 users) accessing Oracle over
odbc.
> > There are no technical problems and performance is for our tasks
also
> > ok. You are also able to access Unix(we have Linux) without problems
> > - but -
> > you have a lot administrative efforts. You have to install Odbc
driver,
> > Oracle client software your MSWin application and over the years you
> > get problems because Windows computers after same months never
> > installed equaly - so my experience is that you have a lot of
trouble
> > with dll's heaps of versions of odbc drivers and if you change your
> > database-server(different IP) you have to configure the clients
> > tnsnames.ora and so on
> >
> > We have start to migrate to a citrix terminalserver on which the
> > VB-application is installed. And all User can acces apllication via
> > browser in intranet. So now i have only to administrate one
> > terminalserver + databasesserver and not 100 clients
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 04:59:06 CST