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/
