Re: Remote access

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