Hello Experts,
Trying to run sample Postgrel's ECPG(Embedded SQL)programs on RHL 9.0.

Im unable to connect to PostgreSQL database (sirishadb) when I run the program ....


# su postgres (enter)

# /usr/bin/ecpg -t -I/usr/include/pgsql/sample1.pgc (enter)

# gcc -g -o sample1 -I /usr/include/pgsql sample1.c -lecpg -lpq (enter)

# ./sample1(enter)

Error Code: -220
Message: No such connection NULL in line 12 ,
Rows : 0
Warning:
sql error No such connection Null in line 18


I did lot of 'googling' ,searched usenet groups and changed the following ..............


************************************************************


In the source code (sample1.pcg) ........I tried out various combinations of connect statements they are
---------------------------------------------------------------------

exec sql connect to 'sirishadb@localhost' /* where sirishadb is databasename */

exec sql connect to 'sirishadb@lucky' /* where sirishadb is databasename and lucky is hostname of the server */

exec sql connect to tcpostgresql://localhost:5432/sirishadb as connect_2 user postgresql using post123


In /var/lib/pgsql/data/postgresql.conf
----------------------------------------------------
tcpip_socket = true

In /var/lib/pgsql/data/pg_hba.conf
------------------------------------------------
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all xxx.xxx.xxx.0 255.255.255.0 trust

In /etc/rc.d/init.d/postgresql
--------------------------------------
In this file I added -i to the following statement

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT} -i' start > /dev/null 2>&1" < /dev/null

************************************************************


Plz help me in connecting to the database .........Thanx in advance

Regards,
Vikram



Source code of sample1.pcg
---------------------------
#include <stdlib.h>
#include <stdio.h>

exec sql include sqlca;

main() {

exec sql connect to 'sirishadb@localhost';

/*exec sql connect to tcpostgresql://localhost:5432/sirishadb as connect_2 user postgresql using post123; */


exec sql BEGIN WORK;

exec sql UPDATE XXchildren SET fname = 'Emma' WHERE age = 0;

printf("error code %d, message %s, rows %d, warning %c\n", sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc, sqlca.sqlerrd[2], sqlca.sqlwarn[0]);

exec sql COMMIT WORK;

exec sql disconnect all;

return EXIT_SUCCESS;

}

Hello somebody plzzz help me out ........with the above problem