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

Поиск
Список
Период
Сортировка
От John Edens
Тема Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?
Дата
Msg-id 002b01cbdea2$a496de10$edc49a30$@sfasu.edu
обсуждение исходный текст
Ответ на 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>)
Список pgsql-general
That's a great site - I am now making a connection.

Thanks for all the help!
John

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Wednesday, March 09, 2011 12:28 PM
To: John Edens
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to configure for remote TCP/IP client
conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?

On 03/09/2011 09:59 AM, John Edens wrote:
>> 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?
>

What I know about OLE would fit in the navel of a flea:) That being said I
offer:
http://www.connectionstrings.com/postgre-sql#p53

It would seem your connection string needs different information.


--
Adrian Klaver
adrian.klaver@gmail.com


В списке pgsql-general по дате отправления:

Предыдущее
От: John Edens
Дата:
Сообщение: Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?
Следующее
От: Vlad Romascanu
Дата:
Сообщение: Reinterpreting BYTEA as TEXT, converting BYTEA to TEXT