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

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

From: "Luiz K(dot) 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: Ii can't connect to postgresql with VFP 8
Date: 2007-03-08 02:31:00
Message-ID: 45EF7564.9020502@planit.com.br (view raw or flat)
Thread:
Lists: pgsql-odbc
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 Informática Ltda.


In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2007-03-08 05:06:16
Subject: Re: ODBC problem with Microsoft Word and Excel
Previous:From: Paul LambertDate: 2007-03-08 02:27:43
Subject: Access violation - probably not the fault of Postgres

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