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
