Skip site navigation (1) Skip section navigation (2)

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

From: "ionut ichim" <ionutichim(at)hotmail(dot)com>
To: luiz(at)planit(dot)com(dot)br, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Ii can't connect to postgresql with VFP 8
Date: 2007-03-08 13:39:24
Message-ID: BAY106-F2086D41FD62710DEA57A18C0790@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-odbc
ok..i'll try it. Thanks very much!



>From: "Luiz K. Matsumura" <luiz(at)planit(dot)com(dot)br>
>To: ionut ichim <ionutichim(at)hotmail(dot)com>
>CC: pgsql-odbc(at)postgresql(dot)org
>Subject: Re: [ODBC] Ii can't connect to postgresql with VFP 8
>Date: Wed, 07 Mar 2007 23:31:00 -0300
>
>Try :
>
>lnConn = SQLSTRINGCONNECT([Driver={PostgreSQL 
>Unicode};Server=127.0.0.1;Port=5432;Database=persoane;Uid=postgres;Pwd=123456])
>
>
>Hope this helps
>
>
>ionut ichim wrote:
>>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
>>
>>
>
>--
>Luiz K. Matsumura
>Plan IT Tecnologia Informtica Ltda.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


In response to

pgsql-odbc by date

Next:From: Brodie ThiesfieldDate: 2007-03-08 14:06:00
Subject: BLOB via ODBC
Previous:From: ionut ichimDate: 2007-03-08 13:38:18
Subject: Re: examples VFP with Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group