Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? - Mailing list pgsql-general

From John Edens
Subject Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?
Date
Msg-id 002001cbde83$c90b3cb0$5b21b610$@sfasu.edu
Whole thread Raw
In response to Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
>If I am following, 144.96.80.35 is your server address not the clients.
>In pg_hba.conf the IPs are those from the clients you want to let in, so
>you will need to use an IP or mask that matches that of your client. To
>reduce confusion you might want to do that in the section for remote
>connections :)

>Per the explanation above your client IP does not have access to the
server.

Okay, I have set the mask as described...

I can now use pgAdmin III to access the database on the server from my
desktop machine, which I could not previously do.

However, the VB code still gives the error previously described.

Thanks for the config file help - any ideas about the OLE DB connection
problem?


pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Copying data from one table to another - how to specify fields?
Next
From: Adrian Klaver
Date:
Subject: Re: Why length(to_char(1::integer, '9')) = 2 ?