[RBG7-L] - Re: Remote ODBC connection

[Troy Sosamon]

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