On Fri, May 8, 2009 at 9:07 AM, George Weaver - Cleartag Software < gwea...@cleartagsoftware.com> wrote:
> > Hi Andrew, > > Hi, >>> >> > I have a client with a main office and a branch office about 90 miles >>> away. >>> >> > They have a server at the main office but it is not a web server. >>> >> > What would be the best solution for them to access a PostgreSQL database >>> located at the main office from the branch office? >>> >> > I am not "network savvy", but if I get pointed in the right direction I >>> should be able to fill in the blanks. >>> >> > Thanks in advance! >>> >> > The best solution will depend upon the type of activity the branch office >> needs to perform with the database server. >> > > The application is an inventory management system. Their current solution > is an MS Access based system and they use Microsoft Terminal Services to > enable the branch office to access the main office server. They are > considering a move to an application that I provide which utilizes > PostgreSQL. > > Also, what operating system(s) are they running at the branch office? >> > > Everything is Windows based. > > George > > Hi George, MS Access can access PostgreSQL servers via ODBC links. There is an SSL Mode configuration option in the PostgreSQL ODBC driver for security. Best of luck, Andrew
