| From: | "ionut ichim" <ionutichim(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Ii can't connect to postgresql with VFP 8 |
| Date: | 2007-03-04 12:55:27 |
| Message-ID: | BAY106-F345418F785C1F0A197B558C0850@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Weaver | 2007-03-05 15:19:46 | Re: ODBC problem with Microsoft Word and Excel |
| Previous Message | ionut ichim | 2007-03-04 12:09:18 | i can't connect to postgresql with VFP 8 |