Re: Connection string

On Thu, Aug 10, 2006 at 11:57:14AM -0400, Harpreet Dhaliwal wrote:
> This is a simple code snippet that i've written to check if i can connect to
> the postgres database server residing at IP 192.168.0.123. DB name is xyz
> Also, user account jsb has the access to the database xyz.
> ------------------------------------------------------------
> #include 
> 
> EXEC SQL INCLUDE sqlca

I take it you did not copy the file verbatim because this seem to lack
the ';'.

>     EXEC SQL CONNECT TO  'tcp:postgresql://192.168.0.123/xyz' USER jsb

The correct syntax would be:

EXEC SQL CONNECT TO  tcp:postgresql://192.168.0.123/xyz USER jsb;

This should work at least it does for me. :-)

Michael

-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!