With your suggestion works,thanks !
Thanks to Luiz K. Matsumura.
>From: "Andrus" <kobruleht2@hot.ee>
>To: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] Ii can't connect to postgresql with VFP 8
>Date: Tue, 6 Mar 2007 18:04:31 +0200
>
>Use
>
> SQLSTRINGCONNECT([Driver=PostgreSQL
>Unicode;Host=127.0.0.1;Database=persoane;User=postgres;Password=123456])
>
>""ionut ichim"" <ionutichim@hotmail.com> wrote in message
>news:BAY106-F345418F785C1F0A197B558C0850@phx.gbl...
> >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
> >
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/