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

On 03/09/2011 08:30 AM, John Edens wrote:

Hey guys, I'm trying to get a VB program to make a client connection to
my PostgreSQL server running on an

Ubuntu 10.10 server.

Here's what I've done:

Client side - installed and registered the OLE DB .dll's from the
PostgreSQL OLE DB Provider project.

server side -

the configuration described here:
https://help.ubuntu.com/10.10/serverguide/C/postgresql.html

---------------

Have added this line to postgresql.conf:

listen_addresses = '*, 144.96.80.35, localhost'

I would stick with listen_addresses = '*', this covers all the bases and
simplifies things for the time being.

I've also tried this as simply:

listen_addresses = '144.96.80.35, localhost'

also, port = 5432

--------------

I have added the following to pg_hba.conf:

# IPv4 local connections:

host all all 144.96.80.35 255.255.255.0 md5

local all postgres md5

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 :)

--------------

I've got the following code going in VB:

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Const connString As String = "Provider=PostgreSQL; Server=144.96.80.35;
User Id=postgres;Password=postgres;"

Dim theOleDBconnection As New OleDb.OleDbConnection

theOleDBconnection.ConnectionString = connString

theOleDBconnection.Open()

End Sub

End Class

So when the project opens up, it should make the connection and display
the form.

What happens is that I get an error...

OleDbException was unhandled

could not connect to server: Connection refused (0x0000274D/10061)

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

Is the server running on host "" and accepting

TCP/IP connections on port 5432?

---------------------------

So, obviously I've got something configured incorrectly.

I'm troubled that the VB error seems to show a null value for the host.
Shouldn't that be the Server value in

the connection string?

Thanks to all for any help�

--
Adrian Klaver
adrian.klaver@gmail.com

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?

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

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