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

2011-03-09 Thread John Edens
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 config

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

2011-03-09 Thread John Edens
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 configura

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

2011-03-09 Thread John Edens
Using * should be fine unless you have multiple IP addresses and want the *server* to *listen* on only some of those addresses - say localhost if you were running web and db on the same machine and didn't want to listen to connections from the outside. This setting only determines whe

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

2011-03-09 Thread John Edens
>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 >conne

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

2011-03-09 Thread John Edens
Thanks for that explanation, Steve. This is my first time doing much of anything with a server, so that's all good to know! John Your server can have multiple IP addresses. In fact, it almost certainly has an IP assigned to your NIC and a localhost address. But you could have mult

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

2011-03-09 Thread John Edens
That's a great site - I am now making a connection. Thanks for all the help! John -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Wednesday, March 09, 2011 12:28 PM To: John Edens Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to configur