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

Use

SQLSTRINGCONNECT([Driver=PostgreSQL
Unicode;Host=127.0.0.1;Database=persoane;User=postgres;Password=123456])

""ionut ichim"" <ionutichim(at)hotmail(dot)com> wrote in message
news:BAY106-F345418F785C1F0A197B558C0850(at)phx(dot)gbl(dot)(dot)(dot)
>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
>