Ii can't connect to postgresql with VFP 8

Поиск
Список
Период
Сортировка
От ionut ichim
Тема Ii can't connect to postgresql with VFP 8
Дата
Msg-id BAY106-F345418F785C1F0A197B558C0850@phx.gbl
обсуждение исходный текст
Ответы examples VFP with Postgresql  ("ionut ichim" <ionutichim@hotmail.com>)
Re: Ii can't connect to postgresql with VFP 8  ("Luiz K. Matsumura" <luiz@planit.com.br>)
Список 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/


В списке pgsql-odbc по дате отправления:

Предыдущее
От: greg.campbell@us.michelin.com
Дата:
Сообщение: Re: MSysConf on PG 8.2 ?
Следующее
От: George Weaver
Дата:
Сообщение: Re: ODBC problem with Microsoft Word and Excel