Re: [INTERFACES] Win32 interface

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
>