LOl..that ';' is quite obvious. Though i forgot to include that in the mail.
Sorry about that.
Also, do u think that while starting the postgresql server using 'pg_ctl start', there is some -i option that needs to be included with it so that the DB server accepts tcp connections?
One of the guys in the postgres community was talking about it. don't know how true is that because there's no such option like that for pg_ctl start in the postgres manual.
Can you please comment on that?
~Harpreet.
On 8/11/06, Michael Meskes <meskes@postgresql.org> wrote: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 <stdio.h>
>
> 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!