----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, October 05, 2004 12:01 AM Subject: [RBG7-L] - Re: Remote ODBC connection
> There are several ways to do this, and some good ones have been suggested. > > Let me make sure I understand what you need to do. > > > > Your local office has R:base running. > > You have a remote office using AccPac. > > On demand you need to pull some data out of the remote AccPac system and > load it into R:base. > > > > The best way to do this really depends on what capabilities and equipment > your offices already have. > > > > First thing you need is the AccPac ODBC data connector. > > > > If you have a VPN between the local and remote offices, you could map a > drive and use an ODBC connection from R:base to AccPac. It would be slow, > but if you are not pulling too much data, it should be ok. This would be > the simplest method. > > > > Otherwise you would have to have a web server running at the remote site, > and it needs access to the AccPac database, something could be written that > could pull the data from AccPac, build an XML file and send the file to the > requester. The best way to do this depends on the web server running and > what tools you have available. If you have Tango, it could be done in > Tango, if you don't and it is an IIS server, it could be written in DotNet It can be done simply using ADO to create the XML and creating an ASP page on the fly that returns the XML as a Stream. Here is a link to show the structure: http://www.able-consulting.com/MDAC/ADO/Connection/Recordset_URL.htm#AdoUrlConnectionADORecordset > as a web service to take a request and return an XML stream that would then > be loaded into R:base. > > > > > > Troy Sosamon > > > > > > > > _____ > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Monday, October 04, 2004 12:19 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: Remote ODBC connection > > > > I need to make an ODBC connection with a remote database using Rbase. The > purpose is to retrieve some real time data from an existing order entry > package. (AccPac) I will be obtaining only about 5 fields of information, > one record at a time. However, the information needs to be current and the > query could take place at random. So ideally, it would be nice for the > program to have the ability to use an ODBC connection over the inter-net. > (This particular application will not allow Terminal Services) > > Any thoughts as to how this is done and any major concerns on using it if > possible. It is my understanding that one can make an ODBC use an IP > address. > > Thank you, > > Bob Thompson > >
