Attempt to connect to database using libpq++ PgDatabase class fails because CONNECTION_BAD

From: "Debra LaVille" <debra(dot)laville(at)digeo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Paul Meisenheimer" <Paul(dot)Meisenheimer(at)digeo(dot)com>
Subject: Attempt to connect to database using libpq++ PgDatabase class fails because CONNECTION_BAD
Date: 2002-08-28 22:46:30
Message-ID: 4C568C6A13479744AA1EA3E97EEEB32301B41E26@schumi.digeo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am porting code from Red Hat Linux to Windows 2000 and can not connect to a
my database using libpq++.

I have installed CygIPC and PostgreSQL as Services on my Windows 2000 PC.
I have created a database (called mediadb).
I have added tables to the database.
I have added data to the tables.

I can access the database using psql from a Cygwin Bash Shell (e.g.):

$psql -q -d mediadb -U mediadbuser

mediadb=# select count(*) from guide_programinfo;
count
-------
24532
(1 row)

I can not access the database from my application using libpq++ (CONNECTION_BAD):

#include <stdio.h>
#include <iostream>
#include <string>
#include "libpq++\pgdatabase.h"

using namespace std;

int main(int argc, char* argv[])
{
PgDatabase myDB("dbname=mediadb user=mediadbuser");

if ( myDB.ConnectionBad() )
{
>>> cout << "Failed to open <dbname=mediadb user=mediadbuser>" << endl;
}
else
{
cout << "Opened <dbname=mediadb user=mediadbuser>" << endl;
}

return 0;
}

I am using standard (unmodified) configuration files:

C:\cygwin\usr\share\postgresql\data\pg_hba.conf
C:\cygwin\usr\share\postgresql\data\postgresql.conf
...

Any help would be greatly appreciated!

Debra L. LaVille
debra(dot)laville(at)digeo(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Rice 2002-08-28 22:47:24 Re: pgsql on jaguar (os x 10.2)
Previous Message Bruce Momjian 2002-08-28 21:33:34 Re: worried about PGPASSWORD drop