i can't connect to postgresql with VFP 8 - Mailing list pgsql-odbc

From ionut ichim
Subject i can't connect to postgresql with VFP 8
Date
Msg-id BAY106-F4E35A9637423622465FCCC0850@phx.gbl
Whole thread Raw
List pgsql-odbc
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 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 !

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


pgsql-odbc by date:

Previous
From: "Andrus"
Date:
Subject: Re: Ii can't connect to postgresql with VFP 8
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1002503 ] ODBC Failure