Thank all, for your comments.
You are just confirming what I thought an R:BASE solution would not
work.
I could offer a Cytrix thin client solution but
that means a large cost to the customer and I am sure they would be
prepared
to spend the cost.
Has anyone got experience with an Oracle ODBC connection. I know the ODBC
connection
would slow it up but will the application behave like true client server
with only the
data being passed over the slow LAN ?
Regards
Victor
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Alastair Burr
> Sent: Tuesday, 5 March 2002 6:01 AM
> To: [EMAIL PROTECTED]
> Subject: Re: RE: Some advice please on ODBC connection to ORACLE
>
>
> And I can second Albert's comments!
>
> Although PCAnyWhere is not the _best_ solution - using TCP/IP across the
> network (LAN or WAN) is certainly usable and (relatively) cheap. I guess,
> though, that it will be a question for "horses for courses" in
> the long run.
> Probably worth starting out with PCAnyWhere and then upgrading if
> needs be.
>
> Regards, Alastair.
>
>
> ----- Original Message -----
> From: "Albert Berry" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, March 04, 2002 4:44 PM
> Subject: RE: RE: Some advice please on ODBC connection to ORACLE
>
>
> > I can second Troy's comments. I have used PC Anywhere for years with
> R:Base applications. The benefit Troy did not mention was that a dropped
> connection has no effect on the database, because the database is not
> disconnected prematurely, only the connection to the PC that is
> connected to
> the database.
> >
> > We all know what happens to databases when a connection is
> dropped by the
> three finger salute, or the dog sticking wet nose against power switch, or
> klutz (who will remain unnamed due to red face problems) trips over the
> power cord.
> >
> >
> >
> > Troy Sosamon <[EMAIL PROTECTED]> wrote:
> >
> > >Victor,
> > >
> > >If you want to connect to R:base over a slow WAN connections, you will
> want
> > >to use either a web server or some type of remote control software like
> PC
> > >Anywere.
> > >
> > >R:base is not a client server database, it is workstation based which
> means
> > >that you can put your database in a central location on a shared hard
> drive,
> > >but when you access and manipulate the data, it is being done from the
> > >workstation and all of the processing is done at the
> workstation, so all
> the
> > >data needed to do the process has to be passed to the
> workstation. When
> you
> > >do this over a slow connection, it is extremly slow because of all the
> data
> > >that needs to be passed.
> > >
> > >I currently have 7 dedicated PC Anywhere machines that people use to
> access
> > >my database. I am in the process of converting eveything to Tango and
> using
> > >a web server to access everything, but it is a big project and
> takes time
> > >and money to complete. There are several other remote access
> methods to
> use
> > >besides PC Anywhere like Terminal server.
> > >
> > >The point is, you really don't want to connect to your database over a
> slow
> > >WAN, you want to put a dedicated workstation on the fast network with
> your
> > >database and do remote control of that workstation so that only the
> screen
> > >and keyboard data needs to be sent across the wan.
> > >
> > >Troy Sosamon
> > >Denver, Co.
> > >
> > >
> > >===== Original Message from [EMAIL PROTECTED] at 3/04/02 3:27 am
> > >> Can anyone give me some advise.
> > >> I have created an R:BASE application for a nursing community services
> group
> > >>and they love the business fit.
> > >> I have an opportunity to tender for a job for another service and my
> R:BASE
> > >>applications fills most of the specifications but the customer is
> wanting
> > >>to access the data base over a
> > >> 64 kbps digital link in a WAN from remote locations.
> > >> They are also want the data base back end to be Oracle. I can create
> all
> > >>the tables in
> > >> Orackle and sconnect to all the tables and load my R:BASE runtime
> engine
> > >>with the R:Base reports and forms on the work stations.
> I have no
> > >>experience in Oracle connection from the R:BASE front via a ODBC link
> and
> > >>lesser experience in running it over a 64kbps connection.
> > >>
> > >> I would appreciate anyone experience in doing this WAN application.
> > >>
> > >> All help Please.
> > >>
> > >> Thanks
> > >>
> > >> Victor
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>================================================
> > >>TO SEE MESSAGE POSTING GUIDELINES:
> > >>Send a plain text email to [EMAIL PROTECTED]
> > >>In the message body, put just two words: INTRO rbase-l
> > >>================================================
> > >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > >>In the message body, put just two words: UNSUBSCRIBE rbase-l
> > >>================================================
> > >>TO SEARCH ARCHIVES:
> > >>http://www.mail-archive.com/rbase-l%40sonetmail.com/
> > >
> > >================================================
> > >TO SEE MESSAGE POSTING GUIDELINES:
> > >Send a plain text email to [EMAIL PROTECTED]
> > >In the message body, put just two words: INTRO rbase-l
> > >================================================
> > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > >In the message body, put just two words: UNSUBSCRIBE rbase-l
> > >================================================
> > >TO SEARCH ARCHIVES:
> > >http://www.mail-archive.com/rbase-l%40sonetmail.com/
> > >
> > --
> >
> >
> >
> >
> > __________________________________________________________________
> > Your favorite stores, helpful shopping tools and great gift ideas.
> Experience the convenience of buying online with Shop@Netscape!
> http://shopnow.netscape.com/
> >
> > Get your own FREE, personal Netscape Mail account today at
> http://webmail.netscape.com/
> >
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
