Re: Remote access

From: Andrew Gould <andrewlylegould(at)gmail(dot)com>
To: George Weaver - Cleartag Software <gweaver(at)cleartagsoftware(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Remote access
Date: 2009-05-08 14:20:38
Message-ID: d356c5630905080720p62c3c58x49096619b4f8f9be@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 8, 2009 at 9:07 AM, George Weaver - Cleartag Software <
gweaver(at)cleartagsoftware(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-05-08 14:27:25 Re: prepared statements and DBD::Pg
Previous Message George Weaver 2009-05-08 14:16:31 Re: Remote access