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: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
