Re: Ii can't connect to postgresql with VFP 8

["ionut ichim" <ionutichim(at)hotmail(dot)com>]

ok..i'll try it. Thanks very much!



> From: "Luiz K. Matsumura" <luiz(at)planit(dot)com(dot)br>
> To: ionut ichim <ionutichim(at)hotmail(dot)com>
> CC: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Ii can't connect to postgresql with VFP 8
> Date: Wed, 07 Mar 2007 23:31:00 -0300
>
> Try :
>
> lnConn = SQLSTRINGCONNECT([Driver={PostgreSQL 
> Unicode};Server=127.0.0.1;Port=5432;Database=persoane;Uid=postgres;Pwd=123456])
>
>
> Hope this helps
>
>
> ionut ichim wrote:
> > I want to try postgresql with VFP 8 sp1, but i can't connect to new 
> > created database.
> > I've installed pq + odbc driver. With pgAdminIII,I can connect to my 
> > database using  password '123456' and default user 'postgres',default port 
> > 5432 ,but with VFP i can't.Connection is a local one
> > This is the code I use (it always gives me 'Couldn't connect to the 
> > database!') :
> >
> >
> > Local lnConn
> > lnConn = 
> > SQLSTRINGCONNECT([Driver={PostgreSQL};Server=127.0.0.1;Port=5432;Database=persoane;Uid=postgres;Pwd=123456])
> >
> > If lnConn < 0
> >  MessageBox( "Couldn't connect to the database !" )
> > ELSE
> >  MessageBox( "OK !" )
> >  =SQLDisconnect( lnConn )
> >
> > Endif
> >
> > Thanks !
> >
> > _________________________________________________________________
> > Express yourself instantly with MSN Messenger! Download today it's FREE! 
> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Have you searched our list archives?
> >
> >               http://archives.postgresql.org
>
> --
> Luiz K. Matsumura
> Plan IT Tecnologia Informática Ltda.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/