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
>