This does not sound like a problem with your useage of libpq.dll, but more
that the backend is not accepting IP based connections. Can you connect with
pgAdmin II or orther ODBC vehicles?
If not, then look at pg_hba.conf to see which connections configuration
options are active..
On May 31, 2003 04:15 am, Michael Vodep wrote:
> Hi!
> I tryed to connect my PostgreSQL Database - running on FreeBSD - with an
> Windows Client for many
> times.
> ---------------------------------------------------------------------------
>---------------------- PGconn *conn;
> conn = PQsetdbLogin("192.168.1.34", "5432", NULL, NULL,
> "mainhm","mike","****");
>
> CString err;
> if (PQstatus(conn) == CONNECTION_BAD) {
> err.Format("Es ist ein Fehler aufgetretenn%s", PQerrorMessage(conn));
> AfxMessageBox(err, MB_ICONSTOP | MB_OK);
> TRACE("%s",
> err);
> PQfinish(conn);
> }
> ---------------------------------------------------------------------------
>----------------------
>
> My second
> attempt:
> ---------------------------------------------------------------------------
>---------------------- PGconn *conn;
> conn = PQconnectdb("hostaddr='192.168.1.34'
> port='5432'");
> ---------------------------------------------------------------------------
>---------------------- I get errors , durring i try to connect with
> PQsetdbLogin:
> "connectDBStart() -- connect() failed Is the postmaster running (with -i)
> at '192.168.1.34' and accepting connections on TCP/IP port 5432?"
>
> If i try to connect with PQconnectdb, the postmaster says: "Unexpected EOF
> of client connection"
> The Client says: "fe_sendauth: authentication type 5 not supported"
>
> What have I done wrong??
> thx Michael
> I use M$ VC++ 6 SP 5 on Win2000 SP3