Yep I'm using the PQconnectDB("host=blah user=blah dbname=blah");
I noticed that psql.c uses the PQsetdbLogin maybe I should switch to that
function if this one is broken? Would have to parse a little extra but..
Here is the snippet... my char *dbname comes in the form of:host=hostname;dbname=database;port=portnum
int
pg_login(struct dbi *dbi, char *dbname, char *user, char *pass)
{char *connect;char *source;char *dest;char *src;int mem;int sourcelen;mem = strlen(dbname);source = malloc(mem +
10);if(user && pass) { mem += strlen(user) + strlen(pass);} else if (user) { mem += strlen(user);}src =
dbname;dest= source; while (*src) { if (*src != ';') { *dest++ = *src++; continue; }
*dest++= ' '; src++;} *dest = '\0'; if (LOG_LEVEL >= 3) { fprintf(stderr,"pg_login: source ->
%s\n",source);}sourcelen= strlen(source); if (user && pass) { connect =
malloc(sourcelen+strlen(user)+strlen(pass)+13); sprintf(connect,"%s user=%s pass=%s",source, user, pass);} else if
(user){ connect = malloc(sourcelen+strlen(user) + 7); sprintf(connect,"%s user=%s",source, user);} else {connect
=malloc(sourcelen + 1);sprintf(connect,"%s",source); } if (LOG_LEVEL >= 2) { fprintf(stderr,"pg_login:
%s\n",connect);}dbi->conn= PQconnectdb(connect);
<SNIP>
On Thu, 2 Sep 1999, Ken J. Wright wrote:
> At 14:02 09/02/1999 -0700, David Giffin wrote:
> >
> >I'm trying to use the postgresql win32 interface to connect ot a UNIX
> >host. I'm using PQconnectDB() to get the connection. Each time I try to
> >connect it says unknown host name:
> >
> >connectDB() -- unknown hostname: mobile
> >
> >reguardless of specifying the ip address or the complete host name. Any
> >ideas??
>
> are you using the proper parameter string?
> PQconnectDB('host=hostname dbname=databasename user=username')
>
> Otherwise maybe send code snippet to look at?
>
> Ken
>